Select particular cell in CSV file

Help
, ,
1

How can I select a particular cell in CSV file ?

Capture8
Capture8740×495 12.9 KB

2

Hi
Do you want to get the particular cell value
If so we read the cvs file first with READ CSV FILE sand get the output with a variable of type datatable
And the get the exact cell value like this
datatable.Rows(rowindex)(columnindex).ToString
Where both row and column index starts from 0 for the first row and first column

Cheers @Pranav_Singh1

1 Like
3

Capture9
Capture91318×725 35 KB

What will be the next step ? @Palaniyappan

1 Like
4

Fine
The steps involved will be like
—in READ CSV FILE activity pass the file path csv file as I lit and get the output with a variable of type datatable named dt
—now use a simple assign activity like this
Str_output = dt.Rows(rowindex)(columnindex).ToString
Where both row and column index starts from 0 for the first row and first column

Cheers @Pranav_Singh1

1 Like
6

@Palaniyappan Can you please attach a sample XAML for this refrence.

1 Like