How to import Excel table with column of as individual variables?

Question

Joey Otanez 2021-11-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1590584-how-to-import-excel-table-with-column-of-as-individual-variables

回答： Peter Perkins 2021-11-23

采纳的回答： Cris LaPierre

How would I import a table from Excel such as this

to load into my workspace as this?

Using the readtable function inputs it as a table with a column of the names and a column for values (except the fts2mph and mph2fts which show up as NaN but that's another issue)

idk how to convert it to individual variables from the table or if there's a direct way to create the variables from the Excel file

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

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2021-11-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1590584-how-to-import-excel-table-with-column-of-as-individual-variables#answer_835459

编辑：Cris LaPierre 2021-11-19

Try the rows2vars function on the result of readtable. It reorients a table so that rows become variables.

The variables will still be part of a table (columns of a table are the variables), so they will not show up individually in your workspace, but you can access them using table.varName notation (see here).

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

Joey Otanez 2021-11-19

Executing that code results in a 1x2 cell array of Var1 and Var2

Cris LaPierre 2021-11-19

Those are your variable names.

Look through the examples on the rows2vars documentation page. This is expected. You will need to use the 'VariableNameSource' name-value pair to name the new table variables something else.

请先登录，再进行评论。

Answer 2

Peter Perkins 2021-11-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1590584-how-to-import-excel-table-with-column-of-as-individual-variables#answer_838804

I don't know that readtable is the way to go here. If you really just have a few named scalars, you might think about readcell (since R2019a), and then create a scalar struct named constants with one field for each of rhoSL aSL, etc. You could also poof them into your workspace using eval, but that's usually considered bad form.