Conversion between cell name and row/column index
Get Cell Name from Row and Column Indices
It is possible to find a cell’s name given the row and column index. This article explains how. Aspose.Cells for JavaScript via C++ provides the CellsHelper.cellIndexToName method which allows developers to get a cell’s name if they provide the row and column index.
The following sample code illustrates how to use CellsHelper.cellIndexToName to access the cell’s name given a known row and column index. The code generates the following output.
<!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, Worksheet, Cell } = 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 () => {
// Original logic converted to browser JavaScript
var row = 3;
var column = 5;
var name = AsposeCells.CellsHelper.cellIndexToName(row, column);
console.log("Cell name: " + name);
document.getElementById('result').innerHTML = '<p>Cell name: ' + name + '</p>';
});
</script>
</html>
Get Row and Column Indices from Cell Name
It is possible to find a row and column index of the cell from its name. This article explains how. Aspose.Cells for JavaScript via C++ provides the CellsHelper.cellNameToIndex method which allows developers to get a row and column index from the cell’s name.
The following sample code illustrates how to use CellsHelper.cellNameToIndex to get the row and column index from the cell’s name. The code generates the following output.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Get Row and Column from Cell Name</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<div>
<label for="cellName">Cell Name:</label>
<input type="text" id="cellName" value="C4" />
</div>
<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, CellsHelper } = AsposeCells;
let asposeInitialized = false;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
asposeInitialized = true;
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', () => {
if (!asposeInitialized) {
document.getElementById('result').innerHTML = '<p style="color: red;">Aspose.Cells is not initialized yet. Please wait and try again.</p>';
return;
}
const name = document.getElementById('cellName').value || "C4";
const rowCol = CellsHelper.cellNameToIndex(name);
const currRow = rowCol[0];
const currCol = rowCol[1];
console.log("Row: " + currRow + " , Column: " + currCol);
document.getElementById('result').innerHTML = `<p>Row: ${currRow} , Column: ${currCol}</p>`;
});
</script>
</html>
Create safe sheet names
Sometimes there is a need of assigning the sheet name at runtime. In this scenario, there may be sheet names which may contain some additional characters like <>+(?”. There is a need to replace any such character, which is not allowed as a sheet name with some preset character provided by user. Similarly the length may increase to more than 31 characters which needs to be truncated. Apache POI provides certain features of creating safe names, hence similar feature is provided by Aspose.Cells for JavaScript via C++ to handle all these issues. Following sample code demonstrates this feature:
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Create Safe Sheet Name</title>
</head>
<body>
<h1>Create Safe Sheet Name Example</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, Worksheet, Cell } = 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', () => {
// Long name will be truncated to 31 characters
var name1 = AsposeCells.CellsHelper.createSafeSheetName("this is first name which is created using CellsHelper.CreateSafeSheetName and truncated to 31 characters");
// Any invalid character will be replaced with _
var name2 = AsposeCells.CellsHelper.createSafeSheetName(' <> + (adj.Private ? " Private" : ")', '_');
// Display results in the page
const resultDiv = document.getElementById('result');
resultDiv.innerHTML = '<p><strong>Safe Name 1:</strong> ' + name1 + '</p>' +
'<p><strong>Safe Name 2:</strong> ' + name2 + '</p>';
});
</script>
</html>
Output:
this is first name which is cre
<> + (adj.Private _ " Private"