Create Excel Spreadsheet from script

[r_t_bryan]

I am attempting to run a background script to query a table, and put the results into a excel spreadsheet. I need to know if this is feasible from scripting and if so, what the best solutions would be.

Thanks in Advance,

Robert

[r_t_bryan]

Hi madanm,

Yes I managed to get it working.

I queried the 'sys_update_xml' table adding the query of the update set sys_id. I then split the name into sys_id and name and pushed them into an array of arrays. Then I converted the array into base64 encoded string, created and incident to attach it to and decoded it and attaching it to the Incident using the attachment function. Please see the relevant links below:

https://community.servicenow.com/message/772956#772956

https://community.servicenow.com/thread/216955

https://community.servicenow.com/message/1083132#1083132

Cheers,

Robert

[M_rio Rui Castr]

Hello Robert,

If you are still looking for some other alternatives, please have a look at the following article: https://community.servicenow.com/community?id=community_article&sys_id=35679790db1bcc90414eeeb5ca961...

Kind regards,

MRC