Unable to Delete Empty Rows in Excel

  • Last Post 10 April 2019
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.


Swathi Muppalla posted this 10 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.




Swathi Muppalla.