[Lazarus] Anyone has experience controlling Excel from FPC/delphi via OLE Automation?

Werner Pamler werner.pamler at freenet.de
Wed Oct 5 11:11:29 CEST 2016

> I am having problem using the Type Library generated.
> Don't know how to use it.
> I tried to 'learn' from old Delphi 5 source code (the only version of 
> Delphi I have) that worked with Excel 2000 but found that the type 
> library are so different from the one generated by FPC.
I try to avoid that OLE stuff as much as possible - too much pain... 
What is the reason why you want to control Excel? Maybe you can achieve 
the same in a different way. If it's only reading or writing files you 
should have a look a fpspreadsheet which covers - I'd say - 90% of what 
is needed (this is not what Excel offers - Excel has always offered more 
features than were needed).

If you insist on Automation you should look at the wiki articles 
http://wiki.lazarus.freepascal.org/Office_Automation and 
http://wiki.lazarus.freepascal.org/ExcelAutomation/de - the latter is in 
German, though.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20161005/1380580d/attachment.html>

More information about the Lazarus mailing list