Delete Blank Rows and Columns in a Worksheet

It is possible to delete all blank rows and columns from a worksheet. This is useful when, for example, generating a PDF file from a Microsoft Excel file and want to convert only rows and columns that contain data.

Use the following Aspose.Cells methods to delete empty rows and columns:

1. To delete blank rows, use the Cells.DeleteBlankRows() method.
2. To delete blank columns, use the Cells.DeleteBlankColumns() method.

C# code to delete Blank Rows

C# code to Delete Blank Columns