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

lread()                                                            READWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   To open a spreadsheet for reading

 Syntax
   Lread( cFilename,lUpdate,lDates )

 Parameters
   cFilename - Name of spreadsheet to read
   lUpdate   - Whether CLIPWKS can update the spreadsheet
   lDates    - Whether to recognize dates in Lotus 3.x

 Returns
   aWks      - Spreadsheet handle array

 Notes
   Lread() is used to open an existing spreadsheet file for read access.
   You can also specify TRUE as the second parameter, which will allow
   you to update the spreadsheet using Lreplace().  Lread() returns an
   array of information that is used by the other functions to retrieve
   data from the spreadsheet. The third parameter is used when you are
   opening Lotus 3.x spreadsheets.  Lotus 3.x does not store format
   information with the individual cells, but rather in the headers.
   CLIPWKS needs to evaluate these headers and create a bitmap to indicate
   which cells are formatted as dates.  This processing time can be
   eliminated if you know there are no dates in the spreadsheet.  Passing
   a FALSE as the third parameter controls this option.  If the spreadsheet
   is large, this option can improve peformance when opening the file.

   The Summer '87 version of CLIPWKS requires a fourth parameter which is
   a 40 element array.  CLIPWKS initializes this array and returns a logical
   value indicating whether or not the spreadsheet was opened.

 Example
function main
    LOCAL aWks := Lread("SALES.WK3",.T.,.T.)
    if !empty(aWks)
       Lget(aWks,"A2")
       Lget(aWks,"A3")
       Lclose(aWks)
    endif
return nil

 Category
   Reading spreadsheet files