I read the datatable from table (DT)
I want write output in newDT = Column F until Column AE in last row in file excel.
I can find last row and create variable last row= ind
Now I use read cell for read separate column as below. , But I want solution that less steps (Now use read cell 25 round for read column until column AE)
Please guide me about it.
prasath_S
(prasath S)
April 19, 2021, 3:24am
2
Hi @fairymemay
You can use read row activity,it will store all column values of a particular row.(output is datarow - dtRow variable)
After that use dtRow(1).tostring will give 2nd column value of that row.
@prasath_S Please explain me as below.
it will store all column values of a particular row.(output is datarow - dtRow variable)
What use activity?
prasath_S
(prasath S)
April 19, 2021, 3:30am
4
Read row activity
If you give A50 it will store all the column values of 50th row starting from 1st column
prasath_S
(prasath S)
April 19, 2021, 3:55am
6
Give startingCell as “A”+ind.tostring
And in result give dtRow
dtRow variable type is System.Data.Datarow
@prasath_S It show error.
prasath_S
(prasath S)
April 19, 2021, 4:02am
8
Okay sorry I forgot that,
dtRow datatype is system.collections.generic.ienumerable(of object)
system
(system)
Closed
April 22, 2021, 4:03am
9
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.