Naming variables from one column Import file

Question

meryem berrada 2021-5-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/828725-naming-variables-from-one-column-import-file

评论： meryem berrada 2021-5-12

Hello,

I am importing a selected amount of cells from an excel file (selected manually - let's say cells A1:A5) and MATLAB automatically names the variable with the column name (A). Then, when I import cells A6:A10, MATLAB automatically name the variable A again, which overwrites the first variable. It is time consuming to rename the variables manually one by one as I have hundreds of them.

Is there a way to attribute imported cells to a variable name (I have a list of the variables in order) ?

Thank you!

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-5-12

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/828725-naming-variables-from-one-column-import-file#answer_698590

No. When you are importing variables manually using the import tool, then you are stuck with what the import tool provides.

If you already have a list of which cells to import, do the reading in code... and not assigning to individual variables.

For example the above hints that you might be grouping every 5. If so, then read the entire column at one time, and reshape() it to the number of rows each.