Upload an excel file in Change Request and Parse it to a table

[Hm10]

I have tried usng multilple ways but am unable to do this. I want the user to upload any excel file into the Change Request and immediatley the data should be parsed into a table. I am doing all through one single Business Rule ? is this right way ? Can anyone explain in detail.

1. Getting the most recent file name created by current logged in user from sys_attachment.

2. Creatig import set

3. Creating data source,

4. Creating transform map.

[Saurabh Gupta]

Hi,
This can be achieved using excel parser API.
GlideExcelParser | ServiceNow Developers

[Chetan Mahajan]

Hello @Hm10 ,

                               Please refer this video it will help you to achieve this requirement, Usage of GlideExcelParser 

Kindly mark correct and helpful if applicable  

[Hm10]

Actually I am trying to do this by data source, import set and transform map