Trouble reading in multiple xls files
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
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
le 14 Mai 2014
Try using all 3 outputs of xlsread()
[numbersOnly, textOnly, everything] = xlsread(filename);
Plus de réponses (1)
Voir également
Catégories
En savoir plus sur Get Started with MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!