Kopiera former mellan arkmallar
Contents
[
Hide
]
Ibland måste du kopiera element på ett kalkylblad, till exempel bilder, diagram och andra ritobjekt, mellan kalkylblad. Aspose.Cells for Python via .NET 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 Worksheet.pictures.add enligt det visade kodexemplet nedan.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| from io import BytesIO | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Open the template file | |
| workbook = Workbook(dataDir + "sample.xlsx") | |
| # Get the Picture from the "Picture" worksheet. | |
| picturesource = workbook.worksheets.get("Picture").pictures[0] | |
| # Save Picture to Memory Stream | |
| ms = BytesIO(picturesource.data) | |
| # Copy the picture to the Result Worksheet | |
| workbook.worksheets.get("Result").pictures.add(picturesource.upper_left_row, picturesource.upper_left_column, ms, picturesource.width_scale, picturesource.height_scale) | |
| # Save the Worksheet | |
| workbook.save(dataDir + "PictureCopied_out.xlsx") |
Kopiera ett diagram från ett ark till ett annat
Följande kod visar användningen av Worksheet.shapes.add_copy metoden för att kopiera ett diagram från ett ark till ett annat.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Open the template file | |
| workbook = Workbook(dataDir + "sample.xlsx") | |
| # Get the Chart from the "Chart" worksheet. | |
| chartsource = workbook.worksheets.get("Chart").charts[0] | |
| cshape = chartsource.chart_object | |
| # Copy the Chart to the Result Worksheet | |
| workbook.worksheets.get("Result").shapes.add_copy(cshape, 20, 0, 2, 0) | |
| # Save the Worksheet | |
| workbook.save(dataDir + "ChartCopied_out.xlsx") |
Kopiera kontroller och andra ritobjekt från ett ark till ett annat
För att kopiera kontroller och andra ritobjekt, använd metoden Worksheet.shapes.add_copy enligt exemplet nedan.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Open the template file | |
| workbook = Workbook(dataDir + "sample2.xlsx") | |
| # Get the Shapes from the "Control" worksheet. | |
| shape = workbook.worksheets.get("Control").shapes | |
| # Copy the Textbox to the Result Worksheet | |
| workbook.worksheets.get("Result").shapes.add_copy(shape[0], 5, 0, 2, 0) | |
| # Copy the Oval Shape to the Result Worksheet | |
| workbook.worksheets.get("Result").shapes.add_copy(shape[1], 10, 0, 2, 0) | |
| # Save the Worksheet | |
| workbook.save(dataDir + "ControlsCopied_out.xlsx") |