Split into worksheets

[Bala Shunmugam]

please refer screenshot. I have captured a webtable to collection. I need to write them to an excel.. But before i write them to an excel, i need to seperate the rows based on the currencies into different worksheets. Can u give me an idea of how to proceed with this?

 

[Bala Shunmugam]

Anyone?

 

[sivagelli]

Can you put a screenshot of the desired format you are looking for?

 

[Bala Shunmugam]

I have attached the given data and expected output.. Please refer them

 

[Shweta]

Hi Bala,

Do follow the below steps and post back, if you still face any issues.

1. Open WB > Show > Maximize
2. Get your Data in Collection using inbuilt utility MS Excel VBO
3. Create new worksheets for each currency, say Worksheet1_INR , Worksheet2_USD
4. Filter your collection on the basis of currency as (you can replace INR with your input current codes):
"[Currency] LIKE '*INR*'"
Store the result in new collection
5. Before pasting the new collection in Worksheet, better to check if that contains any rows or not.
6. Activate the Worksheet and paste the new collection there.

You can perform the same steps for rest of the currency codes.

Thanks.