Copier des plages d Excel avec JavaScript via C++
Contents
[
Hide
]
Introduction
Dans Excel, vous pouvez sélectionner une plage, copier la plage, puis la coller avec des options spécifiques dans la même feuille de calcul, d’autres feuilles de calcul ou d’autres fichiers.
Copier des plages en utilisant Aspose.Cells for JavaScript via C++
Aspose.Cells for JavaScript via C++ fournit quelques méthodes surcharge Range.copy(Range, PasteOptions) pour copier la plage. Et Range.copyStyle(Range) ne copie que le style de la plage ; Range.copyData(Range) ne copie que la valeur de la plage.
Copier la plage
Création de deux plages : la plage source, la plage cible, puis copie de la plage source vers la plage cible avec la méthode Range.copy.
Voir le code suivant :
<!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');
let workbook;
if (fileInput.files.length) {
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
workbook = new Workbook(new Uint8Array(arrayBuffer));
} else {
workbook = new Workbook();
}
// Get all the worksheets in the book.
let worksheets = workbook.worksheets;
// Get the first worksheet in the worksheets collection.
let worksheet = workbook.worksheets.get(0);
// Create a range of cells.
let 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;
// Create target range of cells.
let targetRange = worksheet.cells.createRange("B1", "B2");
// Copy source range to target range in the same worksheet
targetRange.copy(sourceRange);
// Create target range of cells.
workbook.worksheets.add();
worksheet = workbook.worksheets.get(1);
targetRange = worksheet.cells.createRange("A1", "A2");
// Copy source range to target range in another worksheet
targetRange.copy(sourceRange);
// Copy to another workbook
const anotherWorkbook = new Workbook();
worksheet = workbook.worksheets.get(0);
targetRange = worksheet.cells.createRange("A1", "A2");
// Copy source range to target range in another workbook
targetRange.copy(sourceRange);
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!</p>';
});
</script>
</html>
Coller la plage avec des options
Aspose.Cells for JavaScript via C++ supporte la collation de la plage avec des types spécifiques.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Paste Range Example</title>
</head>
<body>
<h1>Paste Range 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, PasteOptions, PasteType } = 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));
// Get all the worksheets in the book.
const worksheets = workbook.worksheets;
// Get the first worksheet in the worksheets collection.
const worksheet = workbook.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;
// Create target range of cells.
const targetRange = worksheet.cells.createRange("B1", "B2");
// Init paste options.
const options = new PasteOptions();
// Set paste type.
options.pasteType = PasteType.ValuesAndFormats;
options.skipBlanks = true;
// Copy source range to target range
targetRange.copy(sourceRange, options);
// Saving the modified Excel file
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;">Range copied successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>
Copier uniquement les données de la plage
De plus, vous pouvez copier les données avec la méthode Range.copyData comme montré dans le code suivant :
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Copy Range 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();
// Instantiating a Workbook object from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get all the worksheets in the book.
const worksheets = workbook.worksheets;
// Get the first worksheet in the worksheets collection.
const worksheet = 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;
// Create target range of cells.
const targetRange = worksheet.cells.createRange("B1", "B2");
// Copy the data of source range to target range
targetRange.copyData(sourceRange);
// Saving the modified Excel file
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;">Range copied successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>