Compter le nombre de cellules dans la feuille de calcul

Contents
[ ]

Vous pouvez compter le nombre de cellules dans la feuille de calcul en utilisant les propriétés Cells.Count ou Cells.CountLarge comme indiqué dans l’exemple de code ci-dessous.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
//Load source Excel file
Workbook workbook = new Workbook(sourceDir + "BookWithSomeData.xlsx");
//Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Print number of cell in the Worksheet
Console.WriteLine("Number of Cells: " + worksheet.Cells.Count);
// In the number of cells is greater than 2147483647, use CountLarge
Console.WriteLine("Number of Cells (CountLarge): " + worksheet.Cells.CountLarge);