Re: How to copy the content of TDBGrid into Excel file

You could have a look at http://www.mylittlebase.org .  I was having a look
at this today because of other functionality it has, but it contains code
for writing to Excel files directly.  It's free with source, and might save
you some time in having to write your own BIFF code :-)

Best wishes,

Ian
----- Original Message ----- 
From: "Richard Le Mesurier (Investec Employee Benefits)"
<[email protected]>
To: <[email protected]>
Sent: Wednesday, August 13, 2003 1:04 PM
Subject: RE: [Delphi] How to copy the content of TDBGrid into Excel file


> I am talking about the internal format of the file. And yes, sorry to say
it
> IS so tough (bearing in mind that I normally rewrite EVERYTHING I touch -
> good luck!).
>
> Search the net for BIFF Binary Interchange File Format and see if you come
> up with anything useful. I know I have found docs on the internal format
> before - it might even have been on the Axolot site?
>
> Surely you know that the extension of the file has very little to do with
> what's actually INSIDE the file? I can write any data to a file with an
> "XLS" extension - it doesn't mean that Excel will be able to read it. Try
> renaming a EXE file with extension TXT and then open it with NotePad if
you
> don't understand the problem.
>
>
> NOTICE - This message contains privileged and confidential
> information intended only for the use of the addressee
> named above. Any review, retransmission, dissemination,
> copying, disclosure or other use of, or taking of any
> action in reliance upon, this information by person or
> entities other than the intended recipient is prohibited.
> If you have received this message in error, please notify
> the sender by return email and delete this message.
> This message should not be copied or used for any purpose
> other than intended, nor should it be disclosed to any
> other person. Any views expressed in this message are those
> of the individual sender, except where the sender specifically
>  states them to be the view of Investec Group, its
> subsidiaries or associates. The Investec Group is not
> liable for the security of information sent by e-mail at
> your request, nor for the proper and complete transmission
> of the information contained in the communication nor for
> any delay in its receipt. Please note that the recipient
> must scan this e-mail and any attached files for viruses
> and the like. The Investec Group accepts no liability of
> whatever nature for any loss, liability, damage or expense
> resulting directly or indirectly from the access of any files
> which are attached to this message.
>
>
> CodeCoffer - new Delphi code protection Tool!
> http://www.delphicollection.com/public/CodeCoffer.htm
> ---------------------------------------------------------------
> Unsubscribe:[email protected]
> List owner:[email protected]
> --------------------------------------------------------------- 
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/i7folB/TM
---------------------------------------------------------------------~->

CodeCoffer - new Delphi code protection Tool!
http://www.delphicollection.com/public/CodeCoffer.htm
---------------------------------------------------------------
Unsubscribe:[email protected]
List owner:[email protected]
--------------------------------------------------------------- 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/