[<<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