Eliminar Filas y Columnas en Blanco en una Hoja de Cálculo
Contents
[
Hide
]
Es posible eliminar todas las filas y columnas en blanco de una hoja de cálculo. Esto es útil, por ejemplo, al generar un archivo PDF a partir de un archivo de Microsoft Excel y desea convertir solo las filas y columnas que contienen datos.
Use los siguientes métodos de Aspose.Cells para eliminar filas y columnas vacías:
- Para eliminar filas en blanco, utilice el método Cells.deleteBlankRows().
- Para eliminar columnas en blanco, utilice el método Cells.deleteBlankColumns().
Eliminando Filas en Blanco
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"); | |
Eliminando Columnas en Blanco
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"); |