Validate excel sheet in catalog item

[Sharath807]

Hi all, I need to validate the data in the excel sheet that which is attached by the user, before the user submits the request in the catalog item.

Condition:-

1. If there is no data in any of the cell   in the excel sheet that which is attached by the user, it should not submit the request and it should throw the error message that excel is in valid, even if user tries to submit the request.

2. If there is  data in all cell of    excel sheet then it should submit the request that user wants to submit.

Please help me in coding how to achieve this.

[Sandeep Rajput]

@Sharath807 You need to use GlideExcelParser https://docs.servicenow.com/bundle/washingtondc-api-reference/page/app-store/dev_portal/API_referenc... to parse excel.

Here is an article demonstrating this feature.

https://www.servicenow.com/community/developer-articles/parsing-the-excel-sheet-data-use-the-data-in...

Hope this helps.