We want to gernerate one html file for one sheet of excel files!
How to do?
Hi,
Please use the following code snippet to convert each worksheet in the spreadsheet to separate HTML file.
Java
HtmlSaveOptions options = new HtmlSaveOptions();
options.setExportActiveWorksheetOnly(true);
Workbook workbook = new Workbook(dir + “sample.xlsx”);
int sheetCount = workbook.getWorksheets().getCount();
for (int j = 0; j < sheetCount; j++)
{
workbook.getWorksheets().setActiveSheetIndex(j);
workbook.save(dir + workbook.getWorksheets().get(j).getName() + “.html”, options);
}
options.setExportActiveWorksheetOnly(true);
Workbook workbook = new Workbook(dir + “sample.xlsx”);
int sheetCount = workbook.getWorksheets().getCount();
for (int j = 0; j < sheetCount; j++)
{
workbook.getWorksheets().setActiveSheetIndex(j);
workbook.save(dir + workbook.getWorksheets().get(j).getName() + “.html”, options);
}