Read Variables with assigned values from excel into Matlab

9 次查看（过去 30 天）
Ajiket Patil
Ajiket Patil 2021-2-4
编辑： Ajiket Patil 2021-2-4
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:
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 个）

KSSV
KSSV 2021-2-4
file = 'test.xlsx' ;
T = readtable(file) ;
vars = T.(2) ;
vars(isnan(vars))=[] ;
vars
  6 个评论
显示 4更早的评论
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.

请先登录，再进行评论。

类别

在 Help Center 和 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