Re:Excel and CSV Conversion to JSON and XML in JavaScript
by lemonade on Wednesday September 25, 2013 @12:11PM
(#6445419)
I think it would be fairly easy to whip up something like this with WebODF (http://webodf.org). That is able to show real spreadsheet documents from software like Excel, LibreOffice, Apache OpenOffice and Calligra. Of course that works if you move away from the binary formats and choose OpenDocument Format - but this is default in most (and at least in Europe also one of the defaults of the latest two versions of Microsoft Office).
Re:Excel and CSV Conversion to JSON and XML in JavaScript
by rich_harris on Wednesday September 25, 2013 @11:15AM
(#6445074)
To be fair, the article acknowledges as much:
> The solution I've employed involved discovering and forking of a kick ass data conversion tool called Mr. Data Converter, and quickly the tool retrofitted with some of my own enhancements:
> * HTML5 File API - Allows me to acces file content without server side technology.
> * oAuth.io - Dead simple, client side oAuth for Github and other platforms.
> * Github.js - A JavaScript API wrapper for Github, enabling client-side interaction.
http://niggler.github.com/js-xlsx/ and http://niggler.github.com/js-xls/ seem to be pure in-browser parsers for Excel, whereas the Mr Data Converter solution is just parsing data coming out of the clipboard
> The solution I've employed involved discovering and forking of a kick ass data conversion tool called Mr. Data Converter, and quickly the tool retrofitted with some of my own enhancements:
> * HTML5 File API - Allows me to acces file content without server side technology. > * oAuth.io - Dead simple, client side oAuth for Github and other platforms. > * Github.js - A JavaScript API wrapper for Github, enabling client-side interaction.