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.