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.

Content Editor Discussions /

Forum for content editors and CMS users.

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

Integrating Excel spreadsheets into SilverStripe site


Go to End


2 Posts   2834 Views

Avatar
Joe Joe

Community Member, 9 Posts

7 March 2011 at 8:58am

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

Avatar
ShawnMcB

Community Member, 1 Post

3 May 2011 at 8:15am

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!