Excel Generation using POI

[Ginnakunta Laxmi Narayan]

Can i generate multiple sheets in the same excel file using POI.

Please help me.

Bye
Narayan

[Amber Vaidya]

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();