Hi

mohandoss

New Member
I want to add a column into an excel and write a newly generated order reference number in that column.
pls anyone can help me
 

Dbla

New Member
Hi Mohandoss, it's been a while since you posted but if you are still struggling with this you have different options. I'm not sure how your data is formatted or if you use collections inside BP but you could either grab the current excel data into a collection using the collection manipulation utility, then add a field, set the values into that column and then paste that collection into a new excel document using the Excel VBO; OR, you can use the Excel VBO to locate the next empty cell to the right of A1, use the set cell value action to name the column and then move the cursor down one and continue to set the values into the column with the Excel VBO.
 
Top