File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes Excel Generation using POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Excel Generation using POI " Watch "Excel Generation using POI " New topic

Excel Generation using POI

Ginnakunta Laxmi Narayan
Ranch Hand

Joined: Jun 16, 2004
Posts: 35
Can i generate multiple sheets in the same excel file using POI.

Please help me.

Amber Vaidya
Ranch Hand

Joined: Oct 14, 2003
Posts: 42
Sure you can ...

Create a workbook and then create sheets in the workbook

// create a new workbook
HSSFWorkbook wb = new HSSFWorkbook();

// create new sheets
HSSFSheet sheet1 = wb.createSheet();
HSSFSheet sheet2 = wb.createSheet();
HSSFSheet sheet3 = wb.createSheet();
I agree. Here's the link:
subject: Excel Generation using POI
It's not a secret anymore!