efficient / easy way to convert an Excel.Range to a double[,]

[My interest]

Somewhat I remember I used to be able to do sth like the the following

double[,] values = (double[,])excel_range.Va lue2

But it seems to be not working any more, throwing an exception "cannot
convert System.Object[,] to System.Double[,]"

Of course, I can do iteration and, as a bottom line, using
Double.Parse(ce ll_value.ToStri ng()). The question is there a more
efficient way to do the job?

I am using Office XP with PIA.

Thanks.

[My interest]

Just to make it clearer, the emphasis is how to convert multiple cells
in a ranger efficiently (e.g. in one call)

[Kalpesh]

While I don't have the environment to do the C# stuff in Excel -
value2 returns a jagged array
So, this should work

double[][] values = (double[][])excel_range.Va lue2

Does this help?

Kalpesh

[My interest]

On Dec 18, 1:39 am, Kalpesh <shahkalp...@gm ail.comwrote:

While I don't have the environment to do the C# stuff in Excel -
value2 returns a jagged array
So, this should work

double[][] values = (double[][])excel_range.Va lue2

Does this help?

Kalpesh

No,unfortunatel y this does not work. In C#, it seems that Value2
returns a Object[,] instead of a jagged array.

[Kalpesh]

This works well.
When transferring data from object[,] to double[,] - use copy method &
specify length of the array.
In this case it is 4 (2 rows, 2 columns)

See the code below for example.

object[,] data = new object[2,2];
data[0,0] = 0.5d;
data[0,1] = 1.5d;
data[1,0] = 2.0d;
data[1,1] = 5.5d;

double[,] ddata = new double[2,2];
Array.Copy(data , ddata, 4);
Console.WriteLi ne("ok");
ddata[0,0] = 3.5;

Console.WriteLi ne(ddata[0,0]);
Console.WriteLi ne(ddata[0,1]);
Console.WriteLi ne(ddata[1,0]);
Console.WriteLi ne(ddata[1,1]);

HTH
Kalpesh