# Creating a XLS file using Natural **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Natural, Natural-on-Mainframes, Natural-on-Windows-Unix\ **Created:** [November 19, 2014, 4:58pm UTC](https://techcommunity.softwareag.com/t/creating-a-xls-file-using-natural/179425 "2014-11-19T16:58:14Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Puru\_Kaushik](https://avatars.discourse-cdn.com/v4/letter/p/d26b3c/32.png) [@Puru\_Kaushik](https://techcommunity.softwareag.com/u/Puru_Kaushik)\ **Post date:** [November 19, 2014, 4:58pm UTC](https://techcommunity.softwareag.com/t/creating-a-xls-file-using-natural/179425/1 "2014-11-19T16:58:14Z")
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 am using 8.2.4 version of natural Thanks, Puru ![Capture.PNG](https://global.discourse-cdn.com/techcommunity/original/2X/9/9246bd0d7587ace4914673bbdbc12821abad660f.png) ---
**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\ **Post date:** [November 19, 2014, 5:35pm UTC](https://techcommunity.softwareag.com/t/creating-a-xls-file-using-natural/179425/2 "2014-11-19T17:35:17Z")
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. ---
**Author:** ![Todd\_Beckwith](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/todd_beckwith/32/388_2.png) [@Todd\_Beckwith](https://techcommunity.softwareag.com/u/Todd_Beckwith)\ **Post date:** [November 19, 2014, 6:20pm UTC](https://techcommunity.softwareag.com/t/creating-a-xls-file-using-natural/179425/3 "2014-11-19T18:20:05Z")
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. [url][http://blogs.msdn.com/b/brian\_jones/archive/2005/06/27/433152.aspx[/url]](http://blogs.msdn.com/b/brian_jones/archive/2005/06/27/433152.aspx%5B/url%5D) ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [December 1, 2014, 3:50am UTC](https://techcommunity.softwareag.com/t/creating-a-xls-file-using-natural/179425/4 "2014-12-01T03:50:50Z")
TOOLKIT (open source) allows you to generated a program that can do TSV/CSV extract on any ADABAS file. [http://scctoolkit.altervista.org/](http://scctoolkit.altervista.org/) PS I am about to release V4.7 within the next month or so … ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:32pm UTC](https://techcommunity.softwareag.com/t/creating-a-xls-file-using-natural/179425/5 "2021-04-02T15:32:26Z")