Code required to read the attached excel and create change request.

[GAyathri33]

Hi Team,

Urgent Requirement is that, we received an email with attachement (excel) in the below format.  Once we received the email, read the attachment and validate the reference number, start date and duration and circuits.

After read the excel attachment, Change Request should be raised in my instance.  Please check below format and help me to acheive this scenario to complete the project.  Emails are also two different formats.

1. 

2. 

Please help me .

Thanks !

[GAyathri33]

Please provide the code to read the excel attachment.

[Dr Atul G- LNG]

Hi @GAyathri33 

Sorry to say, but what you have investigated till now? Did you search on the community about same or just put the requirement and asking for updates in less than 2 mins. The code is available, but spend time to search and trouble shoot.

[Sandeep Rajput]

@GAyathri33 You need to use the GlideExcelParser API to parse excel in your instance https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/sn_impex-namespace/GlideExc....

Here is an article covering the steps to parse excel in ServiceNow https://www.servicenow.com/community/developer-articles/parsing-the-excel-sheet-data-use-the-data-in... 

Hope this helps.