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>lrows()</b> <b>readwks.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lrows()                                                            READWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   To determine number of rows in spreadsheet

 Syntax
   Lrows( aWks )

 Parameters
   aWks      - Spreadsheet handle array

 Returns
   nRows     - Number of rows or -6 if invalid parameters

 Example
function main
    LOCAL aWks := Lread("SALES.WK1")
    if !empty(aWks)
       ? "There are "+alltrim(str(Lrows(aWks)))+" and "
       ?? alltrim(str(Lcols(aWks)))+" in this spreadsheet"
       Lclose(aWks)
    endif
return nil

 Notes
   Lrows() is primarily used to build loops to read all cells in the
   spreadsheet, although Lfindfirst() and Lfindnext() are the fastest
   methods of reading cells in sequential order.

 Category
   Reading spreadsheet files

See Also: Lcols()

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