How to select specific columns and last row only?

Help Activities
, ,
1

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)

image

Please guide me about it.

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.

3

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

4

Read row activity

If you give A50 it will store all the column values of 50th row starting from 1st column

6

Give startingCell as “A”+ind.tostring

And in result give dtRow

dtRow variable type is System.Data.Datarow

7

@prasath_S It show error.

image
image727×367 12.8 KB

8

Okay sorry I forgot that,

dtRow datatype is system.collections.generic.ienumerable(of object)

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.