Skip to content
Server API reference › API reference › API implementation and reference
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

GlideExcelParser - Scoped, Global

The GlideExcelParser API parses .xlsx formatted Excel files and access file data in scripts.

You can use the GlideExcelParser methods in global and scoped scripts. Use the sn_impex namespace identifier to create a GlideExcelParser object.

Parent Topic:Server API reference

GlideExcelParser - GlideExcelParser()

Creates an instance of GlideExcelParser.

The API name space identifier "sn_impex" must be used when creating a GlideExcelParser object.

NameTypeDescription
None  
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]) 
}

GlideExcelParser - close()

Close the connection to the input stream and release the document.

NameTypeDescription
None  
TypeDescription
void 

This example shows how to close the parser once all document management is complete.

// iterate over each row in the excel sheet
var attachment = new GlideSysAttachment();
var attachmentStream = attachment.getContentStream(<attachment sys id>);
var parser = new sn_impex.GlideExcelParser();
parser.parse(attachmentStream);
while (parser.next()) {
  // do something on each row
  var row = parser.getRow();
  gs.info(JSON.stringify(row));
}
parser.close(); // close the stream and release the document

GlideExcelParser - getColumnHeaders()

Returns a list of column headers from the parsed document.

NameTypeDescription
None  
TypeDescription
ArrayAn array of strings of column headers from the parsed document.

The following example shows how to parse an Excel file attachment multiple times to retrieve column headers and print values of each row for each worksheet. Results display column headers and values of three separate sheets in the Excel attachment.

var parser = new sn_impex.GlideExcelParser();

var attachment = new GlideSysAttachment();

// Use the attachment sys_id of an Excel file
var attachmentStream = attachment.getContentStream("<attachment_sys_id>");

// Set the source to be parsed
parser.setSource(attachmentStream);

// Get the worksheet names to be parsed in the Excel document
var list_sheet_name = parser.getSheetNames();

gs.info(" Sheet Names " + list_sheet_name.join(", "));

// Iterate over each worksheet in the Excel workbook
for (var i = 0; i < list_sheet_name.length; i++) {
    gs.info("**************************************************************************************");
    gs.info("Sheet name:    " + list_sheet_name[i]);

// Set the worksheet name to be parsed
    parser.setSheetName(list_sheet_name[i]);

// Parse each worksheet set using setSheetName()
    if (parser.parse()) {
        //retrieve the column headers
        var headers = parser.getColumnHeaders();
        var header1 = headers[0];
        var header2 = headers[1];
        var header3 = headers[2];

        //print headers
        gs.info(header1 + "\t||" + header2 + "\t||" + header3);

        // Iterate over each row in the worksheet
        while (parser.next()) {
            var row = parser.getRow();
            //print row value for both columns   
            gs.info(row[header1] + '\t|| ' + row[header2] + '\t||' + row[header3])
        }
    } else
        gs.info(parser.getErrorMessage());
}

Output:

*** Script:  Sheet Names Incident Table, sys_user Table, knowledge Table
*** Script: **************************************************************************************
*** Script: Sheet name:    Incident Table
*** Script: Number  ||Opened    ||Short description
*** Script: INC0010112  || 2019-07-29 11:48:43  ||Assessment :  ATF Assessor
*** Script: INC0010111  || 2019-07-22 14:04:57  ||ATF : Test1
*** Script: INC0009009  || 2018-08-30 01:06:16  ||Unable to access the shared folder.
*** Script: **************************************************************************************
*** Script: Sheet name:    sys_user Table
*** Script: User ID ||Name  ||Email
*** Script: abel.tuter  || Abel Tuter   ||abel.tuter@example.com
*** Script: abraham.lincoln || Abraham Lincoln  ||abraham.lincoln@example.com
*** Script: adela.cervantsz || Adela Cervantsz  ||adela.cervantsz@example.com
*** Script: aileen.mottern  || Aileen Mottern   ||aileen.mottern@example.com
*** Script: alejandra.prenatt   || Alejandra Prenatt    ||alejandra.prenatt@example.com
*** Script: **************************************************************************************
*** Script: Sheet name:    knowledge Table
*** Script: Number  ||Short description ||Author
*** Script: KB99999999  || Microsoft Outlook Issues ||System Administrator
*** Script: KB0000033   || Eclipse configuration for Android development    ||System Administrator
*** Script: KB0000032   || Getting Around in Windows    ||System Administrator
*** Script: KB0000031   || How can I find the MAC address of my Ethernet or
   wireless interface?  ||Sam Sorokin

GlideExcelParser - getErrorMessage()

Returns the error message when the parse() method fails.

NameTypeDescription
None  
TypeDescription
StringThe error message.

GlideExcelParser - getRow()

Get the current row values and headers.

NameTypeDescription
None  
TypeDescription
ObjectThe row headers are property names and the row values are property values.

The following example shows how to parse an Excel file attachment multiple times to retrieve column headers and print values of each row for each worksheet. Results display column headers and values of three separate sheets in the Excel attachment.

var parser = new sn_impex.GlideExcelParser();

var attachment = new GlideSysAttachment();

// Use the attachment sys_id of an Excel file
var attachmentStream = attachment.getContentStream("<attachment_sys_id>");

// Set the source to be parsed
parser.setSource(attachmentStream);

// Get the worksheet names to be parsed in the Excel document
var list_sheet_name = parser.getSheetNames();

gs.info(" Sheet Names " + list_sheet_name.join(", "));

// Iterate over each worksheet in the Excel workbook
for (var i = 0; i < list_sheet_name.length; i++) {
    gs.info("**************************************************************************************");
    gs.info("Sheet name:    " + list_sheet_name[i]);

// Set the worksheet name to be parsed
    parser.setSheetName(list_sheet_name[i]);

// Parse each worksheet set using setSheetName()
    if (parser.parse()) {
        //retrieve the column headers
        var headers = parser.getColumnHeaders();
        var header1 = headers[0];
        var header2 = headers[1];
        var header3 = headers[2];

        //print headers
        gs.info(header1 + "\t||" + header2 + "\t||" + header3);

        // Iterate over each row in the worksheet
        while (parser.next()) {
            var row = parser.getRow();
            //print row value for both columns   
            gs.info(row[header1] + '\t|| ' + row[header2] + '\t||' + row[header3])
        }
    } else
        gs.info(parser.getErrorMessage());
}

Output:

*** Script:  Sheet Names Incident Table, sys_user Table, knowledge Table
*** Script: **************************************************************************************
*** Script: Sheet name:    Incident Table
*** Script: Number  ||Opened    ||Short description
*** Script: INC0010112  || 2019-07-29 11:48:43  ||Assessment :  ATF Assessor
*** Script: INC0010111  || 2019-07-22 14:04:57  ||ATF : Test1
*** Script: INC0009009  || 2018-08-30 01:06:16  ||Unable to access the shared folder.
*** Script: **************************************************************************************
*** Script: Sheet name:    sys_user Table
*** Script: User ID ||Name  ||Email
*** Script: abel.tuter  || Abel Tuter   ||abel.tuter@example.com
*** Script: abraham.lincoln || Abraham Lincoln  ||abraham.lincoln@example.com
*** Script: adela.cervantsz || Adela Cervantsz  ||adela.cervantsz@example.com
*** Script: aileen.mottern  || Aileen Mottern   ||aileen.mottern@example.com
*** Script: alejandra.prenatt   || Alejandra Prenatt    ||alejandra.prenatt@example.com
*** Script: **************************************************************************************
*** Script: Sheet name:    knowledge Table
*** Script: Number  ||Short description ||Author
*** Script: KB99999999  || Microsoft Outlook Issues ||System Administrator
*** Script: KB0000033   || Eclipse configuration for Android development    ||System Administrator
*** Script: KB0000032   || Getting Around in Windows    ||System Administrator
*** Script: KB0000031   || How can I find the MAC address of my Ethernet or
   wireless interface?  ||Sam Sorokin

GlideExcelParser - getSheetNames()

Gets a list of all worksheet names in an Excel workbook.

NameTypeDescription
None  
TypeDescription
ArrayArray of strings as worksheet names ordered as positioned from left to right in the workbook. Results include any worksheets marked as hidden.

