why does appear the error message: Error in table2cell t_vars = getVars(t,false);?
1 view (last 30 days)
Show older comments
Dear community
I have a program to load several excel files:
datadir = 'C:\Users\Jonat\Desktop\limpio';
dinfo = dir( fullfile(datadir, '*.xlsx') );
filenames = fullfile( datadir, {dinfo.name} );
numfiles = length(filenames);
datatable = [];
for K = 1 : numfiles
thisfile = filenames{K};
thistable = readtable(thisfile);
if K == 1
datatable = thistable;
else
datatable = [datatable; thistable];
end
end
Clean=table2cell(datatable);
nrow = height(datatable);
lastidx = floor(nrow/9) * 9;
E_p = mean(reshape(datatable{1:lastidx,17}, 9, []));
E_C=E_p.';
When I first used this program, I didn´t have any problem, but now, appear this error:
Error in table2cell (line 21)
t_vars = getVars(t,false);
Please help!
Thank you so much
4 Comments
Walter Roberson
on 4 Oct 2019
After you assign to numfiles you should add the lines
assert(numfiles > 0,'no files found')
Answers (0)
See Also
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!