Skip to Content (Press Enter)
UserImage.jpg
Anish P
14Views
2Comments
[Advance excel]  Help with removing or deleting all rows below an index
Question
Aggregate

Hi Team, 
I am reading an excel which can have many records but standard format, so i want to split the data to get 2 excels with structures, i am able to remove the starting rows which are only 3 rows and get an excel, but i want to read only first 3 rows. and store it in another excel.

any Logic will be helpful 

Thanks and regards

Anish P 

0
0
01 Dec 2025
Copy Link
2023-05-08 05-34-05
Piyali Saha

Hi Anish P,

Regarding deleting all the row after an index you can use Row_Delete action in advanced excel to give the index of start row and specify the number of rows you want to delete.

If you need any help regarding how this Row_Delete function works you can go through my demo component Advanced Excel Demo and know how to use this action.

Please let me know if you need further assistance.

Thnak you,

Piyali Saha

1
0
01 Dec 2025
Copy Link
2025-12-18 01-28-51
Peter Hieu

Hi @Anish P 

You can see the OML below. By the way, this question is a duplicate, so please delete one of them. 

Hope this helps

Peter Hieu.

Sample.oml
Department.xlsx
1
0
01 Dec 2025
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.