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 this response was helpful, please mark it as Helpful and, if applicable, as Correct, this helps other users find accurate and useful information more easily.