Be the first to rate this file! 3 Downloads (last 30 days) File Size: 3.3 KB File ID: #34631

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

by Héctor Corte

 

17 Jan 2012

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

| Watch this File

File Information
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

Xlswrite, Xlsheets, Dat2xls, Xlschart, Xls Write Mex, Xlswrite Mod, Xlcolumn, and Xlswrite inspired this file.

MATLAB release MATLAB 7.10 (R2010a)
Tags for This File  
Everyone's Tags
communications, data exploration, data export, data import, demo, modeling
Tags I've Applied
Add New Tags Please login to tag files.
Please login to add a comment or rating.

Contact us