Apache POI SS - Re-Order Sheets Within Workbook

Workbook wb = new HSSFWorkbook();
wb.createSheet("new sheet");
wb.createSheet("second sheet");
wb.createSheet("third sheet");

wb.setSheetOrder("second sheet", 0);
wb.setSheetOrder("new sheet", 1);
wb.setSheetOrder("third sheet", 2);

FileOutputStream fileOut = new FileOutputStream("data/Apache_Reordered.xls");
wb.write(fileOut);
fileOut.close();

Aspose.Cells

//Create a new Workbook.
Workbook workbook = new Workbook();

WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet1 = worksheets.get(0);
Worksheet worksheet2 = worksheets.add("Sheet2");
Worksheet worksheet3 = worksheets.add("Sheet3");

//Move Sheets with in Workbook.
worksheet2.moveTo(0);
worksheet1.moveTo(1);
worksheet3.moveTo(2);

//Save the excel file.
workbook.save("data/AsposeMoveSheet.xls");

Download Source Code

For More Examples, Please Visit Aspose Docs

Last edited May 14, 2014 at 10:33 AM by shoaibkhan, version 3