Select particular cell in CSV file

How can I select a particular cell in CSV file ?

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

What will be the next step ? @Palaniyappan

1 Like

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

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

1 Like