Free Support Forum -

Convert pixels to column/row number


Is there any way by which I can convert pixels to columns numbers with aspose cells for java.
For e.g. Given a row number 15. I need to know what is the number of pixels this row is infrom the top of the work sheet and vice-versa.
Gicen column number 3, I need to know the number of pixels from the left of the workshhet

Note : consider case when rows and columns are stretched from its default height/width.


Well, we do provide two methods for Shape class named getPositionY and getPositionX to obtain the position of the vertical/horizontal offset from the top border of sheet(i.e. top border of Cell “A1”), in the unit of pixels. Do you need these type of methods for Row and Column classes for your need. We can look into them soon.

Thank you.