General discussion

  • Creator
    Topic
  • #2316429

    Delphi 7 data into MS Excel

    Locked

    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.

All Comments

  • Author
    Replies
    • #3380496

      Reply To: Delphi 7 data into MS Excel

      by abarnes70 ·

      In reply to Delphi 7 data into MS Excel

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

    • #3380450

      Reply To: Delphi 7 data into MS Excel

      by cbdepadua ·

      In reply to Delphi 7 data into MS Excel

      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?

    • #3104284

      Reply To: Delphi 7 data into MS Excel

      by techyrepublic ·

      In reply to Delphi 7 data into MS Excel

      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

Viewing 2 reply threads