Insérer des plages avec JavaScript via C++
Contents
[
Hide
]
Introduction
Dans Excel, vous pouvez sélectionner une plage, puis insérer une plage et déplacer d’autres données vers la droite ou vers le bas.
Insérer des plages en utilisant Aspose.Cells for JavaScript via C++
Aspose.Cells for JavaScript via C++ fournit la méthode Cells.insertRange(CellArea, nombre, ShiftType, boolean) pour insérer une plage.
Insérer des plages et déplacer les cellules vers la droite
Insérer une plage et décaler les cellules vers la droite avec Aspose.Cells :
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells 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 } = 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');
const resultDiv = document.getElementById('result');
if (!fileInput.files.length) {
resultDiv.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 which contains hidden external links
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Instantiate a new Workbook.
const newWorkbook = new Workbook();
// Get all the worksheets in the book.
const worksheets = newWorkbook.worksheets;
// Get the first worksheet in the worksheets collection.
const worksheet = newWorkbook.worksheets.get(0);
// Create a range of cells.
const sourceRange = worksheet.cells.createRange("A1", "A2");
// Input some data with some formattings into
// A few cells in the range.
sourceRange.get(0, 0).value = "Test";
sourceRange.get(1, 0).value = "123";
const ca = AsposeCells.CellArea.createCellArea("A1", "A2");
worksheet.cells.insertRange(ca, AsposeCells.ShiftType.Right);
const check = worksheet.cells.get("B1").value === "Test";
if (check) {
resultDiv.innerHTML = '<p style="color: green;">Value check passed: B1 === "Test".</p>';
} else {
resultDiv.innerHTML = '<p style="color: red;">Value check failed: B1 !== "Test".</p>';
}
// Saving the modified new workbook and providing download link
const outputData = newWorkbook.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';
});
</script>
</html>
Insérer des plages et décaler les cellules vers le bas
Insérer une plage et décaler les cellules vers le bas avec Aspose.Cells :
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Aspose.Cells 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 } = 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 which contains hidden external links
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Instantiate a new Workbook.
const newWorkbook = new Workbook();
// Get all the worksheets in the book.
const worksheets = newWorkbook.worksheets;
// Get the first worksheet in the worksheets collection.
const worksheet = newWorkbook.worksheets.get(0);
// Create a range of cells.
const sourceRange = worksheet.cells.createRange("A1", "A2");
// Input some data with some formattings into
// A few cells in the range.
const cell00 = sourceRange.get(0, 0);
cell00.value = "Test";
const cell10 = sourceRange.get(1, 0);
cell10.value = 123;
const ca = AsposeCells.CellArea.createCellArea("A1", "A2");
worksheet.cells.insertRange(ca, AsposeCells.ShiftType.Down);
const check = worksheet.cells.get("A3").value === "Test";
console.log(check);
document.getElementById('result').innerHTML = `<p style="color: green;">Check result: ${check}</p>`;
const outputData = newWorkbook.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 Result Excel File';
});
</script>
</html>