How can I associate Excel header names as column variables when using XLSREAD?

Question

MathWorks Support Team le 27 Juin 2009

0
Lien

Utiliser le lien direct vers cette question

https://fr.mathworks.com/matlabcentral/answers/101986-how-can-i-associate-excel-header-names-as-column-variables-when-using-xlsread

Commenté : Madhura Suresh le 20 Nov 2014

Réponse acceptée : MathWorks Support Team

I have an Excel file with columns of data. The top row has column names. When pulling into MATLAB using the XLSREAD function I would like to have variables created with the same name as the column headers which contain the column data.

Connectez-vous pour répondre à cette question.

Answer 1

MathWorks Support Team le 27 Juin 2009

0
Lien

Utiliser le lien direct vers cette réponse

https://fr.mathworks.com/matlabcentral/answers/101986-how-can-i-associate-excel-header-names-as-column-variables-when-using-xlsread#answer_111333

This can be performed using a FOR loop and the EVALIN function

[mydata, myheader] = xlsread('Book1.xls');
for i = 1:length(myheader)
      % compose a command to assign each column to a variable with the same 
      % name as the header
      commandExec = [myheader{i}, ' = ', 'mydata(:,', num2str(i) , ');'];
      % execute the composed command to actually create the variable
      evalin('base', commandExec );
end