How to read Excel header row server-side in ServiceNow?

[Med99]

We want to validate the header row of an uploaded Excel file server-side before processing the import, to make sure the right template was used.

GlideExcelParser is not defined in Transform Map scripts or Scripts-Background. Any other way to do this? Thanks

[Tanushree Maiti]

OOB GlideExcelParser()  can only validate excel column header.

Refer Servicenow Documentation: GlideExcelParser - Scoped, Global 

Try this code:

var parser = new sn_impex.GlideExcelParser(); 
var attachment = new GlideSysAttachment();
// use attachment sys id of an excel file
var attachmentStream = attachment.getContentStream(<attachment sys id>);

parser.parse(attachmentStream); 

//retrieve the column headers
var headers = parser.getColumnHeaders();  
var header1 = headers[0]; 
var header2 = headers[1]; 

//print headers
gs.info(header1 + " " + header2); 

while(parser.next()) { 
  var row = parser.getRow(); 
  //print row value for both columns   
  gs.info(row[header1] + ' ' + row[header2]) 
}