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)
}
}