Extract data from excel column

Help Activities
,
1

Hello

I have an Excel table with 8 columns.

image
image864×158 71.7 KB

I want to use a loop to extract the values of the column E with a stop condition the rows are empty : name_table.Rows.Count.ToString <> " " and store them in a datatable variable.

Can someone help me please?

2

Hello @Ahmed_BEN_JEMIA1 ,

I hope your requirement is to get the data in column E till an empy cell? If my understanding is correct then you can do as below.

1)Use Excel activity
2)Use Find First\Last row activity. It will stop at empty space and get the index of last row
3)Read range (E1: E(lastRow))

3

Hi,

You can use read range activity, for each row to loop over new assigned datatable.
If condition like Not CurrentRow(4).ToString.equals(“”) —> means skipping row where contract is blank:
Do what you want with CurrentRow(4).ToString

4

Hello @akash.singh @Rahul_Unnikrishnan

here is what i did, and output read cell variable of txt to store the values.

The problem I have only the 1st contract :confused:

image
image585×677 42.2 KB

5

@Ahmed_BEN_JEMIA1
Still not clear with your requirement

“I want to use a loop to extract the values of the column E with a stop condition the rows are empty : name_table.Rows.Count.ToString <> " " and store them in a datatable variable.”

If you just want to get the data above to first empty value you can try as attached. The you can loop through the data and action on it as per your requirement.
ExcelDemoSearch.xaml (66.0 KB)