How to validate excel before loading in service portal

[Vijay kumar S]

Hi All,

Can we validate the excel data before loading the data and creating records in service portal ?

thank you,

Vijay kumar S

[Ankur Bawiskar]

@Vijay kumar S 

where will the user add file? is it catalog form?

If yes then you can have attachment type variable and then validate the file

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ct111]

Check the below link for reference

LINK

The code is written on service side , so if you are doing something with widget you can put the piece on server side of the widget.

However, still you would have to code a bit but look at it for reference and see it assist with your objective or not.

Just for info

GlideExcelParser is api that generally deals with excel stuff in servicenow 

I hope this information helps.

[Ankur Bawiskar]

@Vijay kumar S 

check this link if it helps where I shared solution for something similar

validate the excel parser in catalog item 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Vijay kumar S 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.