\OVERVIEW
\ACCEPT
\ACCEPT_1

                      ┌─────────────────────┐
                      │ Tab123 Professional │
                      └─────────────────────┘

    TabPro pastes Lotus 123, Symphony and Excel Worksheet data into
    AutoCAD drawings as either text entities or an AutoCAD block. TabPro
    reads Lotus 123 files through  release 4, and also Microsoft Excel
    XLS files through Excel version 4.0 (BIFF level 4).

    ■   TabPro imports the data values and formatting; column width,
        cell alignment, and numeric formatting.

    ■   TabPro reads the worksheet files in their native format, there
        is NO need to export to an ASCII file.

    ■   TabPro provides the user full control of scale and spacing
        parameters, layer settings, text style, as well as grid and
        border weight and linetypes.

    ■   TabPro can create a link to the source file and range where
        changes in the spreadsheet can automatically update the table
        in AutoCAD.

    ■   TabPro includes an API to provide AutoLISP and ADS programmers
        access to spreadsheet data, and to create tables under program
        control.

\ABOUT

                   Tab123 Professional

                   Mountain Software
                   1579 Nottingham Road
                   Charleston, WV  25314

                   Phone           304-346-9585
                   FAX             304-744-1785
                   Compuserve      70717,3564
                   Internet        70717.3564@compuserve.com

\FILENAME

    ■ Filename

    Enter the filename of a Lotus 123 or Excel file, or select the
    File Button to invoke the file dialog box. Tab123 supports Lotus
    123 and Symphony formats thru release 4 as well as all versions
    of Excel XLS files.

\RANGE

    ■ Range

    Enter the range to import or select the Range button to pick a
    Names range from the worksheet file. The range must be in the form
    <sheet>:<column><row>..<sheet>:<column><row>. The <sheet> specifier
    is only necessary if you wish to extract data from a sheet other
    that sheet "A" in a Lotus 123 WK3 file.

    Examples:

    A1..E25             column A row 1 to column E row 25
    B:C11..B:G34        sheet B column A row 1 to column E row 25
    *                   all cells (a blank range also selects all)
    MY_RANGE            named range

\TEXT_LAYER

    ■ Text Layer

    Select the AutoCAD layer on which to place text entities or select
    the Layers button to invoke the AutoCAD "DDLMODES" dialog box where
    you can create a new layer or modify layer settings. If you make
    a diffrent layer current while in the DDLMODES dialog, that layer
    then becomes the text layer.

\STYLE

    ■   Style Creation Dialogue

    Select a text style to create either from the pick list or the icon
    menu. You may page through the styles by selecting the <Next> and
    <Previous> buttons. Once a style is selected the style parameters
    must be specified to completely define the text style. Any existing
    text style of the same name will be overwritten.

    >   Height:             Text height in drawing units
    >   Width Factor:       Width multiplier
    >   Obliquing Angle:    Text slant angle
    >   Backwards:          Mirror text in X plane
    >   Upside down         Mirror text in Y plane
    >   Vertical            Draw text vertical

\TEXT_STYLE

    ■ Text Style

    Select the AutoCAD text style (font) to use for text entities,
    or select the Styles button to create a new text style.

\TEXT_HEIGHT

    ■ Text Height

    Enter the text height in drawing units. The default value is taken
    from the current style if the style contains a text height, or from
    the AutoCAD system variable TEXTSIZE. The entire table is scaled
    based in this value.

\ROW_SCALE

    ■ Row Scale Factor

    The row scale factor defines the spacing between rows in terms
    of the text height. This factor is multiplied by the text height
    to determine the row spacing. A value of 1.0 is will allow
    adjacent text rows to just touch bottom to top. The default value
    is 2.0.

\COLUMN_OFFSET

    ■ Column Offset Factor

    The column offset factor defines the horizontal spacing (in
    characters) between the start or end of the text and the cell
    boundry. The default value is 1.00.

\GRID

    ■ Grid

    Select the grid button to select grid linetype and border line
    weight. You can also adjust the density of linetypes using
    AutoCAD's LTSCALE system variable.

    ■ Grid Layer

    Select the AutoCAD layer on which to place grid line entities, or
    select the Layers button to invoke the AutoCAD "DDLMODES" dialog
    box where you can create a new layer or modify layer settings.

\DDSTYLE

    ■ DDSTYLE Command

    TabPro adds the DDSTYLE command. This command provides a style
    creation dialog box interface to duplicate the STYLE command.
    See help index item "STYLE".

\API

   ■ TabPro API

    The TabPro Applications Program Interface creates two functions
    for use by AutoLISP and ADS programmers.

    (C:TABPRO <file> <range> <point>)

    Use: a dual use function that either creates a table from a
         spreadsheet file and range, or returns the spreadsheet data
         as an AutoLISP list.

    Parameters:
    file  <str>   the worksheet filename (eg C:\EXCEL\TABLE.XLS)
    range <str>   the named range or range specification (eg A1..D10)
    point <point> the insertion point for the upper left corner if the
                  table if the point paramter is not present the data
                  will be returned in the form of an AutoLISP list in
                  row / column order of dotted pairs. Each dotted pair
                  will contain the cell address and formatted cell
                  contents.

    Example:
    (("A1" . "Planes") ("B2" . "Boats") ("A2" . "123") ("B2" . "23"))

    (C:TABPRO_UPDATE <mode>)

    Use: Updates table links to external spradsheet files using the
         file, range, and other parameters contained in the block's
         attributes. This function is used to automatically update
         tables when a drawing is loaded. You can place the function
         in the  file ACAD.LSP file within the S::STARTUP function
         to execute after a drawing loads. ACAD.LSP might contain
         the following:

    (xload "TABPRO")         ; load TabPro
    (defun S::STARTUP()
      (C:TABPRO_UPDATE)
    )

    Parameters:
    mode <int> - 0 or nil conditional update, if the spreadsheet
                          file has changed then the table will be
                          updated.
                 1        update all tables unconditionally

\TABLE_MODE

	■  Table Mode

    You may create a table in either of two different forms.

	Text and Lines

    The table will be created using LINEs for the grid, a POLYLINE
    for the border, and TEXT entities in each cell. This format
    provides for adjustments of the table layout using the commands
    STRETCH, MOVE, etc. Cell contents can be edited using the DDEDIT
    command.

	Block and Attributes

    An anonomous block and a block insert entity with attributes is
    created in the drawing. Each cell is a visible attribute within
    the block insert, and table specifications are
    saved as invisable attributes. The cell data and table specs
    can be edited using the command DDATTE If the spreadsheet range
    or any of the other specs are changed, then the new specs will
    apply when the table is updated from disk. Any changes to the
    cell values will be lost when the table is updated.

    Tables created in block mode can be automatically updated from
    the spreadsheet when the drawing is opened by adding the
    C:TABPRO_UPDATE function to the S::STARTUP function in your
    ACAD.LSP file. They can also be updated by clicking the
    "Update" button.

\UPDATE

	■ Table Update

    The table update button updates all block mode tables in the
    drawing. Block mode tables are linked to the spreadsheet file
    and range with invisible attributes. You can also use the command
    TABPRO_UPDATE or the function (C:TABPRO_UPDATE) to update tables.

\COMMANDS

    ■ Commands defined by TabPro

    TABPRO          - Displays the TabPro Dialogue

    TABPRO11        - Runs TabPro in command line mode.

    TABPRO_UPDATE   - Conditionally updates block mode tables

    TABPRO_PASSWORD - Register TabPro with your name and password.

