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