Hi, I have 5 excels in a folder (1.eg Team Manager Ram.xlsx) I have 5 names in a queue(ram, some other data…) if queue conatain ram then bot have to read Team Manager Ram excel, if queue contain som then bot have to read Team Manager som.xlsx file the 5 excels are consistent here how can we ach…

Hi Hope the below steps would help you resolve this Use a assign activity like this arr_filepaths = Directory.GetFiles(“your folderpath”) Where arr_filepaths is a variable of type array of string Now use a assign activity to get the filepath str_filepath = arr_filepath.Where(Function(s) s.Co…

How to read our required excel in a folder

Help Studio

panguluri_saritha (panguluri saritha) September 13, 2023, 11:58am 6

solution for read range, thank you

Topic		Replies	Views
Read an excel file and save it in datatable Studio studio , question , tools	11	4166	March 30, 2022
Multiple excel reading Studio studio , question , activities_panel	12	558	July 4, 2023
MS Excel automation Help excel , activities , question	14	1057	January 10, 2020
How to do If there is an excel in this file, read excel else don't do anything Help excel , activities , question	33	1554	January 24, 2020
Read Specific Data From one Excel and Write another excel file Help studio	10	4465	July 12, 2019

How to read our required excel in a folder

Related topics