Example of how to save or read data to an Excel archive.

This function writes data inside an Excel archive. Is an example of usage of commands.

Description

% First we create some data.

t=linspace(0,10);
x=sin(t);
data=num2cell([t;x]');

% Now we have a cell with two rows, one % for t and another for x.
% We also have an Escel archive called % "myexcel.xls"
% We want to put those rows into the
% excel archive, in rows A and B.
% With headers "t" and "x(t)".

[name,path]=uigetfile('*.*');
workwith_excel([path,name],'Hoja1',[{'t'},{'x(t)'}],[1,1;1,2]); workwith_excel([path,name],'Hoja1',data,[2,1;11,2]);

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
xlswrite, xlsheets, dat2xls, xlschart, XLSWriteMex, xlswrite_mod, xlcolumn, xlswrite

• MATLAB release: MATLAB 7.10 (2010a)