Unable to Delete Empty Rows in Excel

  • 150 Views
  • 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.

 

 

Regards

Swathi Muppalla.

 

Close