Board index » delphi » Opening Excel document in Delphi

Opening Excel document in Delphi

Hello All
I'm trying to open a excel document and read from it into TStringGrid
I read Lou's Delphi Tip of the Day
(http://members.truepath.com/delphi/questions/qa6_createexcellfiles1.htm)
where he has a tip on how to write to a Excel document,
But I Can't figur out how to read from a Excel document using OLE
Can someone please help me?
 

Re:Opening Excel document in Delphi


Delphi 2 has an OCX component that reads Excel 5 workbooks.  Can't say about
D3 +.

    jongunn wrote in message <37443023.18391391@news>...
    Hello All
    I'm trying to open a excel document and read from it into TStringGrid
    I read Lou's Delphi Tip of the Day

(http://members.truepath.com/delphi/questions/qa6_createexcellfiles1.htm)
    where he has a tip on how to write to a Excel document,
    But I Can't figur out how to read from a Excel document using OLE
    Can someone please help me?

Re:Opening Excel document in Delphi


To use Excel as an OLE server you have to do some setting up in Excel, i.e.
paste special into your Delphi app, and then you would need to have a ole
crilent and a conversation and stuff in Delphi.  If you do have excell on the
same computer, it might be easier if you record a macro that exports the file
to a DBase  file, then open the file with delphi's table component.

Other Threads