cancel
Showing results for 
Search instead for 
Did you mean: 

From colIection I need to append data into existed excel sheet

VenkatRamana
Level 3
Can some one help me in the below scenario.   From colIection, I need to append data into (existed) excel sheet.   Any one - any idea on how to impliment the above requirement.   Thank in advance.
4 REPLIES 4

Denis__Dennehy
Level 15
There is a write collection collection action in the MS Excel VBO - have you experimented with that?

VenkatRamana
Level 3
yes - but we can't append data by using that VBO. I went through all the vbo's - have no clue.  

Denis__Dennehy
Level 15
Are you sure you cannot append data?  Write Action as a 'Cell Reference' input parameter which the description says ""The reference at which the collection should be written.""  So if you set Cell Reference to be F10 your collection will be written to the excel document from that point.

VenkatRamana
Level 3
Let me try.   thank you for quick help