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 - clipwks provides two methods for reading cell from a spreadsheet. the http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
CLIPWKS provides two methods for reading cell from a spreadsheet.  The
first is LfindFirst() and LfindNext() which sequentially reads every
cell from the spreadsheet.  This is the fastest method CLIPWKS offers for
reading a spreadsheet.

The code below shows a function that will read all the cells in the file
and display the cell address and its contents.

procedure main(cFile)
  LOCAL aWks   := Lread( cFile )
  LOCAL aCell
  if !empty(aWks)
     aCell := LfindFirst(aWks)
     while !empty(aCell)
        ? padr(aCell[4],8)," ",aCell[1]
        aCell := LfindNext(aWks)
     enddo
     Lclose(aWks)
  else
     Alert("Error occurred opening the spreadsheet...")
  endif
return

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