# Reading XLS with Natural windows (SPOD)

**URL:** <https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76404>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Linux, Natural-Database-Interfaces-on-Open-Systems, Natural-on-Windows-Unix\
**Created:** [March 20, 2008, 3:48pm UTC](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76404 "2008-03-20T15:48:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alphonsstijnen](https://avatars.discourse-cdn.com/v4/letter/a/f17d59/32.png) [@alphonsstijnen](https://techcommunity.softwareag.com/u/alphonsstijnen)\
**Post date:** [March 20, 2008, 3:48pm UTC](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76404/1 "2008-03-20T15:48:46Z")

</div>

Is there a way to read Excel files with Natural for Windows (SPOD)??  
If yes, do you have a piece of example code

---

<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:** [March 20, 2008, 7:07pm UTC](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76404/2 "2008-03-20T19:07:31Z")

</div>

SPoD’s terminal emulator uses the PC files interface built into Natural.

- turn on PC - either a dynamic NATPARM parameter (PC=ON) or as a terminal command (%+)
- set up pc files as needed with the NATPARM WORK=(PC,PC,PC,) parameter
- Skeleton code:  
DEFINE WORK FILE 3 ‘PC’ TYPE ‘TRANSFER’  
DEFINE WORK FILE 1 ‘PC’ TYPE ‘TRANSFER’  
DOWNLOAD PC FILE 1 COMMAND ‘set pcfile 3 up data myfile.xls’ SYNC  
UPLOAD PC FILE 3 #STRUCT  
/\* process excel data - structure is column=field. keep it simple.  
END-WORK  
CLOSE PC FILE 3  
CLOSE PC FILE 1

---

<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:49pm UTC](https://techcommunity.softwareag.com/t/reading-xls-with-natural-windows-spod/76404/3 "2021-04-02T14:49:16Z")

</div>