Geek asks and answers

Create a new worksheet in an existing Excel workbook using Apache POI for Java

I am trying to create a new sheet in an existing excel book using apache POI for java, but have not been successful so far. Can someone please tell me how this is done?

+5
source share
4 answers

It is very easy. This is just adding a new sheet to a new book, only you start with an existing book, not 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();
+7
source 
HSSFSheet sheet1= workBook.createSheet("sheet1");
HSSFSheet sheet2= workBook.createSheet("sheet2");
HSSFSheet sheet3= workBook.createSheet("sheet3");
+2
source 
//we can create any number of sheets for single workbook
HSSFSheet sheet1= workBook.createSheet("sheet1");
HSSFSheet sheet2= workBook.createSheet("sheet2");
HSSFSheet sheet3= workBook.createSheet("sheet3");
+1

,   excel

0

More articles:


All Articles