Why only 3 Excel sheets are converted to PDF using groupdocs converter

Hello Team,
When I pass a xlsx file having 10 pages, I see only first 3 pages are converted to pdf.

We do have license but we don’t have active subscription, which is not yet approved. Is that the reason of such behavior? Or is there anything wrong with below code.


SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
loadOptions.setSkipEmptyRowsAndColumns(true);
loadOptions.setOnePagePerSheet(true);
Converter converter = new Converter(excelfile.getAbsolutePath(),() -> loadOptions);
converter.convert(output, options);
converter.close();

1 Like

@Ash_pot

Can you kindly provide the resulting/converted PDF file? Are you also experiencing the presence of an evaluation watermark on the top of the pages in the output PDF?

Here is the exceltoPDF converted file. I do not see evaluation watermark anywhere.

convertExcelToPDF.pdf (117.8 KB)

@Ash_pot

Could you please also share the source/problematic Excel file? Also specify the API version that you are using.

It seems I can’t upload xlsx file as an attachment here. Getting error,“Sorry, the file you are trying to upload is not authorized (authorized extensions: jpg, jpeg, png, gif, zip, pdf, docx, 7z).”

The excel sheet which I am trying has 13 worksheets within it.

Groupdocs conversion version 22.8 is being used.

We can’t use groupdocs conversion version 23.5 or 23.2 or 22.12.1 or 22.11 versions because of the issue reported in another issue:
https://forum.groupdocs.com/t/groupdocsexception-license-parsing-error-due-to-xercesimpl-jar-file/12832

xlsx file attached as 7z:

sampleexcel.zip (89.7 KB)

@Ash_pot
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CONVERSIONJAVA-2010

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.