Web Development

General discussion


Delphi 7 data into MS Excel

By CBDepadua ·
I am trying to write a program that takes data that is entered into Delphi and write it into an Excel spreadsheet. I'm trying to do this without buying additional utilities. Is there a way to do this using COM that doesn't require buying anything?

I'm am open to any ideas at this point.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by a.barnes In reply to Delphi 7 data into MS Exc ...

Is writing the Delphi data to file and then importing to Excel an option?

Collapse -

by CBDepadua In reply to Delphi 7 data into MS Exc ...

Yes. After some thought I've decided to keep a database of the information for historical purposes, so it would be fine to export from that into Excel. And so I have begane to modify an excel template with an ADOdataset. Is that the best solution? Or is there something better?

Collapse -

by techyrepublic In reply to Delphi 7 data into MS Exc ...

You can create a tab-delimited set of lines, copy them to the clipboard, and then paste them into Excel.

You can also drive Excel as a COM Automation Server. Search for "Delphi Excel Automation" and you will find several very detailed pages of instructions.

Also check the Delphi SUper Page and Torrys list for free components that will write XLS files (I use a very inexpensive component that does a great job).


Related Discussions

Related Forums