How to extract the last row value from the datatable from single column with no headers

Help StudioX
,
1

I am having an excel file with single column data with no header and I need to extract the last value from the excel file.

Any suggestions would be helpful.

Thanks.
Nawaz.

1 Like
2

use read range activity without headers

dt.rows(dt.rows.count-1).item(0) this will give you the last value

3

Hi @Mohammed_Nawazuddin

Please use an assign activity:
leftside: LastRow (DataType is DataRow)
right side:

YourDatatableVar.AsEnumeration.Last()

or

YourDatatableVar.Rows(YourDatatableVar.Rows.Count-1)

Thanks.

4

Hi,

I have tried the same but its giving the below error.

image
image1227×577 72.3 KB

Thanks,
Nawaz.

5

And I am passing datarow as string I need a sing value

6

It should be
st.rows(st.rows.count-1).item(0)

i think you missed .rows

7

YourDataTable.AsEnumerable.Last()(0).toString

8

Hi @Mohammed_Nawazuddin did it work?

9

Hi,

It didnt work .

image
image1043×580 52.6 KB

Thanks,
Nawaz.

10

datarow variable should be string type and in value also convert to string

dt.rows(dt.rows.count-1).item(0).ToString

11

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