How to read the data from attached Excel file and store it in a variable before submitting the catalog item

[naveen80]

Hi Everyone,

I want to read the data that is present in the Excel/CSV template which is attached by end user. I would like to store it in a variable that is present on the catalog form before the request is submitted.

Any pointers/suggestions are highly appreciated.

Thanks in advance..!!

Regards,

Naveen.

[Rafael Batistot]

Hi, it’s super works. Thank you 

[Ankur Bawiskar]

Hi,

You can use Excel parser to read the Excel file and then get the details row by row and add the variable data

GlideExcelParser - Scoped, Global

For parsing CSV file you can use CSV Parser

CSVParser

Regards
Ankur