Read Variables with assigned values from excel into Matlab

2021 2 4
2 个回答
回答已采纳
更新时间：2021 2 4
7 次查看（30 天）

0 个投票

I want to read variables with assigned values from excel file (in multiple sheets) into Matlab. In the below snip Var1, Var2 and Var 3 have assigned values 10,5 and 21 respectively.
Kindly inform if it is possible. Thank You.

请先登录，再回答此问题。

 采纳的回答

Stephen23
Stephen23 2021-2-4
编辑：Stephen23 2021-2-4
Ran in:

1 个投票

Ran in:
Note how the file itself contains invalid variable names: they contain space characters which in all of your comments you have simply ignored. Computers however do not just ignore things in the way that humans like to do, and this hints at some of the reasons why some issues with this approach (how to handle invalid names? How to handle conflicting/identical names? etc.).
Here is one simple method which creates an easy-to-use table of the imported data:
tbl = readtable('test.xlsx','ReadRowNames',true);
tbl = rows2vars(tbl,'VariableNamingRule','modify')
tbl = 1x8 table
OriginalVariableNames Var1 Var2 Var3 Row4 INPUTSOFTYPE2 Var4 Var5 _____________________ ____ ____ ____ ____ _____________ ____ ____ {'Var1'} 10 5 21 NaN NaN 21 4
And accessing the values:
tbl.Var1
ans = 10
tbl.Var5
ans = 4

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Ajiket Patil
Ajiket Patil 2021-2-4
Thanks for correcting the invalid variable name part.
My purpose is served by the above code.
Thank You very much @Stephen Cobeldick

请先登录，再进行评论。

更多回答（1 个）

KSSV
KSSV 2021-2-4

1 个投票

file = 'test.xlsx' ;
T = readtable(file) ;
vars = T.(2) ;
vars(isnan(vars))=[] ;
vars

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Ajiket Patil
Ajiket Patil 2021-2-4
@KSSV I want to assign variables Var1 = 10, Var2 = 5 .... in the excel sheet to the workspace in Matlab i.e (read assigned inputs with variable values from an excel sheet and use in matlab). In matlab workspace
In matlab workspace, i need to read both variable name along with assigned value.
The Workspace should contain.
Var1 = 10,
Var2 = 5
Var3 = 21 and so on.
KSSV
KSSV 2021-2-4
The given code exactly does what you want.
vars(1) % this is vars1
vars(3) % this is vars3
.
.
.
vars(i)
Ajiket Patil
Ajiket Patil 2021-2-4
It gives vars as a 5*1 array. I want workspace with assigned double variables.
Eg. Workspace should look like
Var1 = 10;
Var2 = 5;
Var3 = 21;
Var4 = 21;
Var5 = 4;
My purpose is not to remember eg. vars(3) = Var3, while performing computations with the variables, as i will deal with multiple variables.
Ajiket Patil
Ajiket Patil 2021-2-4
clarification if variable names are confusing.
The output of the code should be in workspace
a = 10;
b = 5;
c = 21;
d = 21;
e = 4;
and not an vars (5*1) array, to remember vars(3) = c.
Thank you for your effort.
KSSV
KSSV 2021-2-4
I got the question...my point is there is no meaning in assigning the variables like you want. It is not required.
Ajiket Patil
Ajiket Patil 2021-2-4
编辑：Ajiket Patil 2021-2-4
I am making an app through matlab app designer. It reads data in the above format and performs further computations.
I require as per the above format because of not to remember vars(3) = c. as i am dealing in many variables. Noting the cell location in the excel sheet for all the variables is tedius.
Thank You.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2019a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by