Converting Excel file to PDF using MS Graph API and SharePoint

Question

I am programmatically converting Excel files to PDF, but uploading them to SharePoint, and then downloading in a PDF format. This has been working fine, but I now have an issue trying to convert a large Excel file. It has about 2007 rows, and when converted using Excel 365 creates a 462 page PDF.

When I try to convert this file programmatically, I get this error: XLSPageLimitExceeded

I presume this means I'm exceeding some limit to the number of pages. But I am unable to find this limit documented anywhere.

Could you please point me to where this limit (and any others are documented), or let me know what this limit is, and others, such as file size.

Thank you,

Allen

Answer 1

I think you can check the info about Excel/SharePoint here:
https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
https://support.microsoft.com/en-us/office/file-size-limits-for-workbooks-in-sharepoint-9e5bc6f8-018f-415a-b890-5452687b325e

Answer 2

Hi @Deva-MSFT ,
We have the same problem, many excel files give that error when converting to PDF. (XLSPageLimitExceeded)
The specifications and limits mentioned before, are only for the normal use of excel in sharepoint, and excel online, but are not related with the conversion to PDF with MS Graph.
There is any guide or specifications with the limits for this type of conversion to PDF?, if we will have that problem is important to know when and why it will happen.
Thanks

Answer 3

The page limit is 250 pages. Beyond this count of pages, you will see XLSPageLimitExceeded error.