Excel VBO Issue when "Save As" .csv - Need Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-11-19 04:10 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-11-19 06:40 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-11-19 03:10 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-11-19 09:31 PM
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
-------------------------------------------------------------------------------------------------------------------
------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.
