Import excel data into datatables

Maddy

Hi, Is there a way to import excel data into datatables? My requirement here is, I want to export datatables data into xls/csv, make bulk changes and import it back to datatables (mysql backend). Is there any plugin for this import?? Please advise. Thanks in advance.

allan

You could look at using Pivot.js - http://rjackson.github.com/pivot.js/ . But how do you want the import action to occur? Paste? Upload file? The actual solution will reflect that interaction I think.

Allan

Maddy

Thanks Allan for the input. I need file upload as import action. That data should be updated in my mysql database. I'm not sure pivot.js will do the job?? Thanks.

allan

I don't really understand I'm afraid - how does your Excel file's data get into the MySQL db? Can't DataTables just read the information from the db?

Allan

Maddy

Basically my View page reads from DB and displays on datatable. I want to export this info to csv, make changes in the csv and import the changed csv to the datatable and db. I could not succeed in achieving this on a single page. So i created one view page and one upload/download page for this.
Also, when I csv export using tabletools, the commas in the data fields are not getting exported, any inputs on this please? I tried sFieldBoundary, but didn't work. Thanks!!