[Qt-interest] QAxObject and Excel

[Tony Rietwyk]

Hi Marius, 
 
I have only driven Excel from a Delphi application, but I assume the
principles are much the same.  The "things that you can do" with Excel COM
objects are all documented in Excel help or at msdn.microsoft.com.  I found
that getting an Excel script to do what I wanted first, then translate the
working script into C++ code, saved a lot headaches!  
 
Hope that helps, 
 
Tony
 

-----Original Message-----
Sent: Wednesday, 22 September 2010 20:49


Hi,

I'm reading and writing to Excel files using a Qt created user interface.
Everything is working as planned, but I'm having trouble finding
documentation (a reference) of what is possible to do. Most of the code I
have now comes from examples found by googling. 

As an example, consider:
QString rangeStr("A1:F1")
QAxObject *range = worksheet->querySubObject("Range(const QVariant &)",
rangeStr);

How do get documentation on the "Range(const QVariant &)" part. For
instance, I now want to do a PasteSpecial, but since I can't find an
example, I can't figure out how to do it. I have tried using dumpdoc.exe but
I'm having trouble wrapping my head around that as well. 

Any suggestions.


Thanks
Marius

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100922/03c71a7c/attachment.html