Exporting data sets to excel

10 次查看(过去 30 天)
Shalini
Shalini 2012-3-7
I'm doing curve fitting.Firstly I read some data-sets from excel into matlab using xlsread.Then in the curve fitting toolbox I created some exclusion rules for the data sets.
I now want to bring these data sets (after creation of exclusion rules) to an xls file.
Please can anyonme advise how to do this please?

回答(2 个)

Tigersnooze
Tigersnooze 2012-3-7
xlswrite is what you'll want to use. Correct usage can be found in the help, but I'll put it here for you:
xlswrite(filename, data, sheet, range)
So say you want to write matrix A to an excel file with the name myfile.xls, on sheet 1, starting at cell A1:
xlswrite('myfile.xls', A, 'Sheet 1', 'A1')
Keep in mind that if you just put 'A1', and say you have a 3x5 matrix, your data will be written to A1:C5. Sheet can either be a string with the name of the sheet, or an integer value for the sheet index.
Hope that helps.
  9 个评论
Shalini
Shalini 2012-3-7
I think if you hit the "Analysis" button, there's an option to export the data to the workspace
That is only for predicted and independent data.I want the data set with which the fir is done to go to xls with exclusion.No option found yet!
Tigersnooze
Tigersnooze 2012-3-7
Does the fit data come with a plot? You could always go old school and get the data directly from the plot to the workspace using get(gco, 'xdata') and get(gco, 'ydata'). That could be an option, I don't have much experience with cftool.

请先登录,再进行评论。


Srinivas
Srinivas 2012-3-7
doc xlswrite
  4 个评论
Shalini
Shalini 2012-3-7
I have done curve fit through the GUI.
In the command window I type,
X = xlsread('QS2T.xls',2,'A1:A10')
Y = xlsread('QS2T.xls',2,'B1:B10')
cftool
I get the dialog box.
I create exclusion rules for data sets
I do non linear curve fit using custom equation.
Now, the data sets with exlusion rules need to to excel
Srinivas
Srinivas 2012-3-7
I don't have curve fitting toolbox to look at, but looking at this page http://www.mathworks.com/products/curvefitting/description8.html, you can save the post processed signals to workspace and then write to excel

请先登录,再进行评论。

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by