Excel Dataset (Multiple Sheets)

Version

Application Scenario

This plugin can help you add one or more sheet sheets from an Excel dataset to FineReport, and add CSV files to FineReport.

Function Description

You can add and merge (vertically) multiple sheets from an Excel dataset.

Plugin Installation

To add a multi-sheet Excel dataset, you need to download the Multi-Sheet Excel Dataset plugin.

For details about how to install the plugin in the designer, see Designer Plugin Management.

For details about how to install the plugin on the server, see Server Plugin Management.

After installing the plugin, you can add multiple sheets at one time.

Placing the Excel File in the Required Path

You need to copy the Excel file and paste it to %FR_HOME%\webapps\webroot\WEB-INF\reportlets. In this example, place the Signing Table to this path, as shown in the following figure.

You can download Signing Table.xlsx as the example data.

Adding an Excel Dataset

1. Add a file dataset in the designer, as shown in the following figure.

2. Set File Type to Excel and add the file Signing Table, as shown in the following figure. Select Signing Table and select the sheets to be added. You can click and rename each sheet, as shown in the following figure.

3. (Optional) Click Preview to view data on different sheets, as shown in the following figure.

4. Click OK. Then the selected sheets will be added to FineReport, as shown in the following figure.

Merging Multiple Sheets

When multiple sheets have the same data structure and field titles, you can merge them vertically, as shown in the following figure.

So how to merge them? You just need to select Merge on the Excel dataset adding page.