计算工作表中单元格的数量

计算工作表中单元格的数量

通过调用以下示例代码中所示的 Cells.getCount() 或 Cells.getCountLarge() 属性获取器,您可以计算工作表中的单元格数量。

示例代码

// 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.getSharedDataDir(CountNumberOfCells.class) + "Worksheets/";
//Load source Excel file
Workbook workbook = new Workbook(dataDir + "BookWithSomeData.xlsx");
//Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
//Print number of cells in the Worksheet
System.out.println("Number of Cells: " + worksheet.getCells().getCount());
// If the number of cells is greater than 2147483647, use CountLarge
System.out.println("Number of Cells (CountLarge): " + worksheet.getCells().getCountLarge());