Delete Blank Rows and Columns in a Worksheet with Go

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 you want to convert only rows and columns that contain data or related objects.

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

1. To delete blank rows, use the Cells.DeleteBlankRows() method. Please note, for blank rows that will be deleted, it is not only required that Row.IsBlank should be true, but also that there should be no visible comment defined for any cell in those rows, and no pivot tables whose range intersects with them.
2. To delete blank columns, use the Cells.DeleteBlankColumns() method.

Go code to delete Blank Rows

Go code to Delete Blank Columns