Trouver la position absolue de la forme dans la feuille de calcul
Contents
[
Hide
]
Parfois, vous avez besoin de connaître la position absolue d’une forme dans une feuille de calcul. Aspose.Cells pour Python via .NET fournit les propriétés Shape.left_to_corner et Shape.top_to_corner à cet usage. Ces propriétés retournent la position absolue de la forme dans la feuille en pixels.
Le code d’exemple suivant affiche la position absolue de la première forme dans la feuille de calcul en pixels. Le code d’exemple affiche la sortie console suivante :
Absolute Position of this Shape is (320 , 183)
This file contains hidden or 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) |