|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Saving Q Reports into Excel
Im using Delphi 5 with Q Reports
Is there anyway - at runtime - a user can save a report into an excel document Thanks |
|
#2
|
||||
|
||||
|
Two options here:
1. You can simply output the data into a text file and separate the fields using a tab or comma character. Excel can read this type of file (CSV) easily. In fact, if you name it with a .csv extension, Excel will recognize it as an excel file. 2. You can actually output to an excel spreadsheet using ADO or the Excel OLE Automation model. See http://community.borland.com/articl...0,20066,00.html for an ADO example See http://www.delphifaq.com/fq/q2057.shtml and http://www.djpate.freeserve.co.uk/AutoExcl.htm for examples using OLE Automation.
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home. "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest Down with Sharon Osbourne Puzzle of the Month solved by Keath and KevinADC, superior perl programmers of the month |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Delphi Programming > Saving Q Reports into Excel |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|