Get Cells Range

Possible Usage Scenarios

When you only need to manipulate some data on the worksheet, you need to know the data range of the entire worksheet. Aspose.Cells for Node.js via C++ offers this feature. Aspose.Cells for Node.js via C++ provides the following properties and methods to help you achieve your goals.

• Cells.getMaxDisplayRange
• Cells.getMaxRow
• Cells.getMaxDataRow
• Cells.getMaxColumn
• Cells.getMaxDataColumn

Get Cells Range using Aspose.Cells for Node.js via C++

This example shows how to:

1. Create a workbook.
2. Add data to cells in the first worksheet.
3. Get Cells Range.

const AsposeCells = require("aspose.cells.node");

var workbook = new AsposeCells.Workbook(AsposeCells.FileFormatType.Xlsx);
var cells = workbook.getWorksheets().get(0).getCells();

//Setting the value to the cells
var cell = cells.get("A1");
cell.putValue("Fruit");
cell = cells.get("B1");
cell.putValue("Count");
cell = cells.get("C1");
cell.putValue("Price");

cell = cells.get("A2");
cell.putValue("Apple");
cell = cells.get("A3");
cell.putValue("Mango");
cell = cells.get("A4");
cell.putValue("Blackberry");
cell = cells.get("A5");
cell.putValue("Cherry");

cell = cells.get("B2");
cell.putValue(5);
cell = cells.get("B3");
cell.putValue(3);
cell = cells.get("B4");
cell.putValue(6);
cell = cells.get("B5");
cell.putValue(4);

cell = cells.get("C2");
cell.putValue(5);
cell = cells.get("C3");
cell.putValue(20);
cell = cells.get("C4");
cell.putValue(30);
cell = cells.get("C5");
cell.putValue(60);

cell = cells.get("E10");
var temp = workbook.createStyle();
temp.getFont().setColor(new AsposeCells.Color(255, 0, 0));
cell.setStyle(temp);


// Get max display range of worksheet
var range = cells.getMaxDisplayRange();

//get maximum row index of cell which contains data or style.
console.log(cells.getMaxRow());

//get maximum row index of cell which contains data.
console.log(cells.getMaxDataRow());

//get maximum column index of cell which contains data or style.
console.log(cells.getMaxColumn());

//get maximum column index of cell which contains data.
console.log(cells.getMaxDataColumn());