How to Get data from excel

Hi,

I need help. How to Get data from excel In Columns “G”

My Process Save file Excel on the path already and next step How to Read or Extract Columns “G”

My Data

1 Like

will excel only have 1 row or more rows?

1 Like

Sorry More Rows

do this
if theres only 1 row you can get data (CA) like this
dt.Rows(0)("CA").toString

if theres more than 1 row do this to get all CA data to list
listOfCA = dt.asenumerable.select(function(row) row("CA").tostring).toList

1 Like

Thank you Very much.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.