Importing excel coloumn as variables and their values

Question

Waqas Syed 2016-2-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/267750-importing-excel-coloumn-as-variables-and-their-values

关闭： MATLAB Answer Bot 2021-8-20

Hi,

I have simple excel file with two coloumns.

First coloumn has names e.g A,B,C,D etc Second coloumn has numeric values.

Number of components in both coloumns are equal.

I want to import both coloumns to matlab and create variables whose names are coloumn 1 and values are coloumn 2.

How can I do that?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Star Strider 2016-2-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/267750-importing-excel-coloumn-as-variables-and-their-values#answer_209516

在 MATLAB Online 中打开

I would use xlsread with two outputs:

[Num,Str] = xlsread( ... filename ...);

The numeric values will be in the ‘Num’ vector (in this instance), and the ‘Str’ variable will be a cell array of strings representing the first column.

Note — This is obviously UNTESTED CODE but it should work.

2 个评论
显示无隐藏无

Waqas Syed 2016-2-11

I dont think you understood my question. Sorry if I was not clear enough.

This would simply create two arrays.

I want every string of coloumn 1 to become a variable and get the value which is of the corresponding elecment in the second coloumn.

Star Strider 2016-2-11

在 MATLAB Online 中打开

If you want to refer by name to every element in the cell column and get the corresponding numeric value, do this:

Num = randi(9, 10, 1);                                          % Numeric Vector
Str = {'A'; 'B'; 'C'; 'D'; 'E'; 'F'; 'G'; 'H'; 'I'; 'J'};       % String (Cell) Vector
Val = Num(strcmp('C',Str));                                     % Return The Value In ‘Num’ Corresponding to ‘C’ In ‘Str’

Creating dynamic variables is very poor programming practice. It is much better to simply use a comparison such as I did here to retrieve the values you need.