I need some help regarding writing a file in XLS format or converting it from txt to xls format uing natural or JCL.
I am converting a SAS program which generate some report and FTP it to PC. I am using natural instead of SASand using the same FTP details.
Problem here is SAS has something called ‘ODS HTML’ thing which is used to wtire the data into xls format. Which means after FTP report is in xls format. But when using natural i could only write it into CSV format.
Does natural provide some similar function?
File from SAS
See attachment - Capture
File from natural
Header-1;Header-2;Header-3;Header-4
Data-1;Data-1;Data-1;Data-1
Data-2;Data-2;Data-2;Data-2
I don’t believe that this is possible for Natural on the mainframe; CSV format is as close as you’ll get. Natural for Windows can handle it quite easily.
I don’t know of a good way to create XLS format in Natural, but creating the spreadsheet in XML format may be an option for you. Below is a link to some more information on it. Using XML format has some limits but you can do many common things such as row/column/cell/font formatting, formulas, worksheets, filtering, etc. I’ve devloped applications that create a wide variety of Excel spreadsheets, completely within Natural, this way. It can be clunkly, but if you have to keep it entirely in Natural, it may be an option.
