DELPHI DBGRID EXPORT TO PDF
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.
|Published (Last):||26 March 2018|
|PDF File Size:||5.86 Mb|
|ePub File Size:||14.30 Mb|
|Price:||Free* [*Free Regsitration Required]|
CSV from a text file into a record structure 7.
dbgrid to CSV – delphi
The ‘try’ is in the wrong place, though. So I made it last so that Lista doesn’t leak if it does raise an error.
Otherwise it may be simpler to use the csv approach which I gave in that question. If you dont have a recordset, you have to iterate your dataset and write excel accesing cells. Mon, 23 Aug TObject ; var Stream: FieldCount – 1 do begin S: Exporting can be done this way, but you can also use tstringlist. I would write a generic procedure taking the dbgrid as a parameter and then follow the properties to retrieve header and data.
Any help will be appreciated.
The grid is a kind of “preview” and the user can choose the order in wich the fileds will be exported, by changing dlphi field’s order in the grid. As the DBGrid might have a different set of fields then the original resultset you need to access these. Okay I will go have a look at that. And if We want export an ClientDataset to Excel then what we do?
Reproduced Delphi DBGrid derived Excel method
I suggest you start using these, then if you have specific questions about code parts not working, post them here. Or directly write to file with AssignFile etc.
CSV File Access FieldCount – 1 do begin sTemp: FieldName ; end; s: Email Required, but never shown. I need to export the contents of a dbGrid to a CSV file. Next; end; finally Stream.
Rich Wernin Delphi Developer. FieldCount – 1 do begin s: That’s why I use a dbGrid