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