Delete Blank Rows From an Excel Document

DeleteBlankRows.cs

using Aspose.Cells;

// Open an existing excel file.
Workbook wb = new Workbook("SampleInput.xlsx");

// Get the worksheets collection in the spreadsheet.
WorksheetCollection sheets = wb.Worksheets;

// Get first Worksheet from WorksheetCollection by index.
Worksheet sheet = sheets[0];
// Or by name.
// Worksheet sheet = sheets["Sheet1"];

// Delete the Blank Rows from the worksheet.
sheet.Cells.DeleteBlankRows();

// Save the excel file.
wb.Save("SampleOutput.xlsx");