To import data from multiple worksheets and/or Excel files in Easy Excel Analysis, first set up the import settings for a single worksheet as described here.
NOTE: The layout and format of the data in all the additional files and worksheets must be identical to that of the source worksheet.
When you reach this page of the import wizard, you can then set up the additional import sources.
To add a file, click on the Add button below the file list window. For each additional file that you want to import, select the option that best fits your needs.
If you want to import data from all the worksheets in a single file, first set up the import settings for any one of the worksheets in that file. Then on this page, add that file again and select the Import from all worksheets option. Easy Excel Analysis will not import from the same worksheet twice.
If you need to be able to identify each data source and your worksheets do not contain any columns that identifies the source data, you can add additional columns on this page to help identify the data source. Click on the Add button below the additional columns list.
On this page, enter the column name, type, length, and source of the column. There are several options available to use the filename or worksheet details.
Using an example file name of G:\data\Sales_Osaka_July2020.xlsx,
- filename = Sales_Osaka_July2020
- filename 1st value = Sales
- filename 2nd value = Osaka
- filename 3rd value = July2020
The same extraction rules apply to worksheet names. Note that the separators can be a dash symbol (e.g. Sales-Osaka-July2020.xlsx), a comma (e.g. Sales,Osaka,July2020.xlsx), or a dot (e.g. Sales.Osaka.July2020.xlsx). You cannot mix separator symbols e.g. Sales-Osaka.July2020.xlsx.
For further details, please refer to this topic in the help file.