创建新表在现有的Excel工作簿使用Apache POI对Java [英] Creating New Sheet In Existing Excel Workbook Using Apache POI for Java

问题描述

我试图创建使用面向Java的Apache POI现有的Excel工作簿中一个新的表，但没有成功为止。谁能告诉我它是怎么做的？

I'm trying to create a new sheet in an existing excel workbook using apache POI for java but have been unsuccessful so far. Can anyone please tell me how it is done?

推荐答案

这很容易。它就像添加一个新表到新工作簿，才开始与现有的工作簿，而不是一个新的

It's very easy. It's just like adding a new sheet to a new workbook, only you start with the existing workbook rather than a new one

 Workbook wb = WorkbookFactory.create(new File("/path/to/existing"));
 Sheet s = wb.createSheet();

 // Do something with the new sheet

 FileOutputStream out = new FileOutputStream("/path/to/new/version");
 wb.write(out);
 out.close();

这篇关于创建新表在现有的Excel工作簿使用Apache POI对Java的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！