将数据附加到Excel文件中
我正在尝试编写一个程序，将数据附加到Java中的Excel文件中。我达到了以下代码。但它会重写Excel文件中的内容，而不是附加到它。请帮我完成这个。
public class jExcel
{
static WritableWorkbook workbook;
public static void main(String args[])throws Exception
{
workbook = Workbook.createWorkbook((new File("D:\0077\my2.xls")));
WritableSheet sheet = workbook.createSheet("First Sheett",1);
Label label = new Label(5,2,"ssssssssss");
sheet.addCell(label);
workbook.write();
workbook.close();
}
}
没有找到相关结果
已邀请:
3 个回复
拟蓬
WritableWorkbook workbook = Workbook.createWorkbook(new File("D:\output.xls")); WritableSheet sheet = workbook.createSheet("First Sheet", 0); Label label = new Label(0, 2, "A label record"); sheet.addCell(label); workbook.write(); workbook.close(); //MODIFY XLS Workbook workbook1 = Workbook.getWorkbook(new File("D:\output.xls")); WritableWorkbook copy = Workbook.createWorkbook(new File("D:\output.xls"), workbook1); WritableSheet sheet2 = copy.getSheet(0); //WritableCell cell = sheet2.getWritableCell(5, 2); copy.write(); copy.close();诉嘎归亮
使用“”来获得现有的Excel。 然后使用检索合适的纸张。 对于您在上面检索的工作表，使用“”将单元格附加到工作表。Workbook workbook = Workbook.getWorkbook(new File(""D:\0077\my2.xls"")); WritableWorkbook copy = Workbook.createWorkbook(new File("output.xls"), workbook); WritableSheet sheet2 = copy.getSheet(1); Label label = new Label(5,2,"ssssssssss"); sheet2.addCell(label);死簇
后，请执行以下操作：WritableWorkbook copy = Workbook.createWorkbook( new File(""D:\0077\my2_copy.xls""), workbook );