Jump to:

520 Posts in 248 Topics by 263 members

Content Editor Discussions

SilverStripe Forums » Content Editor Discussions » Integrating Excel spreadsheets into SilverStripe site

Forum for content editors and CMS users.

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

Page: 1
Go to End
Author Topic: 1309 Views
  • Joe Joe
    Avatar
    Community Member
    9 Posts

    Integrating Excel spreadsheets into SilverStripe site Link to this post

    How do I integrate Excel spreadsheets into my SilverStripe site? Thanks.

  • ShawnMcB
    Avatar
    Community Member
    1 Post

    Re: Integrating Excel spreadsheets into SilverStripe site Link to this post

    I don't think there is a good way to make an Excel spreadsheet directly viewable on the web; this may account for the lack of response.

    The closest reliable solution I'm aware of is to upload the spreadsheet into Google Docs or similar, publish it (Share > Publish to the web), and put the resulting URL in an iframe on the page. If you'd be doing this repeatedly, a new page type may serve you well; for a one-off it's simplest just to edit the HTML. The only SilverStripe-specific trick there is to make sure there's at least a space between your opening and closing iframe tags (<iframe src="http://YourDocHere"> </iframe>), so that they aren't collapsed into a single <iframe/> tag.

    If you want more control, you can save the spreadsheet in .csv format and use CSVParser: http://api.silverstripe.org/2.4/sapphire/bulkloading/CSVParser.html

    Hope this helps!

    1309 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.