Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to use ExcelJS in Scheduled Script

Renee-17
Tera Guru

I'm trying to create a report that is formatted into table with a couple of worsheets in an excel workbook and found a post where someone suggested using ExcelJS.

 

Being new to JavaScript and ServiceNow, I'd like to know... Is it possible to include ExcelJS in a newly created script that I'm creating via selecting "All > System Definition > Scheduled Jobs > New > Select Automatically run a script of your choosing".

 

If so, how do I make ExcelJS accessible to the new scheduled script I'm creating?

5 REPLIES 5

Rafael Batistot
Kilo Patron

Hi @Renee-17 

 

To handle excel sheets in ServiceNow, may you try via GlideExcelParserScoped

 

In this document you be able to learn how to handle with a sheet or several one 

 

https://www.servicenow.com/docs/bundle/zurich-api-reference/page/app-store/dev_portal/API_reference/...

 

If you want to load an excel in certain specific table may you try via Transform map 

 

https://www.process.st/how-to/create-a-transform-map-in-servicenow/

If you found this response helpful, please mark it as Helpful. If it fully answered your question, consider marking it as Correct. Doing so helps other users find accurate and useful information more easily.