
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>
[<<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