Trouble reading in multiple xls files
1 次查看(过去 30 天)
显示 更早的评论
clear all; % clears all variables from your workspace
close all; % closes all figure windows
clc; % clears command window
%%define number of trials
njump=81;
[1] input variables of trial data
%%%%%%%%%%%%%%%%%%%%%
%read in excel data in CSV format
for i=1:njump
data1=xlsread('Trial%i.csv','Trial%i','A1:E7000'); % jump data
end
^^^^^ this is what I have written, however it will not read in all of the data that I need. I have 81 trials but it will not read them in even when I have put a loop in. I am quite a novice in matlab and I don't understand what I am doing wrong. Can anyone help?
0 个评论
采纳的回答
Azzi Abdelmalek
2014-5-12
编辑:Azzi Abdelmalek
2014-5-12
data1 is overwriten each loop, use
for i=1:njump
data1{i}=xlsread(sprintf('Trial%i.csv',i),sprintf('Trial%i',i),'A1:E7000'); % jump data
end
If you want to clear all workspace variables use
clear
% without all
10 个评论
Image Analyst
2014-5-14
Try using all 3 outputs of xlsread()
[numbersOnly, textOnly, everything] = xlsread(filename);
更多回答(1 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!