: export a TDBGrid to excel without OLE?Īny help will be appreciated. I too was going to give the reference that Bummi gave. I need to export the contents of a dbGrid to a CSV file. Or directly write to file with AssignFile etc. Reproduced Delphi DBGrid derived Excel methodīy using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Sergio Gonzale Delphi Developer.įieldName end s: And if We want export an ClientDataset to Excel then what we do? Sign up or log in Sign up using Google. So I made it last so that Lista doesn’t leak if it does raise an error. The grid is a kind of “preview” and the user can choose the order in wich the fileds will be exported, by changing the field’s order in the grid. In order to use the variant array approach, you have to know how many rows you have in the query. No, his code takes that into account: That’s why I use a dbGrid Tue, 24 Aug I’m afraid I don’t undestand this point.įieldName for I: FieldCount – 1 do begin sTemp: I suggest you start using these, then if you have specific questions about code parts not working, post them here. I did this procedure and so far it works fine. I enjoied the advantages of using Microsoft Excel. Exporting a DBGrid to excel without OLE I develop software and about 95% of my work deals with databases. However, it tried to solve a bit more complicated. There is already an article explaining how to export from THTMLViewer using eDocEngine.

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.

Delphi dbgrid export to pdf