From colIection IÂ need to append data into existed excel sheet
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-01-18 07:03 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-01-18 10:54 PM
There is a write collection collection action in the MS Excel VBO - have you experimented with that?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-01-18 03:30 PM
yes - but we can't append data by using that VBO.
I went through all the vbo's - have no clue.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-01-18 04:30 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-01-18 04:55 PM
Let me try.
thank you for quick help
