Hello,
This could be easy and simple to most of you and need help. I have an existing csv file with one worksheet. I want to add another worksheet with just one row but it ended up overwriting the existing worksheet. Below is what I did:
1) define new collection and add fields --> named "Payinfo"
2) use MS Excel VBO - Open Workbook
3) use MS Excel VBO - Create Worksheet --> to create another sheet named "Payment_info"
4) use calculation to assign value and Store in the collection field example: Payinfo.PaymentID
5) use calculation stage to assign value to CelRef example: "A"&[ctr] note that ctr equals to 1
6) use MS Excel VBO - Write Collection

7) use MS Excel VBO - Close Workbook
😎 use MS Excel VBO - Close Instance
After the Close instance stage , the Payment_info worksheet overwrite the existing worksheet. I need both worksheet (the current and new one) . Am I missing something? please help me why is it overwriting the existing worksheet?
Appreciate it.
------------------------------
Marilyn Gagarin
Senior Programmer/Analyst
United Rental, Inc.
America/New_York
------------------------------