Aspose.Cells - Save Each Worksheet to Different PDF

//Get the Excel file path
String filePath = dataPath + "workbook.xlsx";

//Instantiate a new workbook and open the Excel
//File from its location
Workbook workbook = new Workbook(filePath);

//Get the count of the worksheets in the workbook
int sheetCount = workbook.getWorksheets().getCount();

//Make all sheets invisible except first worksheet
for (int i = 1; i < workbook.getWorksheets().getCount(); i++)
{
     workbook.getWorksheets().get(i).setVisible(false);
}

//Take Pdfs of each sheet
for (int j = 0; j < workbook.getWorksheets().getCount(); j++)
{
    Worksheet ws = workbook.getWorksheets().get(j);
    workbook.save(dataPath + ws.getName() + ".pdf");

    if (j < workbook.getWorksheets().getCount() - 1)
    {
       workbook.getWorksheets().get(j + 1).setVisible(true);
       workbook.getWorksheets().get(j).setVisible(false);
    }
}


Download Source Code

For More Examples, visit Aspose Docs

Last edited Nov 11, 2014 at 3:11 PM by shoaibkhan, version 1