Unable to Delete Empty Rows in Excel

  • 48 Views
  • Last Post 2 weeks ago
sreekanth.lavu@sparshcom.net posted this 2 weeks ago

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.intellibot@gmail.com posted this 2 weeks ago

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.

 

If you are looking to delete empty cells from a range, "DeleteContentFromRange" method can be used.

"DeleteRow" method can be used alternatively to delete a specific empty row from an excel sheet.

 

Regards

Swathi Muppalla

 

Close