dlangschied
Member
I need to save my output as a file that can be opened in Excel. I am already saving output as CSV, but the latest version of Excel manipulates the inbound data in a way that is not desirable.
We are on QAD2017EE, cloud-based, with the program running as a batch program on RHEL Linux. The file is generated and emailed to the customer. It needs to be hands off. So the problem with Excel manipulating the CSV file data has to be solved.
The problem that is occurring is that the customer part column has preceding zeros. I have always been to resolve this by wrapping the output column in "~"". This works. You can see that the column values are text, but Excel does not care and strips the zeroes.
So...that is why I am trying to convert my CSV file to an XLS file so that Excel keeps its conversion opinions to itself. LOL
Help!
We are on QAD2017EE, cloud-based, with the program running as a batch program on RHEL Linux. The file is generated and emailed to the customer. It needs to be hands off. So the problem with Excel manipulating the CSV file data has to be solved.
The problem that is occurring is that the customer part column has preceding zeros. I have always been to resolve this by wrapping the output column in "~"". This works. You can see that the column values are text, but Excel does not care and strips the zeroes.
So...that is why I am trying to convert my CSV file to an XLS file so that Excel keeps its conversion opinions to itself. LOL
Help!