Example of how to save or read data to an Excel archive.
% 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]);
Cite As
Héctor Corte (2024). Example of how to save or read data to an Excel archive. (https://www.mathworks.com/matlabcentral/fileexchange/34631-example-of-how-to-save-or-read-data-to-an-excel-archive), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Acknowledgements
Inspired by: xlswrite - legacy, xlsheets, dat2xls, xlschart, XLSWriteMex, xlswrite_mod, xlcolumn, xlswrite
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |