Maximalen Bereich in einem Arbeitsblatt mit JavaScript via C++ ermitteln
Contents
[
Hide
]
Beim Lesen von Daten aus dem Arbeitsblatt müssen wir den maximalen Bereich kennen.
Beim Kopieren aller Daten aus einem Arbeitsblatt müssen wir den maximalen Bereich kennen.
Beim Exportieren eines bestimmten Bereichs nach HTML und PDF müssen wir den maximalen Bereich kennen.
Aspose.Cells for JavaScript via C++ enthält verschiedene Möglichkeiten, den maximalen Bereich in einem Arbeitsblatt zu finden.
Den Maximalbereich abrufen
In Aspose.Cells werden, wenn die Objekte row und column initialisiert sind, diese Zeilen und Spalten zum maximalen Bereich gezählt, selbst wenn in leeren Zeilen oder Spalten keine Daten vorhanden sind.
<!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 () => {
const fileInput = document.getElementById('fileInput');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Loads the workbook from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get all the worksheets in the book.
const worksheets = workbook.worksheets;
const sheet = worksheets.get(0);
// Gets the max data range.
let maxRow = sheet.cells.maxRow;
let maxColumn = sheet.cells.maxColumn;
// The range is A1:B3 (based on maxRow/maxColumn).
let range = sheet.cells.createRange(0, 0, maxRow + 1, maxColumn + 1);
// Clear cell A10
const cell = sheet.cells.get("A10");
cell.value = null;
// Recalculate maxRow/maxColumn after clearing
maxRow = sheet.cells.maxRow;
maxColumn = sheet.cells.maxColumn;
// The range is updated (e.g., A1:B10).
range = sheet.cells.createRange(0, 0, maxRow + 1, maxColumn + 1);
// Save the modified workbook and provide a download link
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Operation completed successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>
Maximalen Datenbereich abrufen
In den meisten Fällen müssen wir nur alle Bereiche erhalten, die alle Daten enthalten, auch wenn die leeren Zellen außerhalb des Bereichs formatiert sind. Und die Einstellungen zu Formen, Tabellen und Pivot-Tabellen werden ignoriert.
<!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 () => {
const fileInput = document.getElementById('fileInput');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiate a new Workbook from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get all the worksheets in the book.
const worksheets = workbook.worksheets;
const sheet = worksheets.get(0);
// Gets the max data range.
let maxRow = sheet.cells.maxDataRow;
let maxColumn = sheet.cells.maxDataColumn;
// The range is A1:B3 (based on maxRow/maxColumn).
let range = sheet.cells.createRange(0, 0, maxRow + 1, maxColumn + 1);
// Clear cell A10 by setting its value to null
const cell = sheet.cells.get("A10");
cell.value = null;
// Recalculate max data range after clearing the cell
maxRow = sheet.cells.maxDataRow;
maxColumn = sheet.cells.maxDataColumn;
// The range is still A1:B3 (after clearing A10).
range = sheet.cells.createRange(0, 0, maxRow + 1, maxColumn + 1);
// Save the modified workbook and provide a download link
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Operation completed successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>
Maximale Anzeigebereich erhalten
Wenn wir alle Daten aus dem Arbeitsblatt in HTML, PDF oder Bildern exportieren, müssen wir einen Bereich erhalten, der alle sichtbaren Objekte enthält, einschließlich Daten, Styles, Grafiken, Tabellen und Pivot-Tabellen. Die folgenden Codes zeigen, wie der maximale Anzeigebereich in HTML gerendert wird:
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells Example - Export Range to HTML</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 () => {
const fileInput = document.getElementById('fileInput');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiate a new Workbook from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get all the worksheets in the book.
const worksheets = workbook.worksheets;
// Gets the max display range.
const range = worksheets.get(0).cells.maxDisplayRange;
// Save the range to html
const saveOptions = new AsposeCells.HtmlSaveOptions();
saveOptions.exportActiveWorksheetOnly = true;
saveOptions.exportArea = AsposeCells.CellArea.createCellArea(
range.firstRow,
range.firstColumn,
range.firstRow + range.rowCount - 1,
range.firstColumn + range.columnCount - 1
);
// Save the range to HTML format and provide download link
const outputData = workbook.save(SaveFormat.Html, saveOptions);
const blob = new Blob([outputData], { type: 'text/html' });
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'html.html';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download HTML File';
document.getElementById('result').innerHTML = '<p style="color: green;">Range exported successfully! Click the download link to get the HTML file.</p>';
});
</script>
</html>
Hier ist die Quelldatei Excel.