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   1370 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!