Check the updated article on: ExcellentExport.js update
Raise the hand those who never have been asked to add an Export to Excel on any application. For clients, it seems that all your work is just nothing if this omnipresent feature is not there (with the little icon obviously).
As Microsoft introduced the Office Open XML (OOXML) format with Microsoft Office 2007 it became the default format of Microsoft Excel. Those files are just a bunch of XML files inside a ZIP archive. Note: Do not confuse OOXML with OpenDocument from OpenOffice.org.
The data URI provides a way to include data in-line in web pages as if they were external resources. The syntax on the href is:
Check this sample link that includes an image is embedded on the href encoded with Base64 as data:image/jpeg;base64,
So cool right? :)
Let’s make the export to Excel from an HTML table. The Excel 2007 file can be created on the fly. Here is the table:
<table id="datatable"> <tr> <td>100</td> <td>200</td> <td>300</td> </tr> <tr> <td>400</td> <td>500</td> <td>600</td> </tr> </table>
<script src="excellentexport.js"> <a download="somedata.xls" href="#" onclick="return ExcellentExport.excel(this, 'datatable', 'Sheet Name Here');"> Export table to Excel</a>
The data URL scheme gives endless possibilities to create files from the browser: images, ZIP files, CSV data, …
I’ll be completing the functionality of ExcellentExport.js library to add more features. Actually I just tested it on Firefox 25.0 and Chrome 31.0.
Check on github or this blog for updates.