Re: Excel spreadsheets & Delphi


"Andreas Koch" <nospam@xxxxxxxxxxxxxxx> wrote in message news:ffhush$jgr$00$1@xxxxxxxxxxxxxxxxxxxx
Frank Stacey wrote:
I have been using Delphi 7 for several years. By using I mean writing a number of toy programs to do things that are useful to me. I would now like to write a program whose data is defined in an Excel spread*** (possibly workbook).

Is it possible to import spread*** data directly into a Delphi environment? Can anyone give me any idea where to start looking for information?

Its not clear to me what you need exactly. Do you just need to access
numbers written to an Excel spread*** from your Delphi application?
Or do you want to convert an Excel application with VBA macros and
formulas to an Delphi application?

Look for a component tab named "Server", which should have some
office related components (TExcelapplication etc)





The former. I want to get at the cells and use the data to do some caculation then put the results back into the same spread***. The caculation could be done using VBA, I am sure, but then I would suffer the delay of familiarising myself with the Excel/VBA environment. I have done a little VBA programming within Access but even less than the amount of Delphi but I am very much at home in Delphi.

I will look for the server stuff.
Thanks
Frank

.

Quantcast