We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Deleting blank rows not working

I need to delete blank rows in a worksheet (see that attached FileWithBlankCells and the ExpectedOutput files). Essentially, I would like to delete the rows that have no data.

I have so far tried Cells.DeleteBlankRows() and Cells.DeleteRange() and none of these are giving the expected result. Please can you provide a code that produces the expected output.



Thanks for your template file and expected file.

Please see the following sample code, it would work fine as per your expected results. I have used your template file in the sample code.
Sample code:

Workbook workbook = new Workbook(“e:\test2\FilewithBlankCells.xlsx”);
Worksheet worksheet = workbook.Worksheets[0];
//Get the minimum firt data row.
int mrow = worksheet.Cells.MinDataRow;

//Since you want to retain initial blank rows, so you may insert n number of blank rows.
worksheet.Cells.InsertRows(0, mrow);


Hope, this helps a bit.

Thank you.