//注：this.fWorkbook是一個HSSHWorkbook，請自行在外部new public void copyRows(String pSourceSheetName, String pTargetSheetName, int pStartRow, int pEndRow, int pPosition) { HSSFRow sourceRow = null; HSSFRow targetRow = null; HSSFCell sourceCell = null; HSSFCell targetCell = null; HSSFSheet sourceSheet = null; HSSFSheet targetSheet = null; Region region = null; int cType; int i; short j; int targetRowFrom; int targetRowTo;
if ((pStartRow == -1) (pEndRow == -1)) { return; } sourceSheet = this.fWorkbook.getSheet(pSourceSheetName); targetSheet = this.fWorkbook.getSheet(pTargetSheetName); //拷貝合并的單元格 for (i = 0; i < sourceSheet.getNumMergedRegions(); i++) { region = sourceSheet.getMergedRegionAt(i); if ((region.getRowFrom() >= pStartRow) && (region.getRowTo() <= pEndRow)) { targetRowFrom = region.getRowFrom() - pStartRow + pPosition; targetRowTo = region.getRowTo() - pStartRow + pPosition; region.setRowFrom(targetRowFrom); region.setRowTo(targetRowTo); targetSheet.addMergedRegion(region); } } //設置列寬 for (i = pStartRow; i <= pEndRow; i++) { sourceRow = sourceSheet.getRow(i); if (sourceRow != null) { for (j = sourceRow.getFirstCellNum(); j < sourceRow.getLastCellNum(); j++) { targetSheet.setColumnWidth(j, sourceSheet.getColumnWidth(j)); } break; } } //拷貝行并填充數據 for (;i <= pEndRow; i++) { sourceRow = sourceSheet.getRow(i); if (sourceRow == null) { continue; } targetRow = targetSheet.createRow(i - pStartRow + pPosition); targetRow.setHeight(sourceRow.getHeight()); for (j = sourceRow.getFirstCellNum(); j < sourceRow.getLastCellNum(); j++) { sourceCell = sourceRow.getCell(j); if (sourceCell == null) { continue; } targetCell = targetRow.createCell(j); targetCell.setEncoding(sourceCell.getEncoding()); targetCell.setCellStyle(sourceCell.getCellStyle()); cType = sourceCell.getCellType(); targetCell.setCellType(cType); switch (cType) { case HSSFCell.CELL_TYPE_BOOLEAN: targetCell.setCellValue(sourceCell.getBooleanCellValue()); break; case HSSFCell.CELL_TYPE_ERROR: targetCell.setCellErrorValue(sourceCell.getErrorCellValue()); break; case HSSFCell.CELL_TYPE_FORMULA: //parseFormula這個函數的用途在后面說明 targetCell.setCellFormula(parseFormula(sourceCell.getCellFormula())); break; case HSSFCell.CELL_TYPE_NUMERIC: targetCell.setCellValue(sourceCell.getNumericCellValue()); break; case HSSFCell.CELL_TYPE_STRING: targetCell.setCellValue(sourceCell.getStringCellValue()); break; } } } }
我上poi論壇查相關帖子，得到兩種結論：1、不支持寫入圖片；2、支持寫入圖片，通過EscherGraphics2d這個Class實現。于是我就去查EscherGraphics2d這個Class，發現這個Class提供了N個drawImage方法，喜出望外的我開始寫代碼，結果調了一天，一直看不到效果，黔驢技窮的我在萬般無奈下只好跟蹤進drawImage這個函數內部，經過N個函數調用后在最底層函數發現了最終答案（偶當場暴走?。。。?br /> public boolean drawImage(Image image, int dx1, int dy1, int dx2, int dy2, int sx1, int sy1, int sx2, int sy2, Color bgColor, ImageObserver imageobserver) { if (logger.check( POILogger.WARN )) logger.log(POILogger.WARN,"drawImage() not supported"); return true; } 所以我強烈建議大家，以后使用第三方開發包一定盡量下載它的源代碼，這樣你在碰到問題時，看看它的的內部是怎么實現的，很多時候就可以不必重蹈我的覆轍了。既然POI不能寫入圖片，那我們只能把目光投向JXL，我用JXL寫入圖片功能是實現了，付出的代價是now()和today()這些函數丟失掉了，魚與熊掌不能兼得吧，至于怎么解決JXL公式的問題，到下面這個帖子里和我一起守株待兔吧：
