uploading excel spreadsheets onto a natural program

[Dtown2007]

How do I upload excel spreadsheets onto a natural program?

[Steve_Robinson]

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

[Weihnachtsbar (Weihnachtsbär)]

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.

[Douglas_Kelly]

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