我想将工作表从现有的XLS文档复制到新的文档中,再复制到新位置。
我如何用JXL做到这一点?
Workbook w1 = Workbook.getWorkbook(new File("ExistingDocument.xls"), settings);
WritableWorkbook w2 = Workbook.createWorkbook(new File("NewDocument.xls"));
/* So here, I would like copy the first sheet from w1 to the second sheet of w2 ... */
w2.write();
w2.close();
w1.close();
编辑:
w1.getSheet(0).getCell(0, 0)不是WritableCell,所以我无法使用该copyTo方法。
有什么方法可以w1向w2工作簿添加单元格/ 工作表吗?
edit2:
那么我是否必须将工作簿的可写副本创建到另一个文件?
( edit3: 或者还有其他免费的lib可以做到这一点吗?)
更新:
当我运行此代码时,我会jxl.common.AssertionFailed在网上看到异常
WritableCellFormat newFormat = new WritableCellFormat(readFormat);
如果我删除此行并将代码更改为
newCell.setCellFormat(readFormat);
那么就不会复制单元格样式(字体,单元格边框等)。
try {
Workbook sourceDocument = Workbook.getWorkbook(new File("C:\\source.xls"));
WritableWorkbook writableTempSource = Workbook.createWorkbook(new File("C:\\temp.xls"), sourceDocument);
WritableWorkbook copyDocument = Workbook.createWorkbook(new File("C:\\copy.xls"));
WritableSheet sourceSheet = writableTempSource.getSheet(0);
WritableSheet targetSheet = copyDocument.createSheet("sheet 1", 0);
for (int row = 0; row < sourceSheet.getRows(); row++) {
for (int col = 0; col < sourceSheet.getColumns(); col++) {
WritableCell readCell = sourceSheet.getWritableCell(col, row);
WritableCell newCell = readCell.copyTo(col, row);
CellFormat readFormat = readCell.getCellFormat();
/* exception on the following line */
WritableCellFormat newFormat = new WritableCellFormat(readFormat);
newCell.setCellFormat(newFormat);
targetSheet.addCell(newCell);
}
}
copyDocument.write();
copyDocument.close();
writableTempSource.close();
sourceDocument.close();
} catch (Exception e) {
e.printStackTrace();
}
如何将单元格样式也复制到新单元格?