Parse EXCEL file into JSON

[soukayna]

hello,

it is possible to parse an excel file into a json in script include .

if it s possible how we can do it.

thanks,

[Ankur Bawiskar]

Hi Soukayna,

As mentioned earlier this is not possible since csv file is as good as text file and hence it is possible to do. But for excel this is not possible.

One suggestion is to have csv file instead of xls file.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[jarodm]

GlideExcelParser() looks like it got added in Jakarta!

https://docs.servicenow.com/bundle/kingston-application-development/page/app-store/dev_portal/API_reference/GlideExcelParserScoped/concept/GlideExcelParserScopedAPI.html

This looks like it can read parse multi-page Excel docs.

JarodM

[Sanjay Bagri1]

Hi, Go through this link https://community.servicenow.com/community?id=community_question&sys_id=ea4f3e69db58dbc01dcaf3231f961962 It will help you. Please mark as correct and helpful. Thanks

[Yogish Naik1]

How to access excel file in Script include?