Importing multiple Excel Files with multiple tabs into spotfire

[Jorge Escobar]

I have multiple Excel files ~20 with multiple tabs ~15 each. These tabs and excel files have same format and structure arising from history of store specific performance over several years.

I need to combine all information from these files and tabs for analysis in spotfire, but do not have time to import individual tabs for each file.

What is the best way to perform the import of the information into spotfire

Many thanks

[Fabian Duerr]

If you are familiar with R data functions please check these links:

 

https://stackoverflow.com/questions/12945687/read-all-worksheets-in-an-excel-workbook-into-an-r-list-with-data-frames

 

https://blog.exploratory.io/how-to-read-multiple-excel-or-csv-files-together-42af5d314a10