[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
  Function:    Write123()

               Once the worksheet opened with Create123(), one
               can start writing data to it using this function.
               Expand evaluates the expression submitted and
               according to the result, be it a Char, Memo, Num,
               Date or Logical, decides what type of cell to
               create (possible thanks to the very open type of
               evaluation Clipper supports). There is thus no
               need to use different functions for different
               data-items to write to the worksheet, which makes
               creating a worksheet very simple.

  Syntax:      Write123(Row,Col,Val[,dec])

  Arguments:   <Row> is the Row where the cell has to be placed,
               <Col> the column, both start at 0. It is
               recommended to fill the spreadsheet Columns from
               left to right, then Rows from up to down (ie.
               first 0,0; 0,1; 0,2 .. 0,n, then 1,0; 1,1 etc..)

               <Val> can evaluate to any type, and according to
               that type a cell is created:

                    Char or Memo : A standard label cell. Any
                    string larger than 240 chars is truncated.

                    Num : If the number fits in an integer cell,
                    an integer cell is created, otherwise a real
                    cell is used. If the optionnal <Dec>
                    parameter is supplied (which thus only has
                    effect when <Val> evaluated to Num, ignored
                    otherwise), the cell is formatted as having
                    <Dec> decimals, otherwise it is formatted for
                    default number of decimals.

                    Date : The date is converted to a number
                    representing that Date in Lotus. The cell is
                    also formatted as being a Date in
                    international format, so that it is visible
                    and treated as a date in 1-2-3.

                    Logical : A logical variable is written as an
                    integer cell with value 1 for .t. and 0 for
                    .f..

  Returns:     Nothing.

  Usage:       * - Supposing the Worksheet file open...
               Write123(0,0,'A Label')
               Write123(1,0,12.5,2)
               Write123(2,0,.f.)
               Write123(3,0,7868789)
               Write123(4,0,Date())

See Also: Create123() Width123() Close123()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson