Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
You may count the number of cells in the worksheet by using the Cells.getCount() or Cells.getCountLarge() properties as shown in the code example given below.
const path = require("path");
const AsposeCells = require("aspose.cells.node");
// Source directory
const sourceDir = path.join(__dirname, "data");
// Load source Excel file
const filePath = path.join(sourceDir, "BookWithSomeData.xlsx");
const workbook = new AsposeCells.Workbook(filePath);
// Access first worksheet
const worksheet = workbook.getWorksheets().get(0);
// Print number of cells in the Worksheet
console.log("Number of Cells: " + worksheet.getCells().getCount());
// If the number of cells is greater than 2147483647, use CountLarge
console.log("Number of Cells (CountLarge): " + worksheet.getCells().getCountLarge());
Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.