حذف الصفوف والأعمدة الفارغة في ورقة العمل

حذف الصفوف الفارغة

// 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");