The following example shows how to parse an Excel file attachment multiple times to retrieve column headers and print values of each row for each worksheet. Results display column headers and values of three separate sheets in the Excel attachment.

var parser = new sn_impex.GlideExcelParser();

var attachment = new GlideSysAttachment();

// Use the attachment sys_id of an Excel file
var attachmentStream = attachment.getContentStream("<attachment_sys_id>");

// Set the source to be parsed
parser.setSource(attachmentStream);

// Get the worksheet names to be parsed in the Excel document
var list_sheet_name = parser.getSheetNames();

gs.info(" Sheet Names " + list_sheet_name.join(", "));

// Iterate over each worksheet in the Excel workbook
for (var i = 0; i < list_sheet_name.length; i++) {
    gs.info("**************************************************************************************");
    gs.info("Sheet name:    " + list_sheet_name[i]);

// Set the worksheet name to be parsed
    parser.setSheetName(list_sheet_name[i]);

// Parse each worksheet set using setSheetName()
    if (parser.parse()) {
        //retrieve the column headers
        var headers = parser.getColumnHeaders();
        var header1 = headers[0];
        var header2 = headers[1];
        var header3 = headers[2];

        //print headers
        gs.info(header1 + "\t||" + header2 + "\t||" + header3);

        // Iterate over each row in the worksheet
        while (parser.next()) {
            var row = parser.getRow();
            //print row value for both columns   
            gs.info(row[header1] + '\t|| ' + row[header2] + '\t||' + row[header3])
        }
    } else
        gs.info(parser.getErrorMessage());
}

Output:

*** Script:  Sheet Names Incident Table, sys_user Table, knowledge Table
*** Script: **************************************************************************************
*** Script: Sheet name:    Incident Table
*** Script: Number  ||Opened    ||Short description
*** Script: INC0010112  || 2019-07-29 11:48:43  ||Assessment :  ATF Assessor
*** Script: INC0010111  || 2019-07-22 14:04:57  ||ATF : Test1
*** Script: INC0009009  || 2018-08-30 01:06:16  ||Unable to access the shared folder.
*** Script: **************************************************************************************
*** Script: Sheet name:    sys_user Table
*** Script: User ID ||Name  ||Email
*** Script: abel.tuter  || Abel Tuter   ||abel.tuter@example.com
*** Script: abraham.lincoln || Abraham Lincoln  ||abraham.lincoln@example.com
*** Script: adela.cervantsz || Adela Cervantsz  ||adela.cervantsz@example.com
*** Script: aileen.mottern  || Aileen Mottern   ||aileen.mottern@example.com
*** Script: alejandra.prenatt   || Alejandra Prenatt    ||alejandra.prenatt@example.com
*** Script: **************************************************************************************
*** Script: Sheet name:    knowledge Table
*** Script: Number  ||Short description ||Author
*** Script: KB99999999  || Microsoft Outlook Issues ||System Administrator
*** Script: KB0000033   || Eclipse configuration for Android development    ||System Administrator
*** Script: KB0000032   || Getting Around in Windows    ||System Administrator
*** Script: KB0000031   || How can I find the MAC address of my Ethernet or
   wireless interface?  ||Sam Sorokin

GlideExcelParser - getTableInfo()

Gets table column types and max character length from a spreadsheet or CSV attachment.

Note: This method is restricted to scoped applications.

NameTypeDescription
None  
TypeDescription
ObjectReturns attachment data as a map in which the key is column name. Values contain column type and maximum length of a character string in the column. Access return values using the getType() and getLength() methods.

This example shows how to data from a 7-column spreadsheet attachment including row data such as 1, Meghan, 1/1/85, 1:00 AM, 10.00%, 224-432-8582, ½.

var attachmentSysId = "<sys_id>";
var headerRowNumber = 6;

var attachmentStream = new GlideSysAttachment().getContentStream(attachmentSysId);
var parser = new sn_impex.GlideExcelParser();
parser.setHeaderRowNumber(headerRowNumber);
if (!parser.parse(attachmentStream)) {
    throw "Attachment could not be parsed as an Excel Spreadsheet " + attachmentSysId;
}
var tableInfo = parser.getTableInfo();
for (var name in tableInfo) {
gs.info('Column Name : ' + name + ', Type : ' + tableInfo[name].getType() + ', Max Length : ' + tableInfo[name].getLength());
}

