Free Support Forum - groupdocs.com

Multisheet excel file to pdf conversion in Java


#1

I want to convert excel to pdf, but excel sheet contains multiple workSheets so how can i convert each sheet in pdf

i found using Aspose.cells
Workbook workbook = new Workbook(dataDir + “Mybook.xls”);
// Implement one page per worksheet option
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.setOnePagePerSheet(true);

but how to do it in groupdocs.convert


#2

@swapnilkumbhar,

We are investigating this. Your investigation ticket ID is CONVERSIONJAVA-734. As we have any further update, we’ll notify you.


#3

@swapnilkumbhar,

GroupDocs.Conversion for Java also offers setOnePagePerSheet property in CellsLoadOptions. You can use both CellsLoadOptions and PdfSaveOptions as parameters in convert method.

CellsLoadOptions loadOptions = new CellsLoadOptions(); 
loadOptions.setOnePagePerSheet(true);
PdfSaveOptions saveOption = new PdfSaveOptions(); 
ConvertedDocument convertedDocumentPath = conversionHandler.<String> convert(guid, loadOptions,saveOption);