 |  |  |  |  |  |  |  |
reading excel in Delphi
Please support our Pascal and Delphi advertiser: Programming Forums - DaniWeb Sister Site
 |
•
•
Join Date: Oct 2007
Posts: 20
Reputation: 
Solved Threads: 0
Newbie Poster
I'd like to read/write xls files in Delphi. I think there's a way to do this using ADO. Can anyone provide an example or head me in the right direction. Thanks.
Please use the search button as this has already been answered many times.
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
as far as I know, for you to be able to read an excel document using delphi, you must first change your document's data type from .Xls to .Csv and open ur document like a textfile.
Totally untrue. You can read and write to excel. As I said, search the forum, there are a number of ways and code and so on within this forum
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Oct 2007
Posts: 20
Reputation:
Solved Threads: 0
Newbie Poster
Thank you Jonase. The CSV file approach, which is nicely supported by TStrngList, is one way. I was unable to discover how to use the Delphi components TExcelApplicatioin, TExcelWorkBook, etc.
Using the non-visual components of TXLSWorkbook turned out to be very straight forward. NativeExcel by NikaSoft seems to be well written and, more importantly, well documented with good samples.
Using the non-visual components of TXLSWorkbook turned out to be very straight forward. NativeExcel by NikaSoft seems to be well written and, more importantly, well documented with good samples.
Last edited by bob on whidbey; Jan 27th, 2009 at 12:09 pm.
|
Similar Threads
- Help with automatic update problem and more (Viruses, Spyware and other Nasties)
Other Threads in the Pascal and Delphi Forum
- Previous Thread: Delphi Program Help
- Next Thread: Starting to lean Pascal, got a problem and dunno how to fix it..
Views: 1687 | Replies: 5
| Thread Tools | Search this Thread |
Latest Pascal and Delphi Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Pascal and Delphi
