Import Excel File

Import Excel File

SeppelchenSeppelchen Posts: 69Questions: 25Answers: 1

Hello,
if it is also possible to import a excel file into DataTables and maybe update values from that excel file?
I mean that I can also Update mysql data via import a excel file?

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 63,523Questions: 1Answers: 10,473 Site admin
    Answer ✓

    Certainly - use the rows.add() method to add the data from the uploaded file to the table.

    You would need to write the upload code (or use someone else's though) as this is not a feature DataTables has built in. It should be relatively straight forward using HTML5 APIs such as FileReader.

    Allan

This discussion has been closed.