Good day all, I have this flow where my bot downloads attachments from an email into a local folder then opens it. I want to extract data from the excel columns please help, so far I have used this: [image] [image]

@Anelisa_Bolosha1 , currentRow.Item(“Column Name”).Tostring this will return you string. So datatype of the variable should be string

@Anelisa_Bolosha1 , Read range activity will give you output as DataTable. And then use For Each Row in datatable activity to iterate that data one by one row. While iterating through rows you can get each rows column by this code. currentRow.Item("Column Name").Tostring Thanks, Ashok …

Hi @ashokkarale thanks for your feedback, so the variable I will create for : currentRow.Item(“Column Name”).Tostring ,what is it’s type?

Hello Take a look at this post for general datatable questions and answers. [image] All about Datatable - UiPath Tutorials Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queri…

Extract excel data from columns

Help Activities

Steven_McKeering (Steven McKeering) September 24, 2024, 11:13pm 6

Hello

Take a look at this post for general datatable questions and answers.

Cheers

Steve

Topic		Replies	Views
Datatable extract to assign variable to get all columns Activities excel , uiautomation , activities	14	814	December 10, 2023
Select single column of an Excel file as save to DataTable variable Help datatable , excel , activities	5	1702	February 15, 2020
Seperate excel columns INTO one datatable Help datatable , excel , activities , question	8	973	December 1, 2019
Spreadsheet Row to Datatables Studio datatable , excel	0	726	May 27, 2020
Need Solution - challenge with Extract Datatable Activities database , activities , question	4	719	April 10, 2023

Extract excel data from columns

Related topics