How to read a column with numbers and words from several Excel?

2 views (last 30 days)
José Javier Rubio Rubio
José Javier Rubio Rubio on 19 Nov 2020
Answered: Ananthi Jegan on 19 Nov 2020
I would like to read a column from several excel. The data in the column can be: 1P, 2P, 3P, 4P, 5P, 6P. I know [~,txtData] but only I know how to use it in order to read from one excel not from several. Could you help me to figure it out? For reading numeric columns from several excel I usually use the code below with readmatrix but I don't know how to read columns with numbers and words.
Thanks in advance.
range='C:D';
% get list of .xlsx files
d=dir('2019_*.xlsx'); % 'list' is built-in MATLAB function -- don't alias it...
numFiles = length(d);
energy=zeros(numFiles,2); % allocate for the energy sums
for k = 1:numFiles
energy(k,:)=sum(readmatrix(d(k).name,'Range',range,'NumHeaderLines',1),'omitnan');
end

Answers (1)

Ananthi Jegan
Ananthi Jegan on 19 Nov 2020
You have to replace "readmatrix" with "readtable" to read columns with both numbers and strings from excel
readtable(d(k).name,'Range',range,'NumHeaderLines',1)

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by