Extract excel data from columns

[Anelisa_Bolosha1 (Anelisa Bolosha)]

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:

[ashokkarale]

@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

[Anelisa_Bolosha1 (Anelisa Bolosha)]

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

[Anelisa_Bolosha1 (Anelisa Bolosha)]

Like so?

[ashokkarale]

@Anelisa_Bolosha1,

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

[Steven_McKeering]

Hello

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

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers

Steve