converts an Excel file to JSON

void importFromExcel(object config);
configobjectan object with configuration properties of an imported file


    data: file,
    callback: function(project){

Related samples


The method requires HTML5 File API support.

This method is defined in the export extension, so you need to activate the export_api plugin. Read the details in the Export/Import for Excel, Export to iCal article.

If you use the Gantt version older than 8.0, you need to include the on your page to enable the online export service, e.g.:

<script src="codebase/dhtmlxgantt.js"></script>
<script src=""></script>

The method takes as a parameter an object with configuration properties of an imported file:

  • server - sets the API endpoint for the request. Can be used with the local install of the import service. The default value is
  • data - an instance of File which should contain an Excel (xlsx) file.
  • callback - a callback function.
  • sheet - the number of the sheet of the document that should be returned by the import service.


The response will contain a JSON with an array of objects:

   { "Name": "Task Name", "Start": "2018-08-11 10:00", "Duration": 8 },


  • Values of the first row are used as property names of imported objects.
  • Each row is serialized as an individual object.
  • Date values are serialized in the "%Y-%m-%d %H:%i" format.
See also
Back to top