Trouble reading in multiple xls files

1 vue (au cours des 30 derniers jours)
Adrienne
Adrienne le 12 Mai 2014
Commenté : BOB le 16 Mai 2014
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?

Réponse acceptée

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

Connectez-vous pour commenter.

Plus de réponses (1)

Image Analyst
Image Analyst le 12 Mai 2014

Catégories

En savoir plus sur Get Started with MATLAB dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by