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>lput()</b> <b>writewks.prg</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
lput()                                                            WRITEWKS.PRG
------------------------------------------------------------------------------------------
 Purpose
   Writes data to the spreadsheet

 Syntax
   Lput( aSpreadsheet, xData, cCell_address, cFormat )

 Parameters
   aSpreadsheet   - spreadsheet handle array
   xData          - Data to write
   cCell_address  - Cell address to write data at
   cFormat        - Format byte for the cell

 Returns
   nStatus

 Notes
   The type of data determines what gets written in the cell.  Numeric
   data is written out directly, logical data is converted to either
   the @TRUE or @FALSE function, and dates are converted to the @DATE
   function.  Character data is intrepretted by the first byte.  If the
   first byte is a plus sign + or an ampersand @, then it is assume
   to be a formula and the formula will be written out.  Any other first
   character will result in the data being written directly to the
   spreadsheet.

   For example:

       Lput(aWks,"+A5*@SUM(B2..B6)","A1")
       Lput(aWks,date(),"A2")
       Lput(aWks,PAYROLL->salary,"A3")

 Category
Creating spreadsheet files

See Also: Lblank() Lfunc()

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