Ermittlung der absoluten Position einer Form innerhalb des Arbeitsblatts
Contents
[
Hide
]
Manchmal müssen Sie die absolute Position einer Form in einem Arbeitsblatt kennen. Aspose.Cells für Python via .NET bietet die Eigenschaften Shape.left_to_corner und Shape.top_to_corner für diesen Zweck. Diese Eigenschaften geben die absolute Position der Form im Arbeitsblatt in Pixel zurück.
Der folgende Beispielcode zeigt die absolute Position der ersten Form im Arbeitsblatt in Pixeln an. Der Beispielcode zeigt die folgende Konsolenausgabe:
Absolute Position of this Shape is (320 , 183)
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 | |
# The path to the documents directory. | |
dataDir = RunExamples.GetDataDir(".") | |
# Load the sample Excel file inside the workbook object | |
workbook = Workbook(dataDir + "sample.xlsx") | |
# Access the first worksheet | |
worksheet = workbook.worksheets[0] | |
# Access the first shape inside the worksheet | |
shape = worksheet.shapes[0] | |
# Displays the absolute position of the shape | |
print("Absolute Position of this Shape is ({0} , {1})", shape.left_to_corner, shape.top_to_corner) |