Finding Absolute Position of Shape inside the Worksheet

Sometimes, you need to know the absolute position of a shape on a worksheet. Aspose.Cells provides the Shape.getLeftToCorner() and Shape.getTopToCorner() properties for this purpose. These properties return the absolute position of a shape in a worksheet in pixels.

Explanation of the Shape.getLeftToCorner() and Shape.getTopToCorner() properties

This screenshot explains what distances the Shape.getLeftToCorner() and Shape.getTopToCorner() properties measure.

Measuring absolute position

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

Absolute Position of this Shape is (320, 180)

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(FindAbsolutePositionOfShape.class);
// Load the sample Excel file inside the workbook object
Workbook workbook = new Workbook("sample.xlsx");

// Access the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

// Access the first shape inside the worksheet
Shape shape = worksheet.getShapes().get(0);

// Displays the absolute position of the shape
System.out.println("Absolute Position of this Shape is (" + shape.getLeftToCorner() + " , "
		+ shape.getTopToCorner() + ")");