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.count_large comme indiqué dans l’exemple de code ci-dessous.

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