Output:

ProgressWorker: Attempted to get non-existent sys_progress_
worker record, inserted 81b0ca5ddb59730090c9ff9dbf9619c4
sn_appcreator: Column Name : My Number Col, Type : integer,
 Max Length : 1
sn_appcreator: Column Name : My String Col, Type : string, 
 Max Length : 650
sn_appcreator: Column Name : My Date Col, Type : glide_date,
 Max Length : 6
sn_appcreator: Column Name : My DateTime Col, Type : 
 glide_date_time, Max Length : 7
sn_appcreator: Column Name : My Percent Col, Type : decimal,
 Max Length : 6
sn_appcreator: Column Name : My Phone Col, Type : string, 
 Max Length : 12
sn_appcreator: Column Name : My Fraction Col, Type : decimal,
 Max Length : 3

GlideExcelParser - next()

Moves to the next row.

NameTypeDescription
None  
TypeDescription
BooleanReturns true if there is a next row, otherwise, returns false.

The following example shows how to parse an Excel file attachment multiple times to retrieve column headers and print values of each row for each worksheet. Results display column headers and values of three separate sheets in the Excel attachment.

var parser = new sn_impex.GlideExcelParser();

var attachment = new GlideSysAttachment();

// Use the attachment sys_id of an Excel file
var attachmentStream = attachment.getContentStream("<attachment_sys_id>");

// Set the source to be parsed
parser.setSource(attachmentStream);

// Get the worksheet names to be parsed in the Excel document
var list_sheet_name = parser.getSheetNames();

gs.info(" Sheet Names " + list_sheet_name.join(", "));

// Iterate over each worksheet in the Excel workbook
for (var i = 0; i < list_sheet_name.length; i++) {
    gs.info("**************************************************************************************");
    gs.info("Sheet name:    " + list_sheet_name[i]);

// Set the worksheet name to be parsed
    parser.setSheetName(list_sheet_name[i]);

// Parse each worksheet set using setSheetName()
    if (parser.parse()) {
        //retrieve the column headers
        var headers = parser.getColumnHeaders();
        var header1 = headers[0];
        var header2 = headers[1];
        var header3 = headers[2];

        //print headers
        gs.info(header1 + "\t||" + header2 + "\t||" + header3);

        // Iterate over each row in the worksheet
        while (parser.next()) {
            var row = parser.getRow();
            //print row value for both columns   
            gs.info(row[header1] + '\t|| ' + row[header2] + '\t||' + row[header3])
        }
    } else
        gs.info(parser.getErrorMessage());
}

Output:

*** Script:  Sheet Names Incident Table, sys_user Table, knowledge Table
*** Script: **************************************************************************************
*** Script: Sheet name:    Incident Table
*** Script: Number  ||Opened    ||Short description
*** Script: INC0010112  || 2019-07-29 11:48:43  ||Assessment :  ATF Assessor
*** Script: INC0010111  || 2019-07-22 14:04:57  ||ATF : Test1
*** Script: INC0009009  || 2018-08-30 01:06:16  ||Unable to access the shared folder.
*** Script: **************************************************************************************
*** Script: Sheet name:    sys_user Table
*** Script: User ID ||Name  ||Email
*** Script: abel.tuter  || Abel Tuter   ||abel.tuter@example.com
*** Script: abraham.lincoln || Abraham Lincoln  ||abraham.lincoln@example.com
*** Script: adela.cervantsz || Adela Cervantsz  ||adela.cervantsz@example.com
*** Script: aileen.mottern  || Aileen Mottern   ||aileen.mottern@example.com
*** Script: alejandra.prenatt   || Alejandra Prenatt    ||alejandra.prenatt@example.com
*** Script: **************************************************************************************
*** Script: Sheet name:    knowledge Table
*** Script: Number  ||Short description ||Author
*** Script: KB99999999  || Microsoft Outlook Issues ||System Administrator
*** Script: KB0000033   || Eclipse configuration for Android development    ||System Administrator
*** Script: KB0000032   || Getting Around in Windows    ||System Administrator
*** Script: KB0000031   || How can I find the MAC address of my Ethernet or
   wireless interface?  ||Sam Sorokin

