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

Is it so tuf 
   Delphi's TCustomClientDataSet already has a savetoFile method . 
The records which I am displaying is already available in 
clientDataSet. Can 't I call a Function like SavetoFile to do the 
needful 

At present , when I am making a call to this function 
, it does generate xls file but also some unrecognizable charecters 

--- In [email protected], "Richard Le Mesurier 
(Investec Employee Benefits)" <richard.lemesurier@i...> wrote:
> The other alternative would be to use one of the COM servers in 
Delphi to
> load up a copy of Excel in the background and to use its routines.
> 
> There is a site dedicated to this that normally gets recommended... 
forget
> the name but search on "COM Delphi Deborah Pate" and I think you 
should get
> to it.
> 
> But this method requires a copy of Excel as said before.
> 
> The problem is that the internal format of a BIFF file (Excel file) 
is
> complex and not something you are going to deal with without a 3rd 
party app
> or component.
> 
> -----Original Message-----
> From: vik_ch_sin [mailto:vik_ch_sin@y...]
> Sent: 13 August 2003 13:24
> To: [email protected]
> Subject: Re: [Delphi] How to copy the content of TDBGrid into Excel 
file
> 
> 
> Thanks Richard
>     but I donot wish to use 3rd party component . 
> Can u suggest other alternative with Delphi standard Compaonents 
> 
> Vikash
> --- In [email protected], "Richard Le Mesurier 
> (Investec Employee Benefits)" <richard.lemesurier@i...> wrote:
> > There's a handy component on www.axolot.com (I think that's the 
> address,
> > else search on "axolot")
> > 
> > That's the one I've used before and its way faster than COM, and 
> doesn't
> > require Excel to be on target machine.
> > 
> > -----Original Message-----
> > From: vik_ch_sin [mailto:vik_ch_sin@y...]
> > Sent: 13 August 2003 12:08
> > To: [email protected]
> > Subject: [Delphi] How to copy the content of TDBGrid into Excel 
file
> > 
> > 
> > Hi Friends
> >  Help me out with this one . 
> > 
> > I want to copy the content of TDBGrid into Excel Sheet . 
> > I wrote the following line of code 
> > 
> > TCustomDataSet.SaveToFile(fileName.XLS) 
> > 
> > to do the same . 
> > 
> > But the XLS file generated has unsupported charecters ...
> > 
> > What is the Solution to this 
> > 
> > Thanks in Advance ...
> > eagerly waiting for ur responce 
> > 
> > Vikash
> > 
> > 
> > 
> > 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/ 
> > 
> > 
> > 
> > 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/ 
> 
> 
> 
> 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.


------------------------ 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/