Viewing Excel Error with the Message "Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.benryan.conversion.ConversionException: Cannot convert spreadsheet"
プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。
問題
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:
- CONF-25709 - 課題詳細を取得中... ステータス
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:
- CONFSERVER-58096 - 課題詳細を取得中... ステータス
回避策
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:
-Dofficeconnector.spreadsheet.xlsxmaxsize=134217728Check 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