MATLAB Function Reference

wk1read

Read Lotus123 spreadsheet file (.wk1)

Syntax

M = wk1read(filename)
M = wk1read(filename,r,c)
M = wk1read(filename,r,c,range)

Description

M = wk1read(filename) reads a Lotus123 WK1 spreadsheet file into the matrix M.

M = wk1read(filename,r,c) starts reading at the row-column cell offset specified by (r,c). r and c are zero based so that r=0, c=0 specifies the first value in the file.

M = wk1read(filename,r,c,range) reads the range of values specified by the parameter range, where range can be:

• A four-element vector specifying the cell range in the format

[upper_left_row upper_left_col lower_right_row lower_right_col]

• A cell range specified as a string; for example, 'A1...C5'.
• A named range specified as a string; for example, 'Sales'.

See Also

wk1write

wilkinson

wk1write