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

Anelisa_Bolosha1 (Anelisa Bolosha) September 24, 2024, 5:45pm 3

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

Topic		Replies	Views
Datatable extract to assign variable to get all columns Activities excel , uiautomation , activities	14	756	December 10, 2023
Select single column of an Excel file as save to DataTable variable Help datatable , excel , activities	5	1660	February 15, 2020
How to Extract data from System.Data.DataRow type variable Help datatable , activities , question	8	13081	October 25, 2023
All about Datatable - UiPath Tutorials datatable , data_manipulation	28	23387	January 30, 2023
Extraction of data Help	5	1052	December 10, 2018