You might need nothing more than a CSV file like others mentioned, so
ignore this post if you want.
I've been making scripts for years that create CSV files from various
data sources, but I soon found myself updating them on my PC by hand and
saving as XLSX so I can format the cells, add colors, fonts, etc.
Later I just said heck with that and started sending data directly to an
XLSX file with formatting by the script. It takes some learning, but is
getting easier for me and the result is a finished document with no hand
editing needed.
I use php on Linux or Windows with the PHPExcel package. All free and
pretty-well documented. If I want to do something like change a cell
color, I just google and a sample pops up. Probably other scripting
languages have similar free packages too.
On 3/23/2021 9:31 PM, Peter wrote:
Hello
I am looking for a freeware or any sample program which can covert my
mainframe file into an excel file.
Just to be clear we don't have SAS or any seperate tool to achieve this.
Is there any working solution who can point me in the right direction?
Peter
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
