Excel Web Services - SetRangeA1
 

Hi
I'm attempting to use Excel Web Services, and am not getting the results I
expect.

I am attempting to use the SetRangeA1 method:

object[] objOne = new object[3];
objOne[0] = 1;

objOne[1] = 2;

objOne[2] = 3;

myEWS.SetRangeA1(sessionId, "Chi Square Calcs", "CalcFundOne", objOne);

and am getting the error message:

The requested range is not a valid sheet location.

If I change the range name "CalcFundOne" to an invalid name, I get a
different error message.
If I change the size of the object array, I get an error message saying that
my object array is the wrong size.

So I know that the range is being found and is of the correct size. So I
don't really understand what this error message means.

Any help much appreciated.
Cheers,
Charles