Build 3.5.0.8 of xlsgen introduces a pixel-based application programming interface (API) for creating vector shapes.

Currently, the model is based on columns and rows, as well as offsets.

With pixels, a floating 2D coordinate system is introduced. Obviously, pixels are converted internally in terms of columns, rows and offsets, so this is really for helping users write client applications. The 2D coordinate system has an origin in the top-left cell A1.

Here is how to use it :

worksheet.NewVectorShapeInPixels(vectorshapetype, 
                                         top,       // expressed in pixels
                                         left,       // expressed in pixels
                                         bottom,  // expressed in pixels
                                         right);  // expressed in pixels

In relation to working with pixels, it is always possible to query information about the Excel grid by using the Position property exposed in IXlsWorksheetColumns and IXlsWorksheetRows.