OLEAutoObject

[AlessandroV]

Hi to all, i have ported from VO:
oExcel := OLEAutoObject{"Excel.Application"}

it work until <<== ERROR

        oExcel:Caption := cFileName
        oExcel:visible := FALSE
        oWorkbooks := oExcel:Workbooks
        oWorkbook := oWorkbooks:Add() 
        
        oWorksheet := oWorkbook:Worksheets[1]    <<== ERROR
        oWorksheet:Name := "Tabella"

I got this error:
value in USUAL does not support indexed operations. The value needs to be an X# Array or implement the interface 'XSharp.IIndexedProperties'.

How is it possible to fix up and recover this code (i hope so) ? Or i have to rewrite all as C# interop ?

Thanks a lot Alessandro

[robert]

Alessandro,
There is an Excel example in the Helpfile.

Robert

[AlessandroV]

ok thanks Robert, i have to use interop ....

Alessandro

[robert]

Alessandro,
Yes, the interop DLLs are the way to go.
That will also provide you with code completion in the editor, compiler warnings for incorrect code and faster execution.
Robert