Read Multiple Excel files with same format in the same folder

[g s]

I am fairly new to Spotfire and I was wondering whether it is possible to link to a folder where a number of Excel files with exact same format are stored (similar as inPower BI)

The intention is that these data will be read into the same table by Spotfire. And additionally it would be great if upon a refresh Spotfire would automatically extract data from all existing files (including new) and substitute the content of the table in an cumulative manner

 

Thank you

[Fabian Duerr]

You could write a data function for that. This function can be triggered automatically when you open your dxp file.

This function should take your folder path as input. Then it should collect all xlsx files within this folder in a list. Maybe you have a naming pattern as well.The next step is to loop thru this list to read in all your files as single tables / data frames. And finally you bind all tables together. You might want to add other features that check for data consistency/format to avoid any errors.

If you are not familiar with R or Python try to find someone within your organization to helpyou with that. Or, if you just get stuck at a few single steps shot your questions here.

[David Boot-Olazabal]

Hi ginies,

I addition to what fabd has said, here is a starter TERR script you can use for this:

#Name your path

mypath