Jump to:

10979 Posts in 2722 Topics by 1815 members

All other Modules

SilverStripe Forums » All other Modules » Export data to Excel

Discuss all other Modules here.

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

Page: 1
Go to End
Author Topic: 2026 Views
  • JimAasheim
    Avatar
    Community Member
    12 Posts

    Export data to Excel Link to this post

    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.

  • Simkim
    Avatar
    Community Member
    9 Posts

    Re: Export data to Excel Link to this post

    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

  • UncleCheese
    Avatar
    4085 Posts

    Re: Export data to Excel Link to this post

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

  • lerni
    Avatar
    Community Member
    80 Posts

    Re: Export data to Excel Link to this post

    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

  • Simkim
    Avatar
    Community Member
    9 Posts

    Re: Export data to Excel Link to this post

    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

  • feitanx
    Avatar
    Community Member
    11 Posts

    Re: Export data to Excel Link to this post

    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

    2026 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.