Find Maximum Rows and Columns supported by XLS and XLSX formats with JavaScript via C++
Contents
[
Hide
]
Possible Usage Scenarios
There are different numbers of rows and columns supported by Excel formats. For example, XLS supports 65536 rows and 256 columns while XLSX supports 1048576 rows and 16384 columns. If you want to know how many rows and columns are supported by a given format, you can use WorkbookSettings.maxRow and WorkbookSettings.maxColumn properties.
Find Maximum Rows and Columns supported by XLS and XLSX formats
The following sample code creates a workbook first in XLS and then in XLSX format. After creation, it prints the values of WorkbookSettings.maxRow and WorkbookSettings.maxColumn properties. Please see the console output of the code given below for your reference.
Sample Code
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Maximum Rows and Columns Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample" disabled>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, Utils } = AsposeCells;
const runBtn = document.getElementById('runExample');
const resultDiv = document.getElementById('result');
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
runBtn.disabled = false;
});
runBtn.addEventListener('click', async () => {
// Print message about XLS format.
resultDiv.innerHTML = '<p>Maximum Rows and Columns supported by XLS format.</p>';
// Create workbook in XLS format.
let wb = new Workbook(AsposeCells.FileFormatType.Excel97To2003);
// Print the maximum rows and columns supported by XLS format.
let maxRows = wb.settings.maxRow + 1;
let maxCols = wb.settings.maxColumn + 1;
resultDiv.innerHTML += `<p>Maximum Rows: ${maxRows}</p>`;
resultDiv.innerHTML += `<p>Maximum Columns: ${maxCols}</p>`;
resultDiv.innerHTML += '<hr/>';
// Print message about XLSX format.
resultDiv.innerHTML += '<p>Maximum Rows and Columns supported by XLSX format.</p>';
// Create workbook in XLSX format.
wb = new Workbook(AsposeCells.FileFormatType.Xlsx);
// Print the maximum rows and columns supported by XLSX format.
maxRows = wb.settings.maxRow + 1;
maxCols = wb.settings.maxColumn + 1;
resultDiv.innerHTML += `<p>Maximum Rows: ${maxRows}</p>`;
resultDiv.innerHTML += `<p>Maximum Columns: ${maxCols}</p>`;
});
</script>
</html>
Console Output
Maximum Rows and Columns supported by XLS format.
Maximum Rows: 65536
Maximum Columns: 256
Maximum Rows and Columns supported by XLSX format.
Maximum Rows: 1048576
Maximum Columns: 16384