Web Development

Ask something
Discussion Locked

Delphi 7 data into MS Excel

0 helpful
3 replies

by cbdepadua

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by cbdepadua

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?

by techyrepublic

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).

Cheers

This discussion is closed to new replies.