Programming Excel Using Delphi

I wish to develop a Delphi application which generates financial models of private power projects in MS Excel.  Is this a practical option?  If so, how do I do it?
AndrewhAsked:
Who is Participating?
 
slautinConnect With a Mentor Commented:
You can do it via VCFormulaOne component
or via OLE Automation object.
0
 
intheCommented:
hi
for more info on programming excel,word  using ole have a look here under excel,word section

http://members.aol.com/charliecal/ArticlesAndCode.html

Regards Barry
0
 
AndrewhAuthor Commented:
Which versions of Delphi contain VCFormulaOne component
and OLE Automation object.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
intheCommented:
if you have a file called comobj.dcu you have ole support
do a file find but i should think you'll have it
as for vcfomulaone that was an ocx with delphi2 developers pack so i presume it was with 3,4 developers edition but am not sure ,it is a 3rd party component and i aint got it with 3 or 4  professional .

ps  have you had a look at the site i said above?
Regards Barry  

0
 
AndrewhAuthor Commented:
Barry,

I've looked at the site you recommended and down loaded an article which appears to answer the question.  Thanks for your help.

Regards Peter

0
 
intheCommented:
glad to be of assistance and im sure salutin's happy too he just got his first 100 points rather too easily i think :-(
Barry
0
 
slautinCommented:
I use Delphi 2.0 Client/server.

World Wide Web - http://www.visualcomp.com
Electronic Mail - sales@visualcomp.com
0
 
slautinCommented:
I have working demo for VCFormulaOne.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.