Finding Absolute Position of Shape Inside the Worksheet with Node.js via C++

Sometimes, you need to know the absolute position of a shape in a worksheet. Aspose.Cells for Node.js via C++ provides the Shape.getLeftToCorner() and Shape.getTopToCorner() 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 produces the following console output:

Absolute Position of this Shape is (320, 183)

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Load the sample Excel file into the workbook object
const workbook = new AsposeCells.Workbook(path.join(dataDir, "sample.xlsx"));

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

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

// Display the absolute position of the shape
console.log(`Absolute Position of this Shape is (${shape.getLeftToCorner()}, ${shape.getTopToCorner()})`);