How to get cell coordinates

Aspose.Cells Product Family
1

Which is the equivalent of the Top and Left properties of a Range object in Excel VBA?
I could get the coordinates in the Picture class of Cells.NET, but I couldn’t find such a property in the Cells class.

3

@TakaIkeda,

To get top left and bottom right cells of a range, you may try to use Range.FirstRow/FirstColumn and Range.RowCount/ColumnCount attributes. See the sample code segment for your reference:
e.g.
Sample code:

Range range = worksheet.Cells.CreateRange("A1:D4");

string topLeftCell = CellsHelper.CellIndexToName(range.FirstRow, range.FirstColumn);
string bottomRightCell = CellsHelper.CellIndexToName(range.FirstRow + range.RowCount - 1, range.FirstColumn + range.ColumnCount - 1);
string rangeAddress = string.Format("{0}:{1}", topLeftCell, bottomRightCell);

Hope, this helps a bit.

4

I want to get the cell coordinates, not the cell range.
See the image below.
Thanks.

sampleVBA.png (4.6 KB)

5

@TakaIkeda,

Thanks for the screenshot.

We are sorry but we do not provide such attributes for Range object in Aspose.Cells for .NET APIs.

6

I’ve understood.
Get Picture.LeftToCorner and Picture.TopToCorner after moving using the Picture.Move method.
I try to get this process repeatedly.
Thanks for cooperation.

7

@TakaIkeda,

It seems you have sorted it out for your requirements. In the event of further queries or issue, feel free to write us back.