ObjectBridge

Hi Bill -

If you examine the sample UPDATE.EXCEL.SPREADSHEET program, you see that Z1 and Z2 are dynamic arrays passed to ATSETPROPERTY. Z1 is a list of property names and Z2 is a corresponding list of values to assign to those properties. The property name in Z1 can be appended with index values if the property acts like an array. In the example, the property name is 'Cells', which in Excel, works like an array, so the row and columns are appended using SVM as a separator. In the case of ATGETPROPERTY, Z1 is exactly the same as ATSETPROPERTY, and Z2 should return the cell values.

Thanks,

Pete

Hi Bill -

It looks like the Cell(x,y) property returned by Excel is not a string, but a Range object. ObjectBridge represents objects using consecutive integers, which explains what you are seeing. You need to then use each of the values returned in Z3 as objects and call ATGETPROPERTY for each of these, retrieving the 'Value' property of each:

Z3='' CALL ATGETPROPERTY(Worksheet, Z1, Z3, ERRMSG, OPTS) FOR I=1 TO DCOUNT(Z3,AM) CALL ATGETPROPERTY(Z3<I>,'VALUE',Z4,ERRMSG,OPTS) PRINT I:' ':Z4 NEXT I

Sorry about the misinformation. Excel's object model is quite complex, and ObjectBridge sometimes is too simplistic to cope adequately.

The reason it worked to set the property is that Excel probably uses the Value as the default property for the Range object, so it was not necessary to explicitly set it.

Thanks,

Pete