Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

All other Modules /

Discuss all other Modules here.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Export data to Excel


Go to End


6 Posts   3557 Views

Avatar
JimAasheim

Community Member, 12 Posts

21 April 2010 at 9:50pm

Edited: 21/04/2010 9:52pm

Hi,

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
Jim

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.

Avatar
Simkim

Community Member, 9 Posts

3 August 2010 at 3:22am

Hi Jim,

I would like to do something similar. I want to export the data from my ModelAdmin. Could you give me some hints about how did you do this feature? Thank you very much.

Best regards,

Mercedes

Avatar
UncleCheese

Forum Moderator, 4102 Posts

3 August 2010 at 3:58am

Isn't there a built in "export to CSV" feature?

Avatar
lerni

Community Member, 81 Posts

3 August 2010 at 4:41am

hi there

there is smtg in the svn i would like to try one day but don't know what it does or not. svn

Avatar
Simkim

Community Member, 9 Posts

3 August 2010 at 5:37am

Hi,

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.

Best regards,

Mercedes

Avatar
feitanx

Community Member, 11 Posts

26 January 2014 at 11:42pm

Edited: 26/01/2014 11:43pm

can you have a link of the Export CSV Model Admin to the page of the? I mean you put the Export CSV function to the Page