uploading excel spreadsheets onto a natural program

How do I upload excel spreadsheets onto a natural program?

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.


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

… 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.

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