Radera tomma rader och kolumner i ett kalkylblad
Contents
[
Hide
]
Det är möjligt att ta bort alla tomma rader och kolumner från ett kalkylblad. Detta är användbart till exempel när du genererar en PDF-fil från en Microsoft Excel-fil och vill konvertera endast rader och kolumner som innehåller data.
Använd följande Aspose.Cells-metoder för att ta bort tomma rader och kolumner:
- För att ta bort tomma rader, använd Cells.deleteBlankRows() metoden.
- För att ta bort tomma kolumner, använd Cells.deleteBlankColumns() metoden.
Tar bort tomma rader
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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"); | |
Tar bort tomma kolumner
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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"); |