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 only requires three function calls to create any spreadsheet. http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
CLIPWKS only requires three function calls to create any spreadsheet.
First is Lcreate() which creates a disk file and returns an array of
information used by the other CLIWPKS functions.  The second function,
Lput() expects the array from Lcreate() and can be used to write any
kind of data into the file.  The final function, Lclose(), takes the
array as the parameter and closes the actual file.  Once Lclose() is
called, you should have a spreadsheet file on your disk.

The following template code can be used to create any spreadsheets:

#define  SPREADSHEET_VERSION       "L2"
procedure main
   LOCAL aWks := Lcreate( cFile, SPREADSHEET_VERSION )

   if !empty(aWks)
      Lalign(aWks,"L")                // Set cells to Left-justified
      Lwidth(aWks,,12)                // Set global width to 12
      Lwidth(aWks,"A",20)             // Column A to 20 characters
      Lwidth(aWks,"B",20)             // Column B to 15 characters

      Lput(aWks,"GrumpFish","A1")     // Character data into cell A1
      Lput(aWks,195.00,"A2",",1")     // Numeric data into cell A2, formatted
                                      // with commas and 1 decimal point
      Lclose(aWks)
   else
      Alert("Error opening the spreadsheet...")
   endif

return

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