Anyone have a good component for creating Excel spreadsheets? I am needing to make some of our reports export to Excel nicer than Quick Reports or Fast Reports do.
Try http://www.kluug.net/xlsx-ods-delphi.php they have a component for import/export of xls, xlsx, ods, csv for delphi/lazarus. The free version has limitations, I wasn't aware of them.
+1 for DevExpress. My users create "spreadsheets" using QuantumGrids and then export to Excel. The end-user can massively customize the grid (filter, group, hide/reorder columns) and then export the whole works. WYSIWYG! It is way better than a hard-coded report.
FlexCell from TMS. I've tried many and it's the best (don't use NativeExcel - not updated)
ReplyDeleteFlexcell has my vote as well:
ReplyDeletehttp://www.tmssoftware.com/site/flexcel.asp
Sounds great! Is the documentation on it any good?
ReplyDeleteAdam Martin
ReplyDeletere: Is the documentation on it any good?
It's online, you decide:
http://www.tmssoftware.com/flexcel/doc/index.html
Try http://www.kluug.net/xlsx-ods-delphi.php they have a component for import/export of xls, xlsx, ods, csv for delphi/lazarus. The free version has limitations, I wasn't aware of them.
ReplyDeleteRobert Lawrence
ReplyDeleteThanks for the link! I went looking, but for some reason it was eluding me.
Devexpress spreadsheet works fine as well.
ReplyDeletehttps://www.devexpress.com/Products/VCL/ExSpreadSheet/
+1 for DevExpress - but we use the normal cxGrid, apply all the styling there and use the export to Excel feature - quite powerful tool set
ReplyDeleteNot a component but the MS Jet db engine can read/write Excel like it's a database. It's a little clumsy but it does the job.
ReplyDeleteYou don't need any component. You can just automate Excel from your Delphi application. You can programmatically do everything you can do by hand. Have a look at http://francois-piette.blogspot.be/2013/01/automate-microsoft-office-from-delphi.html
ReplyDeleteLook at Axolot Data
ReplyDeleteXLS ReadWrite
http://www.axolot.com/components/xlsrwii20.htm
I use this component since Delphi 7
XLSSpreedSheet
http://www.axolot.com/components/xlsspreadsheet.htm
+1 for DevExpress. My users create "spreadsheets" using QuantumGrids and then export to Excel. The end-user can massively customize the grid (filter, group, hide/reorder columns) and then export the whole works. WYSIWYG! It is way better than a hard-coded report.
ReplyDeleteWow! Lots of responses! Thank you all, I will look at the suggestions!
ReplyDelete