How to crud (add,modify,delete,update) in excisting excel file using jquery

adhivenkateshck

How to crud (add,modify,delete,update) in excisting excel file using jquery

tangerine

Your question makes no sense in the DataTables forum. Are you talking about importing an Excel file into DataTables?

allan

DataTables itself doesn't offer an Excel import option I'm afraid. There are probably some Javascript libraries somewhere that someone will have written and give you the data as JSON or CSV, which you could then import into your DataTable.

Allan

adhivenkateshck

Hi tangerin,

i want to use excel as back end, and edit some show rows in the jquer datatables and update it into the same excel file. getting values like below

1. emp001 name:tangerix salary:62000 , desig:soft engineer
2. emp002 name:tangerib salary:70000 , desig:soft engineer
3. emp002 name:tangeric salary:92000 , desig:soft engineer

here i have to modify any one field ex:salary and update in to the same file.
(it is possible in tradition javascript )
but if we do in jquery ussing data table it is very fine
is it possible using data table.?

please think once writing a word in public ( you written no sense )

But allan has given some tips , thanks allan.

Thank you,
Adhi venkatesh.

allan

As I said, DataTables doesn't have an Excel import feature, but if you can find or write software that does that, then I don't see any reason why you couldn't display such data in DataTables.

Allan

Rob Brun

Hi adhivenkateshck, I was able to build an application for my company that used a CSV as data for Datatables using this library http://papaparse.com/ It allows you to convert CSV to JSON and back again. If you are creative you can totally do this.

Shay

adhivenkateshck

Hi Rob/shay,

Thanks for the link "http://papaparse.com" surely will try with this link.

Great!.

Than you,
Adhi