Does anyone know how you can import data from Excel spreadsheet to the DataTable grid ?

jjonkers

Does anyone know how you can import data from Excel spreadsheet to the DataTable grid ?

allan

DataTables can consume data from three sources:

1. HTML (i.e. the DOM)
2. Javascript
3. JSON

It won't natively read Excel files - you would need to convert your document to one of those formats first. Excel has an HTML export option that you could use for example. Or you could export it as CSV and dump it into a database and then get the data from there.

Allan