[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
Function: Create123()
The Expand library provides a set of Functions to
create basic Lotus 1-2-3 worksheet files. The
created files can be read directly into 1-2-3
version 2 and on, no need to require additional
conversion steps if your application wants to
include a direct lotus export facility. The
created worksheets just contains enough information
for 1-2-3 to load them, but additional features,
such as formulas, macros etc.. cannot be directly
entered via the Expand library (it would be
complicated anyway). Note that Expand does not
provide any functions to READ Lotus worksheets,
based on the assumption that Lotus' Trans program
would be enough help there.
Create123() creates the worksheet header, the
functions Width123() and mostly Write123() would
be used to fill the worksheet, which will then be
closed using the function close123().
Syntax: Create123(<CFile>[,<nRows>,<nCols>])
Arguments: <cFile> is the name of the worksheet one wants to
create. drive\path etc.. may be submitted. An
extension also has to be submitted by the
application and i recommend always using .WK1 as
that is the format Expand's 1-2-3 functions use.
<nRows> and <nCols> are optionnal (but should be
submitted both or none at all), they define the
Worksheet dimensions, <nRows> is the last Row
(Starting from 0!) and <nCols> is the last Column
(also from 0). Note that the Row/Column notation
follows the Clipper ordering (rows first) instead
of the 1-2-3 ordering.
Returns: A logical, .t. if the Worksheet was created
succesfully.
Usage: Create123('VERYSMAL.WK1',0,0)
Width123(0,30);
Write123(0,0,'A very small Worksheet indeed!')
Close123()
See Also:
Write123()
Width123()
Close123()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson