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.

Content Editor Discussions

Forum for content editors and CMS users.

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

Integrating Excel spreadsheets into SilverStripe site


Reply

2 Posts   1322 Views

Avatar
Joe Joe

7 March 2011 at 8:58am Community Member, 9 Posts

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

Avatar
ShawnMcB

3 May 2011 at 8:15am Community Member, 1 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!