home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR8
/
123EXP.ZIP
/
README
< prev
next >
Wrap
Text File
|
1994-01-07
|
3KB
|
57 lines
Samples of reading and writing to a 1-2-3 spreadheet file.
──────────────────────────────────────────────────────────
These Clarion 2.1 source files illustrate some methods I have used to
read from and write to a Lotus 1-2-3 spreadsheet file (.WKS and .WK1
versions). Please note that I have not spent much time documenting
these modules or the methods I used but I hope that you find them
helpful.
EXPRTWK1.CLA - This creates a 1-2-3 spreadsheet file and writes
"records" to it from a Clarion data file.
IMPRTWK1.CLA - Reads a 1-2-3 spreadsheet and creates Clarion data
file records from the info in the spreadsheet.
IMP_ROW.CLA - Prompts for a spreadsheet filename and loads ONE
contiguous row (or column) of numbers from the
spreadsheet. It presents the data it finds for
previewing and allows the user to keep it or
continue looking elsewhere in the spreadsheet.
WYSIFILE.CLA - This generalized function procedure contains common
functions needed to create a WYSIWYG .FMT format
file.
WKS_FILE.INC - This INCLUDE file contains the 1-2-3 file and record
definitions and various variables used to read and
write a 1-2-3 spreadsheet.
WYSIFILE.INC - This INCLUDE defines the WYSIWYG file layout and
variables used in the WYSIFILE.CLA procedure.
WYSIWYG.INC - This defines the op codes and formatting information
codes passed to the WYSIFILE procedure. To try
to simplify the code needed to produce a WYSIWYG
file, I came up with these generalized op codes and
format definition variables. The WYSIFILE procedure
converts these to the values that 1-2-3 expects
to find in a .FMT file.
Please note that creating a WYSIWYG formatting file (.FMT) used by 1-2-3
Release 2.3 and 2.4 is tricky. You almost have to have a copy of the file
format documentation provided by Lotus Development in order to understand
how this is done.
I you have questions that I might be able to help you with, please don't
hesitate to post a message to me on CompuServe (71700,1036).
Good Luck!
- Dick
╔══════════════════════════════════════════════════════════════════════╗
║ Dick DeVillers 01/07/94 ║
║ Arthur Consulting Group, Inc. ║
║ 21110 Oxnard Street ║
║ Woodland Hills, California 91367 ║
║ (818) 702-8003 ║
║ CIS: 71700,1036 ║
╚══════════════════════════════════════════════════════════════════════╝