Kopiera former mellan kalkylblad med JavaScript via C++
Contents
[
Hide
]
Ibland måste du kopiera element på ett kalkylblad, till exempel bilder, diagram och andra ritobjekt, mellan kalkylblad. Aspose.Cells for JavaScript via C++ stöder denna funktion. Diagram, bilder och andra objekt kan kopieras med högsta precision.
Den här artikeln ger en detaljerad förståelse för hur man kopierar former mellan arkmallar.
Kopiera en bild från ett ark till ett annat
För att kopiera en bild från ett ark till ett annat, använd metoden PictureCollection.add(number, number, number, number, Uint8Array) enligt det visade kodexemplet nedan.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
<meta charset="utf-8" />
</head>
<body>
<h1>Copy Picture Between Worksheets</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();
// Instantiate Workbook from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get the Picture from the "Picture" worksheet.
const pictureSheet = workbook.worksheets.get("Picture");
const pictureSource = pictureSheet.pictures.get(0);
// Save Picture to Memory (property access converted from getData())
const ms = pictureSource.data;
// Copy the picture to the Result Worksheet (properties converted)
const resultSheet = workbook.worksheets.get("Result");
resultSheet.pictures.add(
pictureSource.upperLeftRow,
pictureSource.upperLeftColumn,
ms,
pictureSource.widthScale,
pictureSource.heightScale
);
// Save the modified workbook and provide 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 = 'PictureCopied_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
resultDiv.innerHTML = '<p style="color: green;">Picture copied successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>
Kopiera ett diagram från ett ark till ett annat
Följande kod visar användningen av ShapeCollection.addCopy(Shape, number, number, number, number) metoden för att kopiera ett diagram från ett ark till ett annat.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Copy Chart Between Sheets 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, Utils } = 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 the Chart from the "Chart" worksheet.
const chartsource = workbook.worksheets.get("Chart").charts.get(0);
const cshape = chartsource.chartObject;
// Copy the Chart to the Result Worksheet
workbook.worksheets.get("Result").shapes.addCopy(cshape, 20, 0, 2, 0);
// Save the Worksheet
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'ChartCopied_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Chart copied successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>
Kopiera kontroller och andra ritobjekt från ett ark till ett annat
För att kopiera kontroller och andra ritobjekt, använd ShapeCollection.addCopy(Shape, number, number, number, number)-metoden som visas i exemplet nedan.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Copy Shapes Between Worksheets</title>
</head>
<body>
<h1>Copy Shapes Between Worksheets</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();
// Open the workbook from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Get the Shapes from the "Control" worksheet.
const controlShapes = workbook.worksheets.get("Control").shapes;
// Copy the Textbox to the Result Worksheet
workbook.worksheets.get("Result").shapes.addCopy(controlShapes.get(0), 5, 0, 2, 0);
// Copy the Oval Shape to the Result Worksheet
workbook.worksheets.get("Result").shapes.addCopy(controlShapes.get(1), 10, 0, 2, 0);
// 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 = 'ControlsCopied_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Shapes copied successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>