I am trying to read a set of rows in excel, to be able to extract the data of each column to a variable, I am somewhat lost, how can I do it? I have seen read range, but it only reads me a single column, and I need all the columns of all the rows thanks

HI @Kuro Use Read Range activity → Store it as DtRead Use For each row in DataTable activity [image] Regards Gokul

How to read the entire row within a range in excel

Kuro (KuroObi ) October 4, 2022, 2:23pm 7

Thanks, at that point I was, but my excel has 6 columns per row, how can I put that data in a variable row by row?

Topic		Replies	Views
Read Row and Read Column Help	2	7907	October 3, 2017
Need help using Excel Read Range activity to exclude the first 2 rows Help	2	4939	April 27, 2020
Column Read Range Activities excel , activities , question	4	61	December 24, 2024
Restrict excel file read by column Help datatable , excel , activities	8	2201	July 5, 2017
Read range should pick desirable column range Studio uiautomation , activities	28	5687	October 21, 2020