Trouble reading in multiple xls files

1 view (last 30 days)
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?

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 12 May 2014
Edited: Azzi Abdelmalek on 12 May 2014
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 Comments
Image Analyst
Image Analyst on 14 May 2014
Try using all 3 outputs of xlsread()
[numbersOnly, textOnly, everything] = xlsread(filename);
BOB
BOB on 16 May 2014
What shall I put this instead of?
This is the code I am trying currently:
:

Sign in to comment.

More Answers (1)

Image Analyst
Image Analyst on 12 May 2014

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!