home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Media Share 9
/
MEDIASHARE_09.ISO
/
dbase
/
tab123.zip
/
TAB123.DOC
< prev
next >
Wrap
Text File
|
1992-09-09
|
21KB
|
565 lines
Tab123, copyright (c) 1991 by Mountain Software
Tab123
AutoCAD Spreadsheet Interface Utility
Version 1.0
September 8, 1991
┌─────────┐
┌─────┴───┐ │ (R)
──│ │o │──────────────────
│ ┌─────┴╨──┐ │ Association of
│ │ │─┘ Shareware
└───│ o │ Professionals
──────│ ║ │────────────────────
└────╨────┘ MEMBER
Jerry Workman, P.E.
1579 Nottingham Road
Charleston, WV 25314
CIS 70717,3564
Tab123 for AutoCAD User's Guide, version 1.0
Table of Contents
I. U s i n g T a b 1 2 3 . . . . . . . . . . . . . . . . . . . . . 3
Purpose . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Running Tab123 . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Read_WKS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Suggestions . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
II. A d d e n d u m . . . . . . . . . . . . . . . . . . . . . . . . . 6
Error Messages . . . . . . . . . . . . . . . . . . . . . . . . . . 6
Liability . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
III. L i c e n s e . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Registration Information . . . . . . . . . . . . . . . . . . . . . 7
Definition of Shareware . . . . . . . . . . . . . . . . . . . . . 8
Disclaimer - Agreement . . . . . . . . . . . . . . . . . . . . . . 8
Trademark . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
IV. I n d e x . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Tab123 for AutoCAD User's Guide, version 1.0
I. U s i n g T a b 1 2 3
Purpose
-------
Tab123 is a utility that provides the ability to import Lotus 123 and
Symphony spreadsheet files into an AutoCAD drawing as a table of text
entities, and if desired, a cell grid to enclose the table. Tab123 runs
from within the AutoCAD drawing editor and will read .WKS and WK1 files
directly. The program reads not only the data from the spreadsheet file,
but also calculated formula values. Formatting information; Column widths,
cell formats, and cell alignment are also read and used to create the
table. Tab123 is executed through an AutoLisp program (TAB123.LSP) and an
external executable program (READ_WKS.EXE). Tab123 works on any IBM PC
compatible computer capable of running AutoCAD.
Installation
------------
Copy the Tab123 files from the distribution diskette (or extract them from
the archive file) to your AutoCAD subdirectory, or to sub-directories where
DOS and AutoCAD can find them. READ_WKS.EXE can be in any directory that is
on the DOS PATH. TAB123.LSP must be in a directory that is in the AutoCAD
library path. If you are not sure of your DOS or AutoCAD paths, place both
files in the same directory as ACAD.EXE (usually C:\ACAD). To insure that
AutoCAD can find files in your support directory, add the following to your
AUTOEXEC.BAT file:
SET ACAD=C:\ACAD\SUPPORT (or where ever your support files are located)
NOTE: The AutoCAD command SHELL must work so that
READ_WKS.EXE can execute.
Chapter 1, Using Tab123 Page 3
Tab123 for AutoCAD User's Guide, version 1.0
Running Tab123
-------------------
First load the AutoLISP program:
Command: (LOAD"TAB123")
Then execute...
Command: TAB123
Follow the prompts:
Load/Draw/All/Parms/Exit/<All>:
Load: Loads a spreadsheet file, an external DOS program (READ_WKS.EXE)
is executed to convert the data in a range to a format that
AutoLISP can read. A file named ACAD.123 is created in the
current directory containing the extracted data.
Draw: Draws the previously loaded table in the drawing. You are
prompted for the table location, and text size (if the current
style has a text size of 0.0), and if you wish a grid drawn. The
file ACAD.123, created in the previous step, is read and the
table drawn.
All Both Loads and Draws the table
Parms Display / change Tab123 variables
RowScaleFactor/CharOffsetFactor/Exit/<Exit>:
RowScaleFactor: Centers / spacing between rows. A value of 2.0 (the
default) will space rows at 2.0 x text height (determined by the
AutoCAD text style active or the height entered by the user).
CharOffsetFactor: Offset of the first and last character(s) from the
left and right margins. A value of 1.0 (the default) will make cell
margins 1.0 x text character width (determined by the AutoCAD text
style active).
Exit Exits Tab123 with no action.
Read_WKS
--------
Read_WKS is the DOS executable program that does the actual extraction from
the worksheet file. This program can be used external to AutoCAD to extract
data from a .WK? file in comma delimited format for use by other programs,
or for reporting. Read_WKS operated form the DOS command line using
switches and parameters to control it's operations. The switches / commands
/ functions are as follows:
Chapter 1, Using Tab123 Page 4
Tab123 for AutoCAD User's Guide, version 1.0
Usage: READ_WKS <switches> <filename>.WK1 <outfilename>
The .WK1 extension is added to <filename> if omitted
Switches must start with / or - and are not case sensitive.
/D Debug diagnostic display
/R___ Lotus Range [default A1..D25] (eg /RB11..F35)
/A AutoCAD LISP output (default output filename is ACAD.123)
/I Ignore repeating label cells (eg \=)
/U Unformatted (maximum precision) output"
/X eXpanded formatted report output, no delimiter, fully formatted"
/S_ Separator / Delimiter character(s) (eg /S;)"
/Q Quiet, no display except errors"
/P Password program - register Read_WKS"
/H Help - This message.
Example: READ_WKS /RC19..F35 MYFILE MYFILE.PRN
Or: READ_WKS /A /RC19..F35 MYFILE
Limits
------
Tab123 can not read version 3 Lotus, 123G or SQZ files. If you use a
version of Lotus 123 after version 2.2 or a different spreadsheet program
(eg Quattro or Excel) then save your file as a .WK1 or .WKS file, most
spreadsheets (and many other programs) provide can save in these file
formats.
Tab123 / Read_WKS can not recalculate you spreadsheet. If you use manual
recalculation then be sure to recalculate prior to saving so that formula
values will be correctly displayed.
If you wish to extract tables from very large spreadsheets then you must
provide the DOS program READ_WKS.EXE with as much memory as possible. With
AutoCAD 386 the programs BigShell and SHROOM will provide a large memory
SHELL. SHROOM.COM is included with AutoCAD release 11 and a shareware
version is available on Compuserve and many Computer Bulletin boards.
Suggestions
-----------
While developing your table in Lotus 123 (or your favorite spreadsheet)
make sure that text does not overlap into the next cell. Set column widths
to a value that is just wider than the values and text. Use "Comma" or
"Dollars" formats to make large values easier to read.
Chapter 1, Using Tab123 Page 5
Tab123 for AutoCAD User's Guide, version 1.0
II. A d d e n d u m
Error Messages
--------------
Cannot open file XXXX
Reason: Misspelled filename or possible disk error (possibly full).
Unknown switch => X <=
An unknown DOS command line switch was passed to READ_WKS.EXE.
Out of memory
Not enough memory to load a spreadsheet file. READ_WKS does not read
the entire file into memory, but only pointers to cell locations in
the file and can usually handle large files with a minimum of memory.
Revise your SHELL entry in your ACAD.PGP file or use SHROOM to
increase SHELL memory.
Unidentified Cell. OpCode = XXh Length = XX
Usually caused by processing a spreadsheet file format not known by
READ_WKS.EXE.
Liability
---------
Careful testing has been made to ensure that these programs perform
correctly. No liabilities are assumed in the use or misuse of this program
resulting in data loss or damage. It is the users responsibility to be sure
that the results are as expected.
Author
------
If you have any suggestions or comments, please contact me.
Jerry Workman, PE
1579 Nottingham Rd.
Charleston, WV 25314
CIS 70717,3564
304-744-7748 (after 7:30 ET)
Copyright 1991 by Mountain Software All rights reserved
Chapter 2, Addendum Page 6
Tab123 for AutoCAD User's Guide, version 1.0
III. L i c e n s e
Shareware
---------
This version of Tab123 is NOT public domain or free software, but is being
distributed as "shareware". You may try it out to see if it is useful for
you. If you wish to continue to use Tab123 you must register. Registered
users are provided with a password to remove the opening delay and with
support for one year.
The program in the form of the original archived file only may be freely
distributed, but not sold (except under license, or for a nominal copying
or disk fee).
Non-registered users of this software are granted a limited 30 day license
to make an evaluation copy for trial use for the purpose of determining
whether Tab123 is suitable for their needs. At the end of this trial
period, you may either register your copy, or discontinue using Tab123.
All users are granted a limited license to copy Tab123 only for the trial
use of others and subject to the above limitations. This license does NOT
include distribution or copying of this software for use:
1. In connection with any other product or service.
2. For general use within a company or institution.
3. For distribution in modified form; i.e., the file containing this
license information MUST be included, along with the full Tab123
documentation.
Operators of electronic bulletin board systems (Sysops) are encouraged to
post TAB123xx.ZIP for downloading by their users, as long as these
conditions are met.
Registration Information
------------------------
A Tab123 registration licenses you to use the product on a regular basis.
Individual license cost for Tab123 is $20. You may purchase a diskette with
the latest version of Tab123 for an additional $10. West Virginia residents
should include 6% sales tax.
Educational institutions, full-time students and BBS sysops can apply a 50%
discount. PLEASE include your educational institution letterhead (with your
title), or a photocopy of your most recent registration slip, or the name
and number of your BBS.
License Page 7
Tab123 for AutoCAD User's Guide, version 1.0
Definition of Shareware
-----------------------
Shareware distribution gives users a chance to try software before buying
it. If you try a Shareware program and continue using it, you are expected
to register. Individual programs differ on details -- some request
registration while others require it, some specify a maximum trial period.
With registration, you get anything from the simple right to continue using
the software to an updated program with printed manual.
Copyright laws apply to both Shareware and commercial software, and the
copyright holder retains all rights, with a few specific exceptions as
stated below. Shareware authors are accomplished programmers, just like
commercial authors, and the programs are of comparable quality. (In both
cases, there are good programs and bad ones!) The main difference is in the
method of distribution. The author specifically grants the right to copy
and distribute the software, either to all and sundry or to a specific
group. For example, some authors require written permission before a
commercial disk vendor may copy their Shareware.
Shareware is a distribution method, not a type of software. You should find
software that suits your needs and pocketbook, whether it's commercial or
Shareware. The Shareware system makes fitting your needs easier, because
you can try before you buy. And because the overhead is low, prices are low
also. Shareware has the ultimate money-back guarantee -- if you don't use
the product, you don't pay for it.
Disclaimer - Agreement
----------------------
Users of Tab123 must accept this disclaimer of warranty: "Tab123 is
supplied as is. The author disclaims all warranties, expressed or implied,
including, without limitation, the warranties of merchantability and of
fitness for any purpose. The author assumes no liability for damages,
direct or consequential, which may result from the use of Tab123."
Tab123 is a "shareware program" and is provided at no charge to the user
for evaluation. Feel free to share it with your friends, but please do not
give it away altered or as part of another system. The essence of
"user-supported" software is to provide personal computer users with
quality software without high prices, and yet to provide incentive for
programmers to continue to develop new products. If you find this program
useful and find that you are using Tab123 and continue to use Tab123 after
a reasonable trial period, you must make a registration payment of $30 to
Mountain Software. The $30 registration fee will license one copy for use
on any one computer at any one time. You must treat this software just
like a book. An example is that this software may be used by any number of
people and may be freely moved from one computer location to another, so
long as there is no possibility of it being used at one location while it's
being used at another. Just as a book cannot be read by two different
persons at the same time.
Shareware Page 8
Tab123 for AutoCAD User's Guide, version 1.0
Commercial users of Tab123 must register and pay for their copies of Tab123
within 30 days of first use or their license is withdrawn. Site-License
arrangements may be made by contacting Mountain Software.
Anyone distributing Tab123 for any kind of remuneration must first contact
Mountain Software at the address below for authorization. This
authorization will be automatically granted to distributors recognized by
the (ASP) as adhering to its guidelines for shareware distributors, and
such distributors may begin offering Tab123 immediately (However Mountain
Software must still be advised so that the distributor can be kept
up-to-date with the latest version of Tab123.).
You are encouraged to pass a copy of Tab123 along to your friends for
evaluation. Please encourage them to register their copy if they find that
they can use it.
Jerry Workman a member of the Association of Shareware Professionals (ASP).
ASP wants to make sure that the shareware principle works for you. If you
are unable to resolve a shareware-related problem with an ASP member by
contacting the member directly, ASP may be able to help. The ASP Ombudsman
can help you resolve a dispute or problem with an ASP member, but does not
provide technical support for members' products. Please write to the ASP
Ombudsman at 545 Grover Road, Muskegon MI 49442, or send a message via
Compuserve mail to ASP Ombudsman 70007,3536
Trademark
---------
Mountain Software and Tab123 are trademarks of Mountain Software. MS-DOS is
a registered trademark of Microsoft Corporation. PC-DOS is a registered
trademark of IBM Corporation. AutoCAD is a registered trademark of
AutoDesk. 123 and Symphony are registered trademarks of Lotus Development
Corporation
Shareware Page 9
Tab123 for AutoCAD User's Guide, version 1.0
IV. I n d e x
123 . . . . . . . . . . . . . . . . . . . . . . 3-5, 9
ACAD . . . . . . . . . . . . . . . . . . . . . . . 3-6
ACAD.EXE . . . . . . . . . . . . . . . . . . . . . . 3
ASP . . . . . . . . . . . . . . . . . . . . . . . . . 9
AutoCAD . . . . . . . . . . . . . . . . . . . 1, 3-5, 9
bulletin boards . . . . . . . . . . . . . . . . . . . 5
Command . . . . . . . . . . . . . . . . . . . . 3, 4, 6
Compuserve . . . . . . . . . . . . . . . . . . . 5, 9
directory . . . . . . . . . . . . . . . . . . . . 3, 4
disk . . . . . . . . . . . . . . . . . . . . . . . 6-8
DOS . . . . . . . . . . . . . . . . . . . . . . 3-6, 9
drawing editor . . . . . . . . . . . . . . . . . . . 3
error . . . . . . . . . . . . . . . . . . . . . . . . 6
license . . . . . . . . . . . . . . . . . . . . . . 7-9
LISP . . . . . . . . . . . . . . . . . . . . . . . . 5
Lotus . . . . . . . . . . . . . . . . . . . . . 3, 5, 9
shareware . . . . . . . . . . . . . . . . . . 1, 5, 7-9
SHELL . . . . . . . . . . . . . . . . . . . . . 3, 5, 6
SHROOM . . . . . . . . . . . . . . . . . . . . . 5, 6
subdirectory . . . . . . . . . . . . . . . . . . . . 3
ZIP . . . . . . . . . . . . . . . . . . . . . . . . . 7
Index Page 10