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

1 visualización (últimos 30 días)
José Javier Rubio Rubio
José Javier Rubio Rubio el 19 de Nov. de 2020
Respondida: Ananthi Jegan el 19 de Nov. de 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

Respuestas (1)

Ananthi Jegan
Ananthi Jegan el 19 de Nov. de 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)

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by