Formen zwischen Arbeitsblättern mit JavaScript über C++ kopieren
Contents
[
Hide
]
Manchmal müssen Sie Elemente auf einem Arbeitsblatt, z.B. Bilder, Diagramme und andere Zeichnungsobjekte, zwischen Arbeitsblättern kopieren. Aspose.Cells for JavaScript über C++ unterstützt dieses Feature. Diagramme, Bilder und andere Objekte können mit höchster Präzision kopiert werden.
Dieser Artikel vermittelt Ihnen ein umfassendes Verständnis dafür, wie Formen zwischen Arbeitsblättern kopiert werden.
Kopieren eines Bildes von einem Arbeitsblatt auf ein anderes
Um ein Bild von einem Arbeitsblatt auf ein anderes zu kopieren, verwenden Sie die Methode PictureCollection.add(number, number, number, number, Uint8Array), wie im folgenden Beispielcode gezeigt.
<!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>
Kopieren Sie ein Diagramm von einem Arbeitsblatt auf ein anderes
Der folgende Code demonstriert die Verwendung der Methode ShapeCollection.addCopy(Shape, number, number, number, number) zum Kopieren eines Diagramms von einem Arbeitsblatt auf ein anderes.
<!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>
Kopieren von Steuerelementen und anderen Zeichenobjekten von einem Arbeitsblatt auf ein anderes
Um Steuerelemente und andere Zeichenobjekte zu kopieren, verwenden Sie die ShapeCollection.addCopy(Shape, number, number, number, number)-Methode wie im untenstehenden Beispiel gezeigt.
<!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>