Select single column of an Excel file as save to DataTable variable

[kwoxer (Curtis Mosters)]

Given the excel file with the data:
col1,col2,col3
1 , 2 , 3
4 , 5 , 6

I just want to extract col2 into a datatable. The following activity instead extracts col2 and col3. How to just extract the col2?

[lakshman (Ganta lakshman)]

@kwoxer

Use Read Column activity to read entire column.

Read Column

[kwoxer (Curtis Mosters)]

But that gets me back an IEnumable.

So how to convert it to an datatable?

I need that type because I want to use the Write Range.

[lakshman (Ganta lakshman)]

@kwoxer

Ok got. Try below expression then.

1. First use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘inputDT’.

2. And then try below expression.

    newColumnDT = inputDT.DefaultView.ToTable(False,"ColumnName")
   

[kwoxer (Curtis Mosters)]

@lakshman

newColumnDT = inputDT.DefaultView.ToTable(False,“ColumnName”)

Works like a charm. Thanks.