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>lgetrange()</b> <b>readwks.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lgetrange()                                                        READWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   To return an array of spreadsheet cells

 Syntax
   Lgetrange( aWks,cRange )

 Parameters
   aWks      - Spreadsheet handle array
   cRange    - Range specifier or range name

 Returns
   aContents - Contents of all cells within range

 Notes
   Lgetrange() returns an array with the contents of the range.  The
   range may be either a named range, such as SALARY or a specified
   range such as A1..A15.

 Example
function OpenPayWks
   LOCAL aWks   := Lread("PAYROLL.WK1")
   LOCAL aRange := {}
   if !empty(aWks)
       ? aRange := Lgetrange(aWks,"A1..B5")
       Lclose(aWks)
   endif
return nil

 Category
   Reading spreadsheet files

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