Count number of cells in the Worksheet

Contents
[ ]

You may count the number of cells in the worksheet by using the Cells.count or Cells.count_large properties as shown in the code example given below.

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))