Load multiple excel web embaded files

[alec1982]

hi all,

anyone knows how can i load multiple excel files from web directory.. I tried to use wild card.. but gave me errors..

the error is "Cannot Read BIFF file" which means one of the xls files is not actual xls file.. I have no control of the directory beside read only so any suggestion would help.

Example of one of the files

'http://www.ABC.com/~/media/Files/2015/Test%20data%20August%202015.xls'

and there is a file for each month up until the previous month..

Any idea?

Thxs.

[alec1982]

I appreciate it.. i was thinking to automate it permanently but that would work.. i will do it up to 2020..

Lats question I have

I want to show the month and year of each file within the table. I tried

$(vYear) as ReportYear,

$(webfile) as ReportMonth,

But that caused an error and returned no columns

[alec1982]

$(vYear) as ReportYear,  work fine and the year column is created..

$(webfile) as ReportMonth, no data on the dashboard will show up and no columns are showing up if this is added..