How to save download reports & read it?

Help Activities
1

Hi all,

I am currently working on web automation, specifically tasked with downloading a multi-page report. For each page, I need to save it with the current date and an incremental name. Afterward, I have to read each Excel sheet one by one. Does anyone have suggestions on how to approach this?

Thanks in advance

2

@chandu_royal

Assign activity: Directory.GetFiles("YourReportFolderPath", "*.xlsx").OrderBy(Function(f) New FileInfo(f).CreationTime).ToList().ForEach(Sub(file, index) ExcelApplicationScope(FilePath:=file, ReadRange:="Sheet1", OutputDataTable:=dataTable).WriteRange($"OutputPath\{DateTime.Now.ToString("yyyyMMdd")}_Page{index + 1}.xlsx"))

cheers!!!