How to create an excel file and attach it to the specific record in a table using workflow run script?

Yesh
Tera Contributor

Hi Team,

I am having a requirement to create an excel file and attach it to the specific record in a table. I need to store the output of the excel file that user have attached to the record and submitted that record. For that purpose, i wanted to create an excel file and store the error messages if any, or success messages if any in that excel file and attach it to the record. 

Any suggestions are helpful.

Thanks in advance.

4 REPLIES 4

Chetan Mahajan
Kilo Sage
Kilo Sage

Are you using a catalog item for submitting a request ?

 

Chetan Mahajan
Kilo Sage
Kilo Sage

Hi,

            Check this Glide method GlideExcelParser() so you can read excel data and populate on table, you can use that script in Run script 

https://developer.servicenow.com/dev.do#!/reference/api/quebec/server/GEPS-getRow

 

kindly mark correct and helpful if applicable

Hi, 

Here my main requirement is to create an excel file to store the error messages after validating the parsed excel file and attach the newly created excel file to the specific record in a table. 

Thanks

Community Alums
Not applicable

Hi @Yesh ,

Here is the thread which should help you :https://community.servicenow.com/community?id=community_question&sys_id=32935054dbb1fb08f7fca851ca96...

 

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep