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