Hi , I have an excel use case doubt scenario, which I recently faced in the prod environment, that is: Excel has two sheets, In sheet 1 consists of 50 rows of data available, and In sheet 2 consists of 50 rows of the same data available. Now I want to copy the last 5 rows of data from sheet 2 and …

Hi @Harsha_S1 , Can you try this DT1 for Sheet1 DT2 for Sheet2 Get last 5 rows of sheet2 DT3 = DT2.AsEnumerable.Reverse().Take(5).CopyToDataTable Merge DT1 and DT3. I have attached xmal for your reference Thanks! Excel.xaml (6.6 KB) Excel.xlsx (10.5 KB)

Excel Automaion Scenario Based

Help Activities

Harsha_S1 (Harsha S) December 12, 2022, 12:12pm 4

Thank you Umadevi_Sanjeevi for your effort.

Topic		Replies	Views
Automate Data Activities excel , activities , question	1	25	November 21, 2024
Copy Pasting Data From One Sheet To Another Activities excel , activities , studio	8	493	February 8, 2023
How to copy set of records to new sheet Studio studio , question , activities_panel	8	918	September 17, 2022
How to copy specific number of rows from one excel sheet and paste them into another Robot robot , question	5	1355	June 27, 2022
Need assist in excel Activities excel , activities , question	1	673	April 9, 2021

Excel Automaion Scenario Based

Related topics