Reading XLS with Natural windows (SPOD)

, , , ,
1

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

2

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