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

lgetcell()                                                         READWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   To return an array of cell attributes

 Syntax
   Lgetcell( aSpreadsheet,cCell )

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

 Returns
   aCell_info      - 1 = Contents
                     2 = Cell type
                     3 = Cell length
                     4 = Cell address
                     5 = Row number
                     6 = Column number
                     7 = File offset

 Notes
   Lgetcell() returns an array with information about the specified cell
   address.  If the cell is not found, then NIL will be returned.

 Example
function Sample
    LOCAL aWks   := Lread("PAYROLL.WK1")
    LOCAL aCell
    if !empty(aWks)
       ? aCell := Lgetcell(aWks,"A1")
       ? aCell[4],aCell[1]
       ? aCell := Lgetcell(aWks,"B2")
       ? aCell[4],aCell[1]
       Lclose(aWks)
    endif
return nil

 Category
   Reading spreadsheet files