I automated another program that outputs reports in Excel format - however, the Excel format it saves the files as is older. I have Blue Prism interact with the program and save it to an Azure share - the Excel files are then imported by another system process. The other system process is using some Python libraries and is having problems with the Excel files. I think it is unicode related, but someone else has been working on that part of the process.
The program I automated has no option to pick which version of Excel it outputs the files as. I just know it is not the latest version of Excel from Office 365. I also do not have other output options that are going to work.
If I use Excel from Office 365 to open the output files, then save a copy - it converts to the new format. The problem I am trying to describe goes away.
An obvious solution would be to have Blue Prism launch new Excel, open files, save files.
However, can anyone think of another solution? The system running Blue Prism does not have Office 365. I can probably get this installed - but we sometimes run into headaches with our license terms. Just checking if there is a VB script or something similar that I could use.
The program I automated has no option to pick which version of Excel it outputs the files as. I just know it is not the latest version of Excel from Office 365. I also do not have other output options that are going to work.
If I use Excel from Office 365 to open the output files, then save a copy - it converts to the new format. The problem I am trying to describe goes away.
An obvious solution would be to have Blue Prism launch new Excel, open files, save files.
However, can anyone think of another solution? The system running Blue Prism does not have Office 365. I can probably get this installed - but we sometimes run into headaches with our license terms. Just checking if there is a VB script or something similar that I could use.