how can we Automate script to pull the next data from xls?

[dasaradh]

Hi,

i have dash board which is build on march month data from excel.

i would like to do automate to pull the data  from excel of April. how can we do that.

is there any automated script for this, if yes how can we achieve it?

thanks,

Dasaradh

[Gysbert_Wassenaar · Accepted solution]

Reload the document if the data for april is added to the same excel file as the data from march.

Change the script to load all the excel files if the data for each month is stored in separate excel files.

See for example this discussion: loop through to load all files from a folder and its subfolders?