Hello All, Could somebody can show me a short example how to export a dbgrid to a simple text file (comma separated)? I did not find any. There is already an article explaining how to export from THTMLViewer using eDocEngine. However, it tried to solve a bit more complicated. Exporting a DBGrid to excel without OLE I develop software and about 95% of my work deals with databases. I enjoied the advantages of using Microsoft Excel.

Author: Akikus Faezilkree
Country: Namibia
Language: English (Spanish)
Genre: Science
Published (Last): 15 January 2009
Pages: 441
PDF File Size: 7.85 Mb
ePub File Size: 16.83 Mb
ISBN: 324-5-78666-757-3
Downloads: 35351
Price: Free* [*Free Regsitration Required]
Uploader: Yozshuhn

FieldCount – 1 do begin s: CSV from a text file into a record structure 7.

FieldName ; end; s: Sign up or log in Sign up using Google. Agustin Seifert 1, 12 No, his code takes that into account: Okay I will go have a look at that. dbgrir

Post as a guest Name. Sergio Gonzale Delphi Developer. It is working by exporrt Tfilestream component procedure TForm2.

Thanks for the procedure! That’s why I use a dbGrid FieldCount – 1 do begin sTemp: I’m afraid I don’t undestand this point. So I made it last so that Lista doesn’t leak if it does raise an error.

I would write a generic procedure taking the dbgrid as a parameter and dbgrod follow the properties to retrieve header and data. I did this procedure and so far it works fine.

: export a TDBGrid to excel without OLE?

In order to use the variant array approach, you have to know how many rows you have in the query. CSV File Access Rich Wernin Delphi Developer. EnableControls can raise an exception since it causes the screen to delpyi, indirectly. Otherwise it may be simpler to use the csv approach which I gave in that question. No’amNewman depending on the datataypes the csv approach might give more trouble in convertions e.


Paul Scot Delphi Developer.

Other Threads

FieldName ; for I: Stack Overflow works best with JavaScript enabled. The downside of your approach is that its not reusable, IMO a better route is to have a procedure you can use to handle it. Sign up using Facebook. And if We want export an ClientDataset to Excel then what we do?

The ‘try’ is in the wrong place, though. Sun, 29 Aug There’s hits on a Google search for “delphi export dbgrid excel”.

Export contents of DBGrid to Excel or ClipBoard

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. And bummi’s right; if at all possible export the underlying dataset. As the DBGrid might have a different set of fields then the original resultset you need to access these. If you want a fast export of raw data, just export your recordset ADODataset.

Next; end; finally Stream. I need to export the contents of a dbGrid to a CSV file. FieldCount – 1 do begin S: All are very good points TObject ; var Lista: If you dont have dwlphi recordset, you have to iterate your dataset and write excel accesing cells. Sign delphk using Email and Password. Quote Sergio Gonzalez wrote: Exporting can be done this way, but you can also use tstringlist.


Any help will be appreciated. Mon, 23 Aug Do not export the DBGrid, export the dataset stackoverflow.

By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. TObject ; var Stream: I’m just curious if that’s the best way to do it Or directly write to file with AssignFile etc. Tue, 24 Aug Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated velphi of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

Alexander 3, 6 13 I too was going to give the reference that Bummi gave. I suggest you start using these, then if you have specific questions about code parts not working, post them here.