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
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