We are converting an Excel file to PDF by uploading to SharePoint using the Graph API, then downloading using format=pdf. This has been working fine for most files, but fails for a spreadsheet with 2007 rows (317kb in size). When converted manually in Excel 365 the file produces a PDF of 462 pages. Clearly we can alter the settings we pass to reduce the number of pages, but it would be helpful to understand what the service API limits are (given it does actually work in Excel 365).
The API request we're using is:
theInputStream = theGraphClient.sites(aSiteId).drives(myDrive.id) .items(theUploadedItem.id).content().buildRequest(requestOptions).get();
The error log contains the error XLSPageLimitExceeded. Can anyone explain what the value of the limit is? Also, Is there a limitation for the generation for:
File size
Number of rows
Number of columns
Number of cells
Number of sheets
Or anything else? Thanks so much!