GlideExcelParser - parse(InputStream inputStream)

Parses an XLSX-formatted Excel document.

NameTypeDescription
inputStreamGlideScriptableInputStreamExcel document provided as an input stream. Note: Do not set this value if using the setSource() method to parse the same source multiple times.
TypeDescription
BooleanFlag that indicates if the parse was successful.Valid values: - true: Document was successful parsed. - false: Document was not successfully parsed.

Example from a scripted REST API script where the Excel file is sent using an input stream in the request payload.

var parser = new sn_impex.GlideExcelParser();
parser.parse(request.body.dataStream);

The following example shows how to parse an Excel file attachment multiple times to retrieve column headers and print values of each row for each worksheet. Results display column headers and values of three separate sheets in the Excel attachment.

var parser = new sn_impex.GlideExcelParser();

var attachment = new GlideSysAttachment();

// Use the attachment sys_id of an Excel file
var attachmentStream = attachment.getContentStream("<attachment_sys_id>");

// Set the source to be parsed
parser.setSource(attachmentStream);

// Get the worksheet names to be parsed in the Excel document
var list_sheet_name = parser.getSheetNames();

gs.info(" Sheet Names " + list_sheet_name.join(", "));

// Iterate over each worksheet in the Excel workbook
for (var i = 0; i < list_sheet_name.length; i++) {
    gs.info("**************************************************************************************");
    gs.info("Sheet name:    " + list_sheet_name[i]);

// Set the worksheet name to be parsed
    parser.setSheetName(list_sheet_name[i]);

// Parse each worksheet set using setSheetName()
    if (parser.parse()) {
        //retrieve the column headers
        var headers = parser.getColumnHeaders();
        var header1 = headers[0];
        var header2 = headers[1];
        var header3 = headers[2];

        //print headers
        gs.info(header1 + "\t||" + header2 + "\t||" + header3);

        // Iterate over each row in the worksheet
        while (parser.next()) {
            var row = parser.getRow();
            //print row value for both columns   
            gs.info(row[header1] + '\t|| ' + row[header2] + '\t||' + row[header3])
        }
    } else
        gs.info(parser.getErrorMessage());
}

Output:

*** Script:  Sheet Names Incident Table, sys_user Table, knowledge Table
*** Script: **************************************************************************************
*** Script: Sheet name:    Incident Table
*** Script: Number  ||Opened    ||Short description
*** Script: INC0010112  || 2019-07-29 11:48:43  ||Assessment :  ATF Assessor
*** Script: INC0010111  || 2019-07-22 14:04:57  ||ATF : Test1
*** Script: INC0009009  || 2018-08-30 01:06:16  ||Unable to access the shared folder.
*** Script: **************************************************************************************
*** Script: Sheet name:    sys_user Table
*** Script: User ID ||Name  ||Email
*** Script: abel.tuter  || Abel Tuter   ||abel.tuter@example.com
*** Script: abraham.lincoln || Abraham Lincoln  ||abraham.lincoln@example.com
*** Script: adela.cervantsz || Adela Cervantsz  ||adela.cervantsz@example.com
*** Script: aileen.mottern  || Aileen Mottern   ||aileen.mottern@example.com
*** Script: alejandra.prenatt   || Alejandra Prenatt    ||alejandra.prenatt@example.com
*** Script: **************************************************************************************
*** Script: Sheet name:    knowledge Table
*** Script: Number  ||Short description ||Author
*** Script: KB99999999  || Microsoft Outlook Issues ||System Administrator
*** Script: KB0000033   || Eclipse configuration for Android development    ||System Administrator
*** Script: KB0000032   || Getting Around in Windows    ||System Administrator
*** Script: KB0000031   || How can I find the MAC address of my Ethernet or
   wireless interface?  ||Sam Sorokin

GlideExcelParser - setHeaderRowNumber(Number headerRowNumber)

Set the number of the header row to be retrieved.

NameTypeDescription
headerRowNumberNumberThe header row to be retrieved.
TypeDescription
void 

GlideExcelParser - setNullToEmpty(Boolean empty)

Return an empty value instead of null when an Excel cell is not present.

NameTypeDescription
emptyBooleanWhen true, cells that are not present return an empty value. When false, cells that are not present return null.
TypeDescription
void 

GlideExcelParser - setSheetName(String sheetName)

Set the name of the sheet to be retrieved.

If both setSheetNumber() and setSheetName() are set, setSheetName() is used.

NameTypeDescription
sheetNameStringThe name of the sheet to be retrieved.
TypeDescription
void 

The following example shows how to parse an Excel file attachment multiple times to retrieve column headers and print values of each row for each worksheet. Results display column headers and values of three separate sheets in the Excel attachment.

var parser = new sn_impex.GlideExcelParser();

var attachment = new GlideSysAttachment();

// Use the attachment sys_id of an Excel file
var attachmentStream = attachment.getContentStream("<attachment_sys_id>");

// Set the source to be parsed
parser.setSource(attachmentStream);

// Get the worksheet names to be parsed in the Excel document
var list_sheet_name = parser.getSheetNames();

gs.info(" Sheet Names " + list_sheet_name.join(", "));

// Iterate over each worksheet in the Excel workbook
for (var i = 0; i < list_sheet_name.length; i++) {
    gs.info("**************************************************************************************");
    gs.info("Sheet name:    " + list_sheet_name[i]);

// Set the worksheet name to be parsed
    parser.setSheetName(list_sheet_name[i]);

// Parse each worksheet set using setSheetName()
    if (parser.parse()) {
        //retrieve the column headers
        var headers = parser.getColumnHeaders();
        var header1 = headers[0];
        var header2 = headers[1];
        var header3 = headers[2];

        //print headers
        gs.info(header1 + "\t||" + header2 + "\t||" + header3);

        // Iterate over each row in the worksheet
        while (parser.next()) {
            var row = parser.getRow();
            //print row value for both columns   
            gs.info(row[header1] + '\t|| ' + row[header2] + '\t||' + row[header3])
        }
    } else
        gs.info(parser.getErrorMessage());
}

Output:

*** Script:  Sheet Names Incident Table, sys_user Table, knowledge Table
*** Script: **************************************************************************************
*** Script: Sheet name:    Incident Table
*** Script: Number  ||Opened    ||Short description
*** Script: INC0010112  || 2019-07-29 11:48:43  ||Assessment :  ATF Assessor
*** Script: INC0010111  || 2019-07-22 14:04:57  ||ATF : Test1
*** Script: INC0009009  || 2018-08-30 01:06:16  ||Unable to access the shared folder.
*** Script: **************************************************************************************
*** Script: Sheet name:    sys_user Table
*** Script: User ID ||Name  ||Email
*** Script: abel.tuter  || Abel Tuter   ||abel.tuter@example.com
*** Script: abraham.lincoln || Abraham Lincoln  ||abraham.lincoln@example.com
*** Script: adela.cervantsz || Adela Cervantsz  ||adela.cervantsz@example.com
*** Script: aileen.mottern  || Aileen Mottern   ||aileen.mottern@example.com
*** Script: alejandra.prenatt   || Alejandra Prenatt    ||alejandra.prenatt@example.com
*** Script: **************************************************************************************
*** Script: Sheet name:    knowledge Table
*** Script: Number  ||Short description ||Author
*** Script: KB99999999  || Microsoft Outlook Issues ||System Administrator
*** Script: KB0000033   || Eclipse configuration for Android development    ||System Administrator
*** Script: KB0000032   || Getting Around in Windows    ||System Administrator
*** Script: KB0000031   || How can I find the MAC address of my Ethernet or
   wireless interface?  ||Sam Sorokin

GlideExcelParser - setSheetNumber(Number sheetNumber)

Set the number of the Excel sheet to be retrieved.

If both setSheetNumber() and setSheetName() are set, setSheetNumber() is ignored.

NameTypeDescription
sheetNumberNumberThe Excel sheet number to retrieve.
TypeDescription
void 

The following example shows how to use this method to specify the sheet number of an attached spreadsheet workbook to be read.

var parser = new sn_impex.GlideExcelParser(); 
var attachment = new GlideSysAttachment();

// Use the sys id of an Excel file in the sys_attachment table and copy the sys_id of attachment.
var attachmentStream = attachment.getContentStream('178e0511138b6300026e32228144b04e');

// Specify the sheet Number to be read, 0 denotes sheet 1, 1 denotes sheet 2, etc.
parser.setSheetNumber("0");   

parser.parse(attachmentStream);

// retrieve the column headers (tests if on the correct sheet)
var headers = parser.getColumnHeaders();
var header1 = headers[0];
var header2 = headers[1];
var header3 = headers[2];

// print headers
gs.info('Header 1 value = ' +header1);
gs.info('Header 2 value = ' +header2);
gs.info('Header 3 value = ' +header3);

Output:

Header 1 value = sys_id
Header 2 value = email
Header 3 value = undefined

GlideExcelParser - setSource(InputStream inputStream)

Defines an input source for parsing multiple times or parsing each worksheet in an Excel file.

NameTypeDescription
inputStreamGlideScriptableInputStreamExcel document provided as an input stream.
TypeDescription
None 

The following example shows how to parse an Excel file attachment multiple times to retrieve column headers and print values of each row for each worksheet. Results display column headers and values of three separate sheets in the Excel attachment.

var parser = new sn_impex.GlideExcelParser();

var attachment = new GlideSysAttachment();

// Use the attachment sys_id of an Excel file
var attachmentStream = attachment.getContentStream("<attachment_sys_id>");

// Set the source to be parsed
parser.setSource(attachmentStream);

// Get the worksheet names to be parsed in the Excel document
var list_sheet_name = parser.getSheetNames();

gs.info(" Sheet Names " + list_sheet_name.join(", "));

// Iterate over each worksheet in the Excel workbook
for (var i = 0; i < list_sheet_name.length; i++) {
    gs.info("**************************************************************************************");
    gs.info("Sheet name:    " + list_sheet_name[i]);

// Set the worksheet name to be parsed
    parser.setSheetName(list_sheet_name[i]);

// Parse each worksheet set using setSheetName()
    if (parser.parse()) {
        //retrieve the column headers
        var headers = parser.getColumnHeaders();
        var header1 = headers[0];
        var header2 = headers[1];
        var header3 = headers[2];

        //print headers
        gs.info(header1 + "\t||" + header2 + "\t||" + header3);

        // Iterate over each row in the worksheet
        while (parser.next()) {
            var row = parser.getRow();
            //print row value for both columns   
            gs.info(row[header1] + '\t|| ' + row[header2] + '\t||' + row[header3])
        }
    } else
        gs.info(parser.getErrorMessage());
}

Output:

*** Script:  Sheet Names Incident Table, sys_user Table, knowledge Table
*** Script: **************************************************************************************
*** Script: Sheet name:    Incident Table
*** Script: Number  ||Opened    ||Short description
*** Script: INC0010112  || 2019-07-29 11:48:43  ||Assessment :  ATF Assessor
*** Script: INC0010111  || 2019-07-22 14:04:57  ||ATF : Test1
*** Script: INC0009009  || 2018-08-30 01:06:16  ||Unable to access the shared folder.
*** Script: **************************************************************************************
*** Script: Sheet name:    sys_user Table
*** Script: User ID ||Name  ||Email
*** Script: abel.tuter  || Abel Tuter   ||abel.tuter@example.com
*** Script: abraham.lincoln || Abraham Lincoln  ||abraham.lincoln@example.com
*** Script: adela.cervantsz || Adela Cervantsz  ||adela.cervantsz@example.com
*** Script: aileen.mottern  || Aileen Mottern   ||aileen.mottern@example.com
*** Script: alejandra.prenatt   || Alejandra Prenatt    ||alejandra.prenatt@example.com
*** Script: **************************************************************************************
*** Script: Sheet name:    knowledge Table
*** Script: Number  ||Short description ||Author
*** Script: KB99999999  || Microsoft Outlook Issues ||System Administrator
*** Script: KB0000033   || Eclipse configuration for Android development    ||System Administrator
*** Script: KB0000032   || Getting Around in Windows    ||System Administrator
*** Script: KB0000031   || How can I find the MAC address of my Ethernet or
   wireless interface?  ||Sam Sorokin