Category : Lotus and other Spreadsheets
Archive   : PRN2WKS.ZIP
Filename : PRN2WKS.DOC

prn2wks - Print to Worksheet

Version 1.0 - August, 1989


Leander Software & Consulting
15072 E. Mississippi Ave.
Box # 51
Aurora, CO 80012



INTRODUCTION

Print to Worksheet is a program which will take any report
that has been printed to disk and transform it directly into
a spreadsheet file. You can then load this file into just
about any spreadsheet program and resequence the report,
select and total in several different ways or even produce
graphs. Data can come from your PC data base, accounting
programs, a corporate mainframe or any program which will
print data to disk instead of the printer.


OPERATION

The program can be run in two different modes. The first
time a report is to be converted to spreadsheet format, the
program is run interactively. The file is loaded into a
window within the program and field borders are set by moving
the cursor to the first column of the field then pressing the
key. When all field borders are set, the GO command
is selected and the report is written to a spreadsheet file.
As the report file is being processed, an MS/DOS command is
displayed on the bottom of the screen which may be run
directly from the a> or c> prompt to convert the file to a
spreadsheet.

To run the program, enter

a>prn2wks [filename]

filename may be included to indicate the report file to be
processed. If a filename is omitted, the program will prompt
you for it. The program assumes that the file extension is
filename.prn for the report file and automatically writes the
worksheet file as filename.wks or filename.wk1 depending on
the spreadsheet format selected.






After the file is loaded, you may use any of the following
keystrokes or commands to direct the program.

Keystrokes


Moves the cursor left or right.

Scrolls the report left.

Scrolls the report right.

Places a field border at the present cursor
position. If the cursor is already over a
field border, it will be removed.


Scrolls the report up or down one line.


Scrolls the report up or down one page.

/ Activates the menu at the top of the
screen.

Returns the cursor from the menu.


Menu Commands

Load Loads a new report file.

Go Converts the report file to a worksheet.

Conf (Configuration) Change the screen colors
and worksheet format.

Help Lists program commands.

Quit Ends the program.


Note: all menu commands can be entered as keystrokes by
pressing the key and the first letter of the command at
the same time. Example : H will display the help
screen.








To run the program in command line mode, use the MS/DOS
command sequence:

a> prn2wks filename /c=

The filename is the report file name (same as above) and the
/c switch indicates the field borders listing the column
numbers where each field begins. Example:

a> prn2wks report.prn /c=10,45,60,75

prn2wks indicates the program to be run. report.prn is the
report file to be converted using fields starting at column
1, column 10, column 45, etc. The spreadsheet produced will
be named report.wks.


REGISTRATION

This program is distributed using the "shareware" concept.
You may copy it and distribute it to others for use on a
trial basis as long as the program file (prn2wks.exe), this
documentation and the registration form are included without
any modifications. It may also be put on bulletin boards and
distributed through any of the shareware catalogues.

If you find this program useful, you are encouraged to become
a registered user. For the $30.00 registration fee, you will
receive the full instruction manual and the most recent
version of the program. To print the registration form, use
the following DOS command:

a> type prn2wks.frm >prn


PROGRAM PROBLEMS

If you discover any problem with the program, please describe
the problem and print the results (both the program screen
and the spreadsheet results) and include them your name,
address and phone number. Send them to the address listed on
the registration form. We want to know of problems even if
you are not a registered user.


LEGAL STUFF

Use of this software signifies your agreement that Leander
Software & Consulting grants you a licence to use the prn2wks
program "as is" with no guarantees. The program may also be
copied and distributed according to the restrictions stated
above. We will not be liable for any damages or loss of
income caused by using the program and cannot guarantee the
accuracy of any program results.