在工作表中删除空行和空列

可以删除工作表中的所有空白行和列。例如，从Microsoft Excel文件生成PDF文件时，如果要转换仅包含数据的行和列，这将非常有用。

使用以下Aspose.Cells方法来删除空行和空列:

1. 要删除空白行，请使用 Cells.deleteBlankRows() 方法。
2. 要删除空白列，请使用 Cells.deleteBlankColumns() 方法。

删除空行

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(DeletingBlankRows.class);
// Create a new Workbook. Open an existing excel file.
Workbook wb = new Workbook(dataDir + "Book1.xlsx");

// Create a Worksheets object with reference to the sheets of the Workbook.
WorksheetCollection sheets = wb.getWorksheets();

// Get first Worksheet from WorksheetCollection
Worksheet sheet = sheets.get(0);

// Delete the Blank Rows from the worksheet
sheet.getCells().deleteBlankRows();

// Save the excel file.
wb.save(dataDir + "Output.xlsx");

删除空列

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(DeletingBlankColumns.class);
// Create a new Workbook. Open an existing excel file.
Workbook wb = new Workbook(dataDir + "Book1.xlsx");

// Create a Worksheets object with reference to the sheets of the Workbook.
WorksheetCollection sheets = wb.getWorksheets();

// Get first Worksheet from WorksheetCollection
Worksheet sheet = sheets.get(0);

// Delete the Blank Columns from the worksheet
sheet.getCells().deleteBlankColumns();

// Save the excel file.
wb.save(dataDir + "Output.xlsx");