Viewing Excel Error with the Message "Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.benryan.conversion.ConversionException: Cannot convert spreadsheet"
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.
Adding an excel document in a page resulted with the following error:
Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.benryan.conversion.ConversionException: Cannot convert spreadsheet, the number of cells: xxx is greater than the maximum allowed cells: 100000
[xhtml.view.macro.ViewMacroMarshaller] marshal Exception executing macro: viewxls, with message: com.benryan.conversion.ConversionException: Cannot convert filename.xlsx, this file exceeds the maximum file size for xlsx files of 2MB.
This is a known issue, a limitation within the Office Connector. This issue is being tracked here:
Besides, there is a hard limit of 100000 cells where the macro is not able to render more than this limit. A feature request has been opened to track this:
Add parameter in CATALINA_OPTS
Add the following parameter to your Confluence CATALINA_OPTS within either the setenv.sh (Linux) or setenv.bat (Windows) file:
Check Configuring System Properties for more information on adding the parameter above
This will allow you to add spreadsheets up to 128 MB in size, but be aware that larger spreadsheets can take a while to convert
Read through Office Connector Limitations and Known Issuesas a part of the consideration for the workaround.
Upgrade to Confluence 5.7 and above