Elimina righe e colonne vuote in un foglio di lavoro

È possibile eliminare tutte le righe e le colonne vuote da un foglio di lavoro. Ciò è utile quando, ad esempio, si genera un file PDF da un file Excel Microsoft e si desidera convertire solo righe e colonne che contengono dati.

Utilizzare i seguenti metodi Aspose.Cells per eliminare righe e colonne vuote:

1. Per eliminare le righe vuote, utilizzare ilCells.DeleteBlankRows() metodo.
2. Per eliminare le colonne vuote, utilizzare ilCells. Elimina colonne vuote () metodo.

C# codice per eliminare righe vuote

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Open an existing excel file.
Workbook wb = new Workbook(dataDir+ "SampleInput.xlsx");

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

// Get first Worksheet from WorksheetCollection
Worksheet sheet = sheets[0];

// Delete the Blank Rows from the worksheet
sheet.Cells.DeleteBlankRows();

// Save the excel file.
wb.Save(dataDir+ "mybook.out.xlsx");

C# codice per eliminare colonne vuote

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Open an existing excel file.
Workbook wb = new Workbook(dataDir+ "SampleInput.xlsx");

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

// Get first Worksheet from WorksheetCollection
Worksheet sheet = sheets[0];

// Delete the Blank Columns from the worksheet
sheet.Cells.DeleteBlankColumns();

// Save the excel file.
wb.Save(dataDir+ "mybook.out.xlsx");