how do i fill out an attached excel spreadsheet

kjmauriello
Mega Expert

I need to know how i can fill out an attached excel spreadsheet in a script, ui action, etc.

A record on a custom table has an excell spreadsheet attached.  I would like to have a UI Action that takes values from the ServiceNow form and insert them into the Excel spreadsheet.

Is this possible?

1 ACCEPTED SOLUTION

kjmauriello
Mega Expert

I have resolved this issue by creating a MID Server script include to modify the excel spreadsheet

View solution in original post

9 REPLIES 9

Nitesh Balusu
Giga Guru

I don't think its possible to update an existing attachment, all you can do is create a new one, that's all.!

would i be able to retrieve the attachment, update the data in the attachment and add the updated attachment to the record.  So if the UI Action were selected multiple times there would be an additional attachment that was filled out in addition to the original "raw or source" attachment.

If so, how would i go about updating the excel spreadsheet.

Thanks for your quick response

There is a way to retrieve data from an attachment. You can modify the data after retrieving it and then create a new attachment with the modified data, that's the best you could do i guess. Please take a look at this link. 

Working with Attachment Data

Thanks for the info I will see where I get and let you know.