Importing variables from an xlsx/txt file

Question

amberly hadden 2015-8-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/234906-importing-variables-from-an-xlsx-txt-file

评论： amberly hadden 2015-8-21

Hello everybody-

I was wondering if there is a way to import variables from xlsx or txt file in workspace with names ? I know about import wizard > Column vectors and generate script. But I have huge data set in which variables positions are varying so I'm much interested to read a file with its header so that in workspace I get all variables with that command?

Thanks in advance

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2015-8-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/234906-importing-variables-from-an-xlsx-txt-file#answer_189984

As I suggested in your other posting, use readtable() .

Otherwise you are asking for variables to be "poofed" into existence based upon the column names. Creating variables dynamically is rarely a good idea.