Copy Ranges of Excel with JavaScript via C++
Contents
[
Hide
]
Introduction
In Excel, you can select a range, copy the range, then paste it with specific options to the same worksheet, other worksheets, or other files.
Copy Ranges Using Aspose.Cells for JavaScript via C++
Aspose.Cells for JavaScript via C++ provides several overloaded methods, such as Range.copy(Range, PasteOptions), to copy a range. The method Range.copyStyle(Range) copies only the style of the range, while Range.copyData(Range) copies only the values of the range.
Copy Range
Creating two ranges—the source range and the target range—and then copying the source range to the target range with the Range.copy method.
See the following code:
<!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 formatting 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>
Paste Range With Options
Aspose.Cells for JavaScript via C++ supports pasting the range with specific types.
<!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 formatting 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>
Only Copy Data Of The Range
You can also copy only the data with the Range.copyData method, as shown in the following code:
<!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 formatting 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>