Info

此问题已关闭。 请重新打开它进行编辑或回答。

Importing excel coloumn as variables and their values

2 次查看（过去 30 天）
Waqas Syed
Waqas Syed 2016-2-11
关闭： 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?

此问题已关闭。

回答（1 个）

Star Strider
Star Strider 2016-2-11
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
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
Star Strider 2016-2-11
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.

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by