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

[CoolRobot]

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

[Eric_Wong_Test (Eric Wong)]

Splite.xaml (11.8 KB)
Something Like That

[copy_writes (chethan)]

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

[CoolRobot]

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

[Eric_Wong_Test (Eric Wong)]

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

[CoolRobot]

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 ?

[Eric_Wong_Test (Eric Wong)]

Splite.xaml (14.8 KB)

[CoolRobot]

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

[Eric_Wong_Test (Eric Wong)]

index + 2

[CoolRobot]

@Eric_Wong_Test

index + 2

Thank you is working

[CoolRobot]

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

[Eric_Wong_Test (Eric Wong)]

No, but have a activity can do this