Extract xls file to Json

For implementing the function, need to implement excel js library

function

/**
 * file Extract function
 * @param {Number} fileId internal ID
 * @return {Object} returnDate Json Object
 */
function extractFileToJSON(fileId) {
    try {
        let returnData = [];
        let excelFile = file.load({
            id: fileId
        });
        let workbook = XLSX.read(excelFile.getContents(), {type: 'base64'});

        let firstSheetName = workbook.SheetNames[0];
        let jsonData = XLSX.utils.sheet_to_json(workbook.Sheets[firstSheetName]);
        let stringifyData = JSON.stringify(jsonData)
        return jsonData;
    } catch (err) {
        log.error('error @ extract function',err)
    }
}

Leave a comment

Your email address will not be published. Required fields are marked *