Solved MultiBot Architecture on SIngle FIle

[bharathrhegde]

Hi ,
I am implementing a multibot architecture solution where the process will do some validations and update an excel file.
I will be using the environment lock feature.
However my doubt is,how do append the updates in the excel file.

Thanks in advance

 

[NPoornima]

1. Get existing no. Of rows in Excel using MS Excel VBO, Action: Get number of rows

Output will return number, store in using data item ROW_COUNT which is of number data item

2. Use Action: Write Collection from MS Excel VBO and the input start cell should be "A"&[ROW_COUNT]+1

Note: I've assumed Excel starts with 1st column, hence used "A"

Please test and let me know if I understood your question correctly

 

[bharathrhegde]

Hi Poornima,
Thanks,I have already used this.What I was asking was how do I know when the bot will finish the update.

I found a solution : Create a txt file as bot counter,Increment and decrement accordingly which will become a reference.