COM implementation

[aorange]

Could anyone tell me if the Qt COM implementation changed in WinCC-OA 3.10? I am using the createComObject() function call to access data in stored in Excel files and the properties worksheet.item(1).value2 does not seem to work any longer.

I had this problem a while ago when running my script in a CTRL manager and I was told that the COM implementation of this type of manager is different to that of the UI manager. Now none of them seem to work properly for me.

Here is a snippet of what I am trying to do:

Code: Select all

idispatch xl;
idispatch xlWorkbooks;
idispatch xlWorkbook;
idispatch xlWorksheets;
idispatch xlWorksheet;
idispatch xlRange;

xl = createComObject("Excel.Application");

xlWorkbooks = xl.Workbooks;
xlWorkbook  = xlWorkbooks.Open(fileName);
xlWorksheets = xlWorkSheets.Item(1);

DebugN(xl.Range("A1").Value2 )

[leoknipp]

Hello Mr. Garcia!

Please notice that the ETM Portal does not substitute the common WinCC OA support.
Therefore please send such detailled questions to your official software contact.

The official address for companies having a valid contract with ETM is support.automation@siemens.com

For details please have a look at the ETM homepage
http://www.etm.at/index_e.asp?id=9&sb1=27

Best Regards
Leopold Knipp
Senior Support Specialist

[aorange]

Thanks Leopold, I've now sent it to the support team.

Regards

Jonathan