MATLAB Function Reference

wk1write - Write matrix to Lotus 1-2-3 WK1 spreadsheet file

Syntax

wk1write(filename,M)
wk1write(filename,M,r,c)

Description

wk1write(filename,M) writes the matrix M into a Lotus1-2-3 WK1 spreadsheet file named filename. The filename input is a string enclosed in single quotes.

wk1write(filename,M,r,c) writes the matrix starting at the spreadsheet location (r,c). r and c are zero based so that r=0, c=0 specifies the first cell in the spreadsheet.

Examples

Write a 4-by-5 matrix A to spreadsheet file matA.wk1. Place the matrix with its upper left corner at row 2, column 3 using zero-based indexing:

A = [1:5; 11:15; 21:25; 31:35]
A =
     1     2     3     4     5
    11    12    13    14    15
    21    22    23    24    25
    31    32    33    34    35

wk1write('matA.wk1', A, 2, 3)

M = wk1read('matA.wk1')
M =
     0     0     0     0     0     0     0     0
     0     0     0     0     0     0     0     0
     0     0     0     1     2     3     4     5
     0     0     0    11    12    13    14    15
     0     0     0    21    22    23    24    25
     0     0     0    31    32    33    34    35

See Also

wk1read, dlmwrite, dlmread, csvwrite, csvread

wk1read

workspace