Scripting with Excel Spreadsheets
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2020 10:31 AM
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:
- Open a given Excel Macro-Enabled Workbook in which data from ServiceNow will be populated.
- Populate the data in the proper rows and columns.
- 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
Labels:
- Labels:
-
Scripting and Coding