cancel
Showing results for 
Search instead for 
Did you mean: 

About dynamically write collection to excel with MS Excel VBO:write collection

juiyulin1
Level 3

BP version : 7.0.1
Hello
I have a process about getting text from web as collection, and write it into excel row everyday, but it need to change to write next row every single day. For example: Today I write cell "M91toU91", tomorrow will need to write on "M92toU92", but hope can do it without insert a new row, is it possible to make it happened?
36593.png36594.pngcollection will be like following:
36595.png
36596.png

1 BEST ANSWER

Helpful Answers

@juiyulin1

There are some existing actions available in the MS Excel VBO that can help you with this.

- Go To Next Empty Cell Down
- Find Next Empty Cell
- Go To Cell
and more...

You might have to explore which action works best for you. But if you do a "Go To Cell​" to M91 and then "Go To Next Empty Cell Down", it should you to the immediate next empty cell below provided it's empty.

View answer in original post

1 REPLY 1

@juiyulin1

There are some existing actions available in the MS Excel VBO that can help you with this.

- Go To Next Empty Cell Down
- Find Next Empty Cell
- Go To Cell
and more...

You might have to explore which action works best for you. But if you do a "Go To Cell​" to M91 and then "Go To Next Empty Cell Down", it should you to the immediate next empty cell below provided it's empty.