Click above to get retro games delivered to your door ever month!

lexport()                                                           EXPORT.PRG
------------------------------------------------------------------------------------------
 Purpose
   To export a .DBF file to a spreadsheet

 Syntax
   Lexport( cSpreadsheet, aFld_exp, aHdg_exp, cRecords, cVersion )

 Parameters
   cSpreadsheet - name of the spreadsheet to create
   aFld_exp     - array of fields to export
   aHdg_exp     - array of heading expressions
   cRecords     - which records to write to spreadsheet
   cVersion     - type of spreadsheet to produce

 Returns
   nStatus

 Notes
   Lexport() is a high-level function use to transfer records from a .DBF
   file into a spreadsheet.  A great degree of flexibility is provided,
   including control of the fields and headings, and the selection of
   records to write to the spreadsheet.

   cWksfile is the name of the spreadsheet to create and it defaults to the
   work area name with a .WK1 extension.

   aFields is either an array or a semi-colon delimited list of
   fields/functions to place in each column of the spreadsheet.

   aHeaders is a corresponding array or semi-colon delimited list of header
   strings.  Each element contains the header for the parallel entry in the
   aFields array.  If aHeaders is a logical .F., no headers will be written
   to the spreadsheet.

   cRecs is a character string indicating which records to transfer into the
   spreadsheet.

   cVersion may be

   L2  - Lotus 2.x            SY - Symphony
   L3  - Lotus 3.x            E2 - Excel 2.x
   QU  - Quattro              E3 - Excel 3.x for Windows
   QP  - Quattro Pro          E4 - Excel 4.x for Windows

 Category
   High-level functions