My robot has to read a different excel file everyday and perform some steps with the data extracted, the sheet name is different everytime the file changes. I was trying to use read range activity and save it on a datatable variable. My questions are: How can i read a different sheet name everytim…

You can have the excel file in a particular folder and using Assign string, filelist=directory.GetFiles("location","*.xlsx") you can get the path of the excel, Make sure that there is only the required excel files in your speciifed location [image] How to read all the excel file f…

Read an excel file and save it in datatable

Help Studio

Sam_Abraham (Sam Thomas Abraham) March 30, 2022, 1:31pm 8

You can find the solution for the same in the below post

Topic		Replies	Views
MS Excel automation Help excel , activities , question	14	1056	January 10, 2020
Reading a list of Excels Help datatable , excel , activities	1	2626	May 4, 2017
Excel automation with dynamic range Studio studio , question , workflow_diff	13	1004	November 6, 2023
Get File names and read excel as DT and the excel sheet will vary? Help datatable , excel , activities , question , file_system	3	856	January 14, 2020
Reading Excel Files Help	7	1161	May 22, 2019

Most Active Users - Yesterday
V_Roboto_V
ashokkarale
aikaterini.karakasidi
sonaliaggarwal47
Nguyen_Van_Luong1
Anil_G
nisargkadam23
mohamed.saty2012
adilhassanpost
More details...

Read an excel file and save it in datatable

Related topics