How to read excel file in script?

[ChezAndrewI0898]

Use Case:

User will attach excel file on a form then a script will check the attached excel file's header if it has the correct headers or not.

[shubhamdubey]

@ChezAndrewI0898 

If you want to check the attachment is only excel file then use

allowed_extension:xlsx;

[Maik Skoddow · Accepted solution]

Hi @ChezAndrewI0898 

everything is explained in the following article: https://www.servicenow.com/community/developer-articles/parsing-the-excel-sheet-data-use-the-data-in... 

Maik