Import data to Docly from Excel (XLSX) Last updated: 13. Jan 2023

An example on how to import data from Excel to Docly.

These functions are only available from the #/API folder and users with developer access.

Import data from Excel to Docly

Filename: #/API/Import.js

var xlsx = docly.loadExcel("Import1.xlsx");
for(var item of xlsx) {
    /* Save file if name column has value */
    if (item.Name) {
        var data = {
            "Age" : item.Age,
            "Phoneno" : item.Phoneno,
            "Email" : item.Email,
            "Country" : item.Country
        };
        docly.saveFile("Data/" + item.Name, data, "#/My schema");
    }
}

Saves all the entries in a folder with name "Data".