Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Text Services to Counts of Services | Excel Discussion (Misc queries) | |||
Excel Add-In for Analysis Services - What-If | Excel Programming | |||
Excel, COM+ and Web Services | Excel Programming | |||
New Excel Add-In for Analysis Services | Excel Programming | |||
Web Services desde excel!!! | Excel Programming |