January 10, 2011 Leave a comment
You have data in tables and spreadsheet, and want your users to be able to browse or analyze it. What better way than posting an interactive workbook…
The above Excel spreadsheet shows the WASL test scores for students in Washington State for 2009 (the data is from the Washington State – Office of Superintendent of Public Instruction).
By default, spreadsheets are displayed with no interactivity. To enable interactivity, replace &AllowInteractivity=False with &AllowInteractivity=True in the snippet that you are embedding on your page. For more information and to see all the other options, click here.
Step by step:
- Create the workbook with the data
- Create a PivotTable
- Save or upload the workbook to a public folder in http://office.live.com
- Get the embed code for that workbook
- Embed it in your web page
- Change AllowInteractivity to true