Delete Blank Rows and Columns in a Worksheet

It is possible to delete all blank rows and columns from a worksheet. This is useful for example when generating a PDF file from a Microsoft Excel file and you 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.

Deleting Blank Rows

Deleting Blank Columns