Unable to Delete Empty Rows in Excel

sreekanth.lavu@sparshcom.net posted this 10 April 2019

HI Team,

In the Excel first 2 rows are Empty.

I am trying to delete the first 2 rows using DeleteEmptyRows component but I am unable to delete the rows.

microsoft-excel

1 Comments

Swathi Muppalla posted this 10 April 2019 - Last edited 22 April 2019

Hi Sreekanth,

"DeleteEmptyRows" method can be used to delete empty row(s) in a range with existing data.

Also "Save" method has to be executed so that the file gets saved with changes.

Regards

Swathi Muppalla.