c# and Excel range coordinates

A

aaj

Hi

I use the Excel 10 object library in one of my apps, and to read a range of
cells I use :

Excel.Range range = worksheet.get_Range(start,end);

(System.Array)range.Cells.Value2;

to read an array with coordinates and value of a range of cells and it
returns something like
[1,1] = "A1's value"
[1,2] = "B1's value"etc...

what I need to to is to consitently decode [1,1] into the Absolute
coordinate system used in Excel i.e. [1,1] = [A,1], and [1,2] = [B,2] etc

so no matter what values I use for start and End, I can find out exactly
what the Excel coordiantes are

Is there anyway to do this?

many thanks

Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top