Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Can GlideExcelParser be used to update excel file?

Nisar3
Giga Guru

Using GlideExcelParser, I can read data from an excel file that is attached to a record. But what I'm interested to know is if I can use it to update the same file with some data.

 

For example, original sheet contains the following:

 

IDLabelProcessed
1Foo 
2Bar 
3Baz 

 

After reading each row, I need it updated as (depending on some logic)

IDLabelProcessed
1FooYes
2BarYes
3BazNo
1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@Nisar3 

No you cannot manipulate

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

@Nisar3 

No you cannot manipulate

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

can you suggest some approaches to update an excel file after processing each rows?

What I did was create a new csv file with the details that I need while traversing each row of the excel and attach it to the same record from where I'm reading the excel file.