# uploading excel spreadsheets onto a natural program

**URL:** <https://techcommunity.softwareag.com/t/uploading-excel-spreadsheets-onto-a-natural-program/75193>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [August 9, 2007, 6:45pm UTC](https://techcommunity.softwareag.com/t/uploading-excel-spreadsheets-onto-a-natural-program/75193 "2007-08-09T18:45:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dtown2007](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@Dtown2007](https://techcommunity.softwareag.com/u/Dtown2007)\
**Post date:** [August 9, 2007, 6:45pm UTC](https://techcommunity.softwareag.com/t/uploading-excel-spreadsheets-onto-a-natural-program/75193/1 "2007-08-09T18:45:12Z")

</div>

How do I upload excel spreadsheets onto a natural program?

---

<div class="post-metadata">

**Author:** ![Steve\_Robinson](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/steve_robinson/32/107_2.png) [@Steve\_Robinson](https://techcommunity.softwareag.com/u/Steve_Robinson)\
**Post date:** [August 10, 2007, 12:49am UTC](https://techcommunity.softwareag.com/t/uploading-excel-spreadsheets-onto-a-natural-program/75193/2 "2007-08-10T00:49:35Z")

</div>

From within Excel, generate a tab (or comma) delimited file. Then, if you are on PC Natural, just define the file as a workfile and read the data in. Use SEPARATE to parse the fields.

If on the mainframe, ftp the file from PC to mainframe and follow procedure as if on a PC.

steve

---

<div class="post-metadata">

**Author:** ![Weihnachtsbar](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/weihnachtsbar/32/146_2.png) [@Weihnachtsbar](https://techcommunity.softwareag.com/u/Weihnachtsbar)\
**Post date:** [August 10, 2007, 11:29am UTC](https://techcommunity.softwareag.com/t/uploading-excel-spreadsheets-onto-a-natural-program/75193/3 "2007-08-10T11:29:59Z")

</div>

Starting with Natural 62 on the PC/UNIX you can define your work file of type CVS:

> [@](#):
>
> Comma-separated values. Each record is written to one line in the file. By default, a header is not written. The default character which is used to separate the data fields is a semicolon (“;”).
> 
> For further information, see Work Files in the Configuration Utility documentation.

… works fine even if the column value includes line breakes, or if the  
column value contains semicolons.  
… but you have to know the maximum number of columns.

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [August 10, 2007, 4:49pm UTC](https://techcommunity.softwareag.com/t/uploading-excel-spreadsheets-onto-a-natural-program/75193/4 "2007-08-10T16:49:26Z")

</div>

If you have EntireX Communicator, you can use an ActiveX wrapper to read/write Excel data from macros via Natural RPC calls.

---

<div class="post-metadata">

**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, 2:48pm UTC](https://techcommunity.softwareag.com/t/uploading-excel-spreadsheets-onto-a-natural-program/75193/5 "2021-04-02T14:48:38Z")

</div>