Auto Add Excel Files to Data Table when a file gets dropped in SharePoint

[Shamil Salam]

Hi,

So I have a scenario, whera a team is going to randomly drop excel files into a SPO location. what I need is to be able pull these different files into a spotfire report. Is there a way where I can add as rows to a table when a file gets uploaded or even on a schedule to loop through all files and append

The other approach I have is to use macros to combine the data separately. Even going with this scenario, is there a way to auto call a macro from within Spofire

 

Thanks

Shamil