Delete the blank rows and columns

DeleteBlankRowsAndColumns.cs

// 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];

// This option will ensure the references (in formulas, charts)
// are updated while deleting blank rows and columns.
DeleteOptions options = new DeleteOptions();
options.UpdateReference = true;

// Delete the blank rows and columns.
sheet.Cells.DeleteBlankRows(options);
sheet.Cells.DeleteBlankColumns(options);

// Calculate formulas of workbook
wb.CalculateFormula();

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