JAVAµ¼³öexcel±¨±í

<p></p>
<p class="MsoNormal"><span>1¡¢Ê¹ÓÃ</span><span lang="en-us">POI</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us">A</span><span>£©ÏÂÔصØÖ·</span><span lang="en-us"><a data-token="689cccc4afb4b9723d4f8dedf7dc3923" href="http://poi.apache.org/download.html" rel="nofollow">http://poi.apache.org/download.html</a></span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us">B</span><span>£©Ê¹Ó÷½Ê½</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 1</span><span>¡¢×¼±¸Ò»¸ö¼òµ¥µÄ</span><span lang="en-us">excel</span><span>Îĵµ£¨¾²Ì¬µÄÊý¾Ý¶¼ÏÈÌîдÉÏÈ¥£©£¬·ÅÈëµ½ÏîÄ¿</span><span lang="en-us">src</span><span>·¾¶ÏÂÖÐ</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 2</span><span>¡¢ÔÚ</span><span lang="en-us">action</span><span>ÖжÁÈ¡</span><span lang="en-us">excel</span><span>Îĵµ£¬²¢´´½¨Ò»¸ö</span><span lang="en-us">excel</span><span>Îĵµ¶ÔÏó</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> String filename =
PropertyUtil.getPropertyValue(¡°</span><span>ÅäÖÃÎļþ·¾¶</span><span lang="en-us">¡±)+¡±</span><span>ÎļþÃû</span><span lang="en-us">¡±;</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> HSSFWorkbook wb = new
HSSFWorkbook(new FileInputStream(filename));</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 3</span><span>¡¢»ñȡÿһ¸ö·ÖÒ³µÄ¶ÔÏóÎĵµÖÐĬÈÏÓÐÈý¸ö</span><span lang="en-us">sheet</span><span>£¬Ä¬ÈϵÚÒ»¸öϽDZêΪ</span><span lang="en-us">0</span><span>¡£</span><span lang="en-us">   HSSFSheet
sheet0 = wb.getSheetAt(0);//</span><span>»ñÈ¡µÚÒ»¸ö</span><span lang="en-us">sheet</span><span>¡£</span><span lang="en-us">1</span><span>£¬</span><span lang="en-us">2</span><span>±íʾºóÃæÁ½¸ö</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 4</span><span>¡¢¶¯Ì¬¼ÓÈëÊý¾Ý</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 1</span><span>¡¢´´½¨Ò»¸öÐÐ</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> Row row = sheet0.createRow(¡°</span><span>µÚ¼¸ÐÐ</span><span lang="en-us">¡±);</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 2</span><span>¡¢ÔÚÕâÒ»Ðд´½¨</span>
<span>Ò»¸öµ¥Ôª¸ñ</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> Cell cell = row.createCell(</span><span>µÚ¼¸¸ö</span><span lang="en-us">);</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 3</span><span>¡¢ÍùÀïÍ·ÌîÊý¾Ý</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> cell.setCellValue(¡°</span><span>ÎÒµÄÊý¾Ý</span><span lang="en-us">¡±);</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 5</span><span>¡¢ÌØЧ</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 1</span><span>¡¢µ¥Ôª¸ñºÏ²¢</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> Sheet0.addMergedRegion(new
CellRangeAddress(</span><span>Ëĸö²ÎÊý·Ö±ð±íʾÐУ¬ÁÐ×ø±ê</span><span lang="en-us">));//</span><span>ºÏ²¢ÕâÀïÃæµÄ·¶Î§µ½Ò»¸öµ¥Ôª¸ñÖÐ</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> 2</span><span>¡¢µ¥Ôª¸ñÑùʽ</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> Cell.setCellStyle(</span><span>Ò»¸öÑùʽ¶ÔÏó</span><span lang="en-us">CellStyle</span><span>ÀàÐÍ</span><span lang="en-us">);</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> CellStyle style =
wb.createCellStyle();</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> Style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);</span></p>
<p class="MsoNormal" style="text-indent:21pt;"><span lang="en-us"> Style.setBorderTop(CellStyle.BORDER_THIN);</span><span>µÈµÈ</span></p>
<p class="MsoNormal" style="margin-left:63pt;text-indent:21pt;"><span lang="en-us">//</span><span>»¹Óкܶà¿ÉÒԲ鿴</span><span lang="en-us">POI</span><span>Îĵµ</span></p>
<p class="MsoNormal"><span lang="en-us"> C</span><span>£©ºÃ»µ</span></p>
<p class="MsoNormal"><span lang="en-us"> 1</span><span>¡¢ºÃ´¦£º¿ØÖÆÁ¦Ç¿£¬ÊÇÎÒÃÇÊìϤµÄ</span><span lang="en-us">java</span><span>´úÂ룬²»¹ýÐèÒªÊìϤµÚÈý·½</span><span lang="en-us">API</span></p>
<p class="MsoNormal"><span lang="en-us"> 2</span><span>¡¢È±µã£º´úÂëÁ¿±È½Ï´ó</span></p>
<p></p>
<p>2¡¢Ê¹ÓÃexcelÄ£°å·½Ê½</p>
<p><span> </span>1¡¢ÖÆ×÷ÄãÏëÒªµÄexcelÎĵµ£¬Áпí¶È¡¢×ÖÌåµÈÉèÖúᣣ¨×÷Ϊģ°å