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

Extract excel data from columns

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
Select single column of an Excel file as save to DataTable variable Help datatable , excel , activities	5	1683	February 15, 2020
Excel open Help	2	3553	July 25, 2017
Seperate excel columns INTO one datatable Help datatable , excel , activities , question	8	951	December 1, 2019
Extract specific column from an excel Help datatable , excel , activities , studio	3	4214	October 29, 2018
Spreadsheet Row to Datatables Studio datatable , excel	0	724	May 27, 2020