Data to the last row in excel but not the last row

Data.xlsx (21.5 KB)
hi i want to read from
Start Time : 13/04/2021 07:30
where my data is from A53 onward to A116 row but say this is not fix row
how i can read to the last row as i wan to copy all of this row and paste into another excel files.
i try use data scrapping but i not sure how
really appreciated if someone can help me

Splite.xaml (11.8 KB)
Something Like That

You can use if condition if you read the data or you want to read the last row of the data you can use LINQ code Like Datatable.asenurable.desending or use revers also

hi i just want it to take from here to

to here
as this is the end of the table where i wan to copy all of this
where it selected from A53 to A116 Row (sometime the row may not be A116 it be can be more or less how can i find also )?

Splite.xaml (13.4 KB)
Yup, it can find it. You can try it.

since this is store in database how can i copy this datatable and paste it into a new excel file ? without the header
so just from TMP005 onward ?

Screenshot 2021-04-23 142400
Splite.xaml (14.8 KB)

hi there a way where i can remove those PM name and dont write PM0005 as this value can be change?
as PM name suppose to be header

index + 2

Thank you is working

btw i realize can u also perserve the grey background alone when copy and paste into it?
the data

No, but have a activity can do this
Screenshot 2021-04-23 164919

1 Like

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