Board index » delphi » Delphi Excel and Ado

ade

Delphi Developer
Sat, 10 Jul 2004 08:42:43 GMT

Delphi Excel and Ado

Is there any way to load a xcel file and dump it into a dbgrid and also save
it back out again with or without 3rd party components,

 Any help on this would be greatly appreciated. Examples tips and tricks
would also be appreciated.

 I can dump the file out to a csv or xml file using ado but there is no way
to load an excel file or save a xcelfile data.

thanks ade...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/2002

 
Mike Shkolni

Delphi Developer
Sat, 10 Jul 2004 18:18:32 GMT

Re:Delphi Excel and Ado


Without third-party components or own code such task can't be solved.
 If you need third-party components, check my SMExport and SMImport suites.
But these suites are shareware....
--
With best regards, Mike Shkolnik
E-Mail: mshkol...@scalabium.com
        mshkol...@yahoo.com
WEB: http://www.scalabium.com

ade <adrian.tet...@ntlworld.com> D???
???Y??:xyX28.98366$_x4.10378...@news2-win.server.ntlworld.com...

Quote
> Is there any way to load a xcel file and dump it into a dbgrid and also
save
> it back out again with or without 3rd party components,

>  Any help on this would be greatly appreciated. Examples tips and tricks
> would also be appreciated.

>  I can dump the file out to a csv or xml file using ado but there is no
way
> to load an excel file or save a xcelfile data.

> thanks ade...

> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/2002

aáò?á? á??ò?

Delphi Developer
Sat, 10 Jul 2004 19:08:02 GMT

Re:Delphi Excel and Ado


My be this example
http://community.borland.com/article/1,1410,20066,00.html

Quote
"ade" <adrian.tet...@ntlworld.com> wrote in message

news:xyX28.98366$_x4.10378386@news2-win.server.ntlworld.com...
Quote
> Is there any way to load a xcel file and dump it into a dbgrid and also
save
> it back out again with or without 3rd party components,

>  Any help on this would be greatly appreciated. Examples tips and tricks
> would also be appreciated.

>  I can dump the file out to a csv or xml file using ado but there is no
way
> to load an excel file or save a xcelfile data.

> thanks ade...

> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/2002

ade

Delphi Developer
Mon, 12 Jul 2004 02:29:06 GMT

Re:Delphi Excel and Ado


thanks guys.....
Quote
"a?? ???" <ban...@kr.privat-online.net> wrote in message

news:a2jh00$1i11$1@pandora.alkar.net...

Quote
> My be this example
> http://community.borland.com/article/1,1410,20066,00.html

> "ade" <adrian.tet...@ntlworld.com> wrote in message
> news:xyX28.98366$_x4.10378386@news2-win.server.ntlworld.com...
> > Is there any way to load a xcel file and dump it into a dbgrid and also
> save
> > it back out again with or without 3rd party components,

> >  Any help on this would be greatly appreciated. Examples tips and tricks
> > would also be appreciated.

> >  I can dump the file out to a csv or xml file using ado but there is no
> way
> > to load an excel file or save a xcelfile data.

> > thanks ade...

> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database: 175 - Release Date: 11/01/2002

Other Threads

1. Bug in Delphi 7.0? ADO and Excel 2002

2. Excel - using Excel VBA to call functions stored in a Delphi COM Add-In

3. Delphi Created Excel File is ReadOnly in Excel

4. Excel 95 vs. Excel 97 with Delphi

5. Access MS Excel with ADO

6. How can I read Excel in ADO?

7. D5, ADO, and Excel

8. ADO, Excel, and Japanese Data

9. Diamond ADO vs Delphi ADO

10. Accessing Excel files using Ado-odbc.