ServiceNow: Convert Excel attachment to an object

ServiceNow_ExcelToObject.js

function excelToObject(attID) {
  
    if (!attID || !isValidSysId(attID)) {
        throw new Error("Valid attachment id required");
    }

    var excelObj = [];

    var attachment = new GlideSysAttachment();
    var attachmentStream = attachment.getContentStream(attID);

    var parser = new sn_impex.GlideExcelParser();
    parser.parse(attachmentStream);

    while (parser.next()) {
        excelObj.push(parser.getRow());
    }

    //return JSON.stringify(excelObj); stringify if a client callable script
  return excelObj;
}

function isValidSysId(sysid) {
 var pattern = /[a-zA-Z0-9]{32}/;
  return pattern.test(sysid);
}

Test Code.js

try {
  excelToObject('SomeRandomAttachmentSysID');
}catch (ex){
  gs.print('errrr: ' + ex.message);
}