Overview
Version
Report Server Version | JAR Package Version | Plugin version |
11.0 & 10.0 & 9.0 & 8.0 | 2016-07-01 | V2.1.4 |
Function Description
Due to the uncertain version of Office installed on the client, if the server can only export Excel 2007 files, some clients will not be able to open the file. After installing the Excel Export Method Selection plugin, you can export Excel 2003 or Excel 2007 files when exporting Excel files on a PC.
This function is provided to customers as a plugin. You can export .xls or .xlsx files when exporting Excel.

Example
Plugin Installation
You can obtain the plugin at Excel Export Method Selection.
For details about installing the plugin in the designer, see Designer Plugin Management.
For details about installing the plugin on the server, see Server Plugin Management.
Importing poi2007_fat.jar
To export Excel 2007 files, just like importing those, import a JAR file poi2007_fat.jar. Copy and paste poi2007_fat.jar to %FR_HOME%\webapps\webroot\WEB-INF\lib.

Exporting Excel on the Web Page
If a separate Excel export button is added to the web toolbar in the designer, the corresponding toolbar on the web page will also display the button. For example, if you add the Excel (Pagination Export) and Excel03 (Pagination Export by Sheet) buttons separately, there will be two corresponding buttons in the toolbar on the web page.