Get Address, Cell Count, Offset, Entire Column, and Entire Row of the Range with JavaScript via C++
Contents
[
Hide
]
Possible Usage Scenarios
Aspose.Cells for JavaScript via C++ provides the Range object, which has various utility methods that facilitate the user in working with Excel ranges easily. This article illustrates the usage of the following methods or properties of the Range object.
-
Address
Gets the address of the range.
-
Cell Count
Gets the total cell count in the range.
-
Offset
Gets a range by offset.
-
Entire Column
Gets a Range object that represents the entire column (or columns) that contains the specified range.
-
Entire Row
Gets a Range object that represents the entire row (or rows) that contains the specified range.
Get Address, Cell Count, Offset, Entire Column, and Entire Row of the Range
The following sample code demonstrates the usage of the methods and properties discussed above. Please see the console output of the code below for reference.
Sample Code
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Example Title</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
// This example creates ranges on a new empty workbook and prints information to the page.
const resultEl = document.getElementById('result');
resultEl.innerHTML = '';
// Create empty workbook.
const wb = new Workbook();
// Access first worksheet.
const ws = wb.worksheets.get(0);
// Create range A1:B3.
console.log("Creating Range A1:B3\n");
let rng = ws.cells.createRange("A1:B3");
// Print range address and cell count.
const lines = [];
lines.push("Range Address: " + rng.address);
lines.push("Range Row Count: " + rng.rowCount);
lines.push("Range Column Count: " + rng.columnCount);
// Formatting console output.
lines.push("----------------------");
lines.push("");
// Create range A1.
console.log("Creating Range A1\n");
rng = ws.cells.createRange("A1");
// Print range offset, entire column, and entire row.
lines.push("Offset: " + rng.offset(2, 2).address);
lines.push("Entire Column: " + rng.entireColumn.address);
lines.push("Entire Row: " + rng.entireRow.address);
// Formatting console output.
lines.push("----------------------");
lines.push("");
// Display results
resultEl.innerHTML = '<pre>' + lines.join("\n") + '</pre>';
});
</script>
</html>
Console Output
Creating Range A1:B3
Range Address: A1:B3
Cell Count: 6
----------------------
Creating Range A1
Offset: C3
Entire Column: A:A
Entire Row: 1:1
----------------------