Scripting with Excel Spreadsheets

Michael Zglesze
Giga Expert

Hello Community!

I have been asked to automate the following process, but I'm unsure if ServiceNow has the capability to work with Excel files in a script (like in a Scheduled JOb) as is required:

  1. Open a given Excel Macro-Enabled Workbook in which data from ServiceNow will be populated.
  2. Populate the data in the proper rows and columns.
  3. Email the Excel Macro-Enabled Workbook to a particular email address.

I checked the ServiceNow Developer's Site under Reference --> APIs --> Server Global, and I didn't see any Classes or APIs for Excel listed.

Has anyone accomplished anything like this, or have any information that could help me develop this?

Thank you!

Michael Zgleszewski