Save excel data to couchDB

Question

I am wondering if there is a tool that will save / push MS Excel (or OO calc) data into the CouchDB database. Googling didn’t help much, so I don’t think there is an existing solution for this.

Excel -> json -> Curl to CouchDB would do the trick, but I still hope there is something out there that will save my time programming this.

Answer 1

If you get the Excel data into a JSON file, as Sam Bisby suggests, you can use the tools/load.pyscript from couchdb-python to easily and quickly dump it into CouchDB without spending too much time creating your own. (Although I would not have thought it would take a long time to write my own ...)

Refuse this blog post about downloading / unzipping JSON to / from CouchDB . The implementation uses Python.

Downloading a JSON file should be as simple as:

./load.py –input=msg_db.json http://target-couchdb:5984/msg_db

Answer 2

, : "Excel → json → Curl to CouchDB". Google " Excel JSON" .

, , CouchDB , Excel . : http://wiki.apache.org/couchdb/HTTP_Document_API#Attachments

Answer 3

I wrote a small application for this purpose

https://www.npmjs.com/package/xlsx-to-couchdb