在现有excel文件中添加工作表

Question

我尝试了各种方式添加Excel电子表格。但问题总是相同的。

我尝试了这里提出的代码，

• 将工作表添加到现有excel文件
• 使用Apache POI for Java在现有Excel工作簿中创建新工作表

问题是:

Exception in thread "main" java.lang.ClassCastException: org.apache.poi.hssf.record.BOFRecord cannot be cast to org.apache.poi.hssf.record.TabIdRecord
    at org.apache.poi.hssf.model.InternalWorkbook.fixTabIdRecord(InternalWorkbook.java:792)
    at org.apache.poi.hssf.model.InternalWorkbook.checkSheets(InternalWorkbook.java:742)
    at org.apache.poi.hssf.model.InternalWorkbook.setSheetName(InternalWorkbook.java:579)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:748)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:101)
    at ReadTry.main(ReadTry.java:28)

Answer 1

相同的代码对我有用

public class Modify {
   public static void main(String[] args) throws Exception {
    File f=new File("d:/temp/wb.xls");
    Workbook wb = WorkbookFactory.create(f);
    wb.createSheet("sheet2");
    FileOutputStream out = new FileOutputStream("d:/temp/wb1.xls");
    wb.write(out);
    out.close();
  }
} 

我用poi-3.9-20121203.jar和poi-ooxml-3.9-20121203.jar