数模学习笔记（一）

1、matlab读取文件中的数据

1）列数相同的纯数据：load

sample_file.txt ：

% Load the file to the matrix, M :
M = load('sample_file.txt') 

 2）有注释（无独立的数字串）、字段名、列数相同的数据:importdata

sample_file2.txt ：

%read the fata from the file 'sample_file2.txt' and create a
%structure D that contains both data and text data
D = importdata('sample_file2.txt');
data = D.data;
text = D.textdata; 

2、matlab与excel的数据交换

1）matlab读取excel数据：xlsread

一般直接利用excel读取dat文件的数据更为简单

%format:xlsread(fileroute','sheet','range')
y=xlsread('sample.xlsx','sheet1','c2:c20')

2）matlab将数据保存在excel中：xlswrite

%format:xlswrite('filename.xls',variablename,'sheet','range')
b=[1,2,3,4,5,6];
xlswrite('test.xls',b','Sheet2','B');