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

[MarkikaHarris]

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
------------------------------

[AndreyKudinov]

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
------------------------------

[ChadDokmanovich]

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
------------------------------

[MarkikaHarris]

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.