Delete first couple rows from Excel without reading the file into datatable

Help
1

Hi,

I have this excel file and I want to know the best way to strip off the first couple rows. I want the file to start off at row 4. I am thinking reading the file to datatable just for deleting the first couple rows is not ideal? The file is huge.

Thanks!
Lav

1 Like
2

@lavint

You can use Insert/Delete rows activity to delete rows from Excel file.

3

hi
Hope this can help you @lavint

we have an option called Delete Rows in package UiPath.Excel.Activities in manage package option from design tab where we have like this where you can mention the no of rows you want to delete and staring position and the sheet name without opening the file and get from datatable

image
image991×403 11.2 KB

Try this and let know, it worked for us

Cheers @lavint

2 Likes
4

Did that work @lavint

5

Thank you!!

I was hoping to delete from the back end. This works but it requires to open the file - in my case is really large file. Is there another way to delete first couple rows from the back end without opening the excel file - just curious? You said it doesn’t open the file but I saw it opened and I thought Excel Application Scope is front end and always open the file. Is it true? Thanks

1 Like
6

fine @lavint
In excel application scope there is an property called visible, uncheck that property
Excel wont open in foreground and will run in background…
Kindly Try this and let know whether this works or not
Cheers @lavint

1 Like
7

did that work @lavint

8

Really? You hide it (or make it invisible) means it’s running at the background? ok… Thank you!

1 Like
9

Run in background… @lavint

10

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