Can I create and modify variables in an Excel sheet?

3 次查看（过去 30 天）

Missael Hernandez 2021-9-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1454834-can-i-create-and-modify-variables-in-an-excel-sheet

评论： Missael Hernandez 2021-9-16

Suppose that someone does not have access to MATLAB, but does to Excel. Could they edit a variable in an Excel sheet, send that sheet to me, and once I upload to it to the Current Folder in MATLAB, have those modifications show up in the workspace?

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

Geoff Hayes 2021-9-16

Missael - if someone sends you an updated Excel spreadsheet then those modifications will show up in the MATLAB workspace only once you read (via whichever MATLAB code that you have written) that updated file.

请先登录，再进行评论。

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

回答（1 个）

Image Analyst 2021-9-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1454834-can-i-create-and-modify-variables-in-an-excel-sheet#answer_789074

Yes, they can give you data in whatever form you like - text file, csv file, xlsx file, etc. Then you can read in the file and use that variable. When you read them in, they will show up in the workspace.

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

Missael Hernandez 2021-9-16

No. So I have some huge model in Simulink (which requires New Eagle). Some of the blocks have Help Text strings that I, the user, can insert. Like for example, I can put "This block is the vehicle speed." So what I want to do, is make that a variable so any user can chage that string if they want. I already figured that out. I want to take it a step further and use Excel or Notepad, to have a user, who may not have MATLAB, download the Workspace as an Excel/Notepad file, and have them modify that Help Text string in Excel/Notepad. Then I can add that file to the Current Folder on MATLAB and have the Workspace variabales updated to whatever the user put.

Missael Hernandez 2021-9-16