I'm trying to provide an export data form that creates an MS Excel workbook.
Has anyone tried creating an Excel workbook from SilverStripe?
What "Excel-Creator-Package" (PHPExcel, Excel Writer, ExcelCreator, etc.) did you use?
Thanks & Regards
P.S.: the main reason why a simple CSV export doesn't serve my requirements are newlines and a bunch of special characters that break the simple csv structure and thus cannot be decently represented in Excel.
Thank you for your answers. UncleCheese, yes, there is a CSV export feature, but I need something more complex. My ModelAdmin has several tabs, and I need to export each tab separately. With the CSV export, I didn't found how to do that, so I thought of exporting to excel files and be able to export to different tabs. Any idea if you can do something like that with the CSV export?
lerni, thank you for the link. I will also explore this possibility.