i am using the following code.
Workbook workbook = new Workbook(excelFileName);
//execute workbook formulas before pdf generation
workbook.calculateFormula(true);
// Get the count of the worksheets in the workbook
int sheetCount = workbook.getWorksheets().getCount();
//loop through all wroksheets
for (int i = 1; i < sheetCount; i++) {
Worksheet ws = workbook.getWorksheets().get(i);
for(int k =0;k<ws.getPivotTables().getCount();k++){
System.out.println("in start..1111.. 2222222222222222222222222");
//ws.getPivotTables().get(k).setRefreshDataOnOpeningFile(true);
ws.getPivotTables().get(k).setRefreshDataFlag(true);
ws.getPivotTables().get(k).refreshData();
ws.getPivotTables().get(k).calculateData();
ws.getPivotTables().get(k).setRefreshDataFlag(false);
}
}
//save the workbook as pdf report. Save pdf with same name
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.setOnePagePerSheet(true);
workbook.save(getPdfFileName(excelFileName), pdfSaveOptions);