Finding Absolute Position of Shape inside the Worksheet

Sometimes, you need to know the absolute position of a shape in a worksheet. Aspose.Cells for Python via .NET provides the Shape.left_to_corner and Shape.top_to_corner properties for this purpose. These properties return the absolute position of the shape inside the worksheet in pixels.

The following sample code displays the absolute position of the first shape in the worksheet in pixels. The sample code displays the following console output:

Absolute Position of this Shape is (320 , 183)

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)