Lotus 123 Spreadsheets
This section covers
wk1read reference pages for more detailed information and examples.
Getting Information About the File
wk1finfo function to determine if a file contains a Lotus WK1 spreadsheet:
'WK1'if the file is a Lotus spreadsheet readable with the
wk1readfunction. Otherwise, it contains an empty string (
'Lotus 123 Spreadsheet'
Example -- Querying a WK1 File. This example returns information about spreadsheet file
Exporting to the File
wk1write function to export a matrix to a Lotus spreadsheet file. You have the choice of positioning the matrix starting at the first row and column of the spreadsheet, or at any other location in the file.
To export to a specific location in the file, use the second syntax, indicating a zero-based starting row and column.
Example -- Writing to a WK1 File. This example exports an 8-by-8 matrix to spreadsheet file
Importing from the File
To import data from the spreadsheet into the MATLAB workspace, use
wk1read. There are three ways to call
wk1read. The first two shown here are similar to
wk1write. The third enables you to select a range of values from the spreadsheet. You can specify the
range argument with a one-based vector, spreadsheet notation (e.g.,
'A1..B7'), or using a named range (e.g.,
Example -- Reading from a WK1 File. Read in a limited block of the spreadsheet data by specifying the upper-left row and column of the block using zero-based indexing:
|Working with Spreadsheets||Working with Scientific Data Formats|
© 1994-2005 The MathWorks, Inc.