数据格式如下:
数据有M行,每行有4列,4列之间用“,”分开,每列中的数据用“%%”分开
提取这些数据并保存
数据文件内容如下:
RawData.xlsx
aaaaa,bbbb%%cccc%%ddddd,eeeee%%ffffff%%gggggg,hhhhhh
jjjjjjjjjjj,kkkkkkkkkk,,
function [stData] = ReadData(varargin)
if nargin==0
filename = 'RawData';
elseif nargin==1
filename = varargin{1};
else
error('Incorrect number of input arguments.')
end
[NUM,TXT,RAW]=xlsread(filename);
stData = struct([]);
for i = 1:size(RAW,1)
LINE = regexp(RAW{i},',','split');
LineData = {}
for j = 1:size(LINE,2)
COLUME = regexp(LINE{j},'%%','split');
ColumeData = {};
for k = 1:size(COLUME,2)
ColumeData = [ColumeData COLUME{k}];
end
colName = strcat('col' , num2str(j));
stData(i).(colName) = ColumeData;
LineData = [LineData ColumeData];
end
end
save('DataFile.mat', 'stData');
读取结果如下: