I can get setcell to work but if I need to write to 200 cells that's 200 trips back and forth to the server while setrange would be one trip.
The error I get is that "The size of the provided array does not match the size and shape of the destination range." Even when I try setting a single cell I still get this error. I've tried lots of variations but nothing works. I'm hoping someone has had success with this and can give me an example that works so I can model my workflow after it. Ideally I'd like examples of both a single column or row and a matrix of columns and rows but I'd be very happy if I could just get one column to work.
My issue is with the <anyType>xml</anyType>