I want to read a range from “workbook123.xls” where the “123” changes from report to report. I have tried so many things and looked around, where I am now is assign activity to the following Directory.GetFiles(“C:Reports\output”,"workbook") to a system string variable* I am getting a string conve…

Read “dynamic range” from excel file with a “dynamic name” for the first sheet

Yoichi (Yoichi) September 27, 2024, 3:01pm 9

Hi,

How about using ForEachExcelSheet and Break activity as the following?

Regards,

Topic		Replies	Views
Read range_dynamic sheet name Help	17	5455	August 15, 2019
Dynamic workbook name in Read Range activity, For each workflow Help studio	11	1994	August 12, 2019
MS Excel automation Help excel , activities , question	14	1057	January 10, 2020
Excel automation with dynamic range Studio studio , question , workflow_diff	13	1043	November 6, 2023
UiPath.Excel.Activities.ExcelReadRange (Read Range) Studio studio , question , activities_panel	1	119	November 28, 2024