topic RE: Excel VBO Issue when "Save As" .csv - Need Help in Product Forum

Excel VBO Issue when "Save As" .csv - Need Help

MarkikaHarris — Mon, 11 Nov 2019 16:10:00 GMT

Hi,
Have any of you experienced the files being corrupt when using the MS Excel VBO to save workbook as a .csv extension? If so, how did you resolve this issue?

Any suggestions are welcome.

Thanks

------------------------------
Markika Harris
Senior Associate Projects
Cognizant
America/Indiana/Indianapolis
------------------------------

RE: Excel VBO Issue when "Save As" .csv - Need Help

AndreyKudinov — Tue, 12 Nov 2019 06:40:00 GMT

If you are simply using Excel VBO Save as action, then you are not actually saving csv, you are getting xlsx files with csv extension.
To save as actual csv files, you need to modify the action/create new one and specifically pass it csv format.
If that is the case, I can post an action/code stage.

If there is something else with csv, then you need to explain what is wrong.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: Excel VBO Issue when "Save As" .csv - Need Help

ChadDokmanovich — Tue, 12 Nov 2019 15:10:00 GMT

Agreed. And to prove Andrey's point, rename your file to have an xlsx extension and then reopen it. You'll see it's not corrupted.

------Original Message------

If you are simply using Excel VBO Save as action, then you are not actually saving csv, you are getting xlsx files with csv extension.
To save as actual csv files, you need to modify the action/create new one and specifically pass it csv format.
If that is the case, I can post an action/code stage.

If there is something else with csv, then you need to explain what is wrong.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: Excel VBO Issue when "Save As" .csv - Need Help

MarkikaHarris — Tue, 12 Nov 2019 21:31:00 GMT

Yes, you are correct. We used a code stage to tell it what format it should save it in and it is working fine now. Blue Prism support said that this is a standard vbo functionality in version but in previous versions you two are correct.

Markika Harris

Senior Associate – Projects | Intelligent Automation | Cognizant Technology Solutions

Mobile: 317-992-9243 | Email: Markika.Harris@cognizant.com | http://www.Cognizant.com

-------------------------------------------------------------------------------------------------------------------

Webex Meeting Room : https://cognizantcorp.webex.com/meet/Markika.Harris

Audio Conference Dial-in: +1-844-666-8111 United States Toll Free

Access Code: 596 223 097

-------------------------------------------------------------------------------------------------------------------

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored. This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.

------Original Message------

Agreed. And to prove Andrey's point, rename your file to have an xlsx extension and then reopen it. You'll see it's not corrupted.