Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- CLIPWKS -Spreadsheet Library - <b>lget()</b> <b>readwks.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lget()                                                             READWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   To return the contents of a cell

 Syntax
   Lget( aSpreadsheet,cCell )

 Parameters
   aSpreadsheet    - Spreadsheet handle array
   cCell           - Cell address to look for

 Returns
   xCell_contents  - NIL if cell not found

 Notes
   Lget() returns the contents of the specified cell address. The data
   type will vary depending upon the cell's contents.  If the cell
   contains the formulas @FALSE or @TRUE, a logical value will be
   returned.  If the cell is formatted as a date, then CLIPWKS will
   return a date value.  Otherwise, CLIWPKS will return either a numeric
   or character data.  If the cell is not found, NIL will be returned.

 Example
function ReadPayWk
    LOCAL aWks   := Lread("PAYROLL.WK1")
    if !empty(aWks)
       ? Lget(aWks,"A1")
       ? Lget(aWks,"B2")
       Lclose(aWks)
    endif
return nil

 Category
   Reading spreadsheet files

See Also: Ltype() lgetcell()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson