How to read data from an attached Excel sheet and populate certain data from a sheet of that Excel to the catalog item fields on click of a custom button?

[Subhashree3]

Hi All,

We have one requirement where the user will attach an Excel sheet(having 2 sheets in one excel) attachment. We need to read the content of Sheet1 of the excel sheet and populate that on Catalog on clicking of a custom button. If anybody has come across such scenario please suggest how to achieve this in Servicenow.

Thank You.

[Deepak Ingale1]

Hi,

You can use GlideExcelParse API to read the content of the attachment

https://developer.servicenow.com/app.do#!/api_doc?v=kingston&id=GEPS-GlideExcelParser

Note: Please mark reply as correct if it has answered your question

[Gunjan Kiratkar]

Thanks, Deepak.

It helps me a lot.

[Gunjan Kiratkar]

Can you help me with how we can read .CSV file as well?

Regards,

Gunjan