Board index » delphi » "Cells" Property not supported Automation Object

"Cells" Property not supported Automation Object

In a TOLEContainer with an excel object created from file I have
tried to use:

Worksheet[index].Cells[i,j].value   and
Worksheet[index].cells.item[i,j].value

and I get an error that "Cells" is not supported.  Surely this
would be supported it's the only usefull property from vba.
I really don't want to have to use the range property.  What
could I possibly be doing wrong?

thanks!

 

Re:"Cells" Property not supported Automation Object


Try using Worksheet.cells.item[row,column].value := 'Something';
Where row and column are Integer.

Other Threads