本帖最后由 Wilson.Zhang 于 2025-11-28 12:11 编辑
产品:GcExcel
版本:8.2.4
调研编号:GCEXCEL-11853
LastReview : 2025-11-28
当前进展:已在8.2.5版本修复。
代码:
- public static void main(String[] args) {
- Workbook workbook = new Workbook();
- workbook.open("/Users/dzy/beikeRepo/excel-files/场景2/20251121-6347-c45f77be5fcd4493aaf7af36429fe7e3.xlsx");
- Workbook toWorkbook = new Workbook();
- IWorksheet toWorksheet = toWorkbook.getWorksheets().add();
- toWorkbook.getWorksheets().get(0).delete();
- toWorksheet.setName("复制结果");
- workbook.getWorksheets().get("sheet1").getUsedRange().copy(toWorksheet.getRange(workbook.getWorksheets().get("sheet1").getUsedRange().getAddress()), EnumSet.of(PasteType.Values, PasteType.NumberFormats));
- toWorkbook.save("复制结果.xlsx");
- }
复制代码
问题点:
复制结果出现了NA,原文件没有
复现环境:
Mac或Linux
GcExcel8.2.4
|