Is there a way to load data from an Excell file making sure that this is Saved?

1 次查看（过去 30 天）

Aurea94 2021-2-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/733648-is-there-a-way-to-load-data-from-an-excell-file-making-sure-that-this-is-saved

评论： Aurea94 2021-2-5

In one of my projects, I am constantly editing input data for a Matlab program in an .xlsx file. Each time I run the Matlab program, this reads the specifie column of the .xlsx file and continues running the program. However, if I forget clicking save in the Excell file before running the Matlab, the changed values are not loaded into Matlab Workspace.

Thus, my question is if there is a way to make sure .xlsx file is saved before reading the data from it.

Hope I explained myself properly.

Thank you very much in advance.

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

Aurea94 2021-2-2

Yes Is Windows with Excell Installed. I dont' know that command, but I will check. Thanks

Aurea94 2021-2-2

I am trying to go throught ActiveX, however I can see it is a complex programing tool, that makes possible the comunication between Matlab and Excell in many different ways. I would only like to make saveing. Could you please tell me what should I write/use for that?

请先登录，再进行评论。

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

回答（1 个）

Jan 2021-2-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/733648-is-there-a-way-to-load-data-from-an-excell-file-making-sure-that-this-is-saved#answer_612663

This means, that you use Excel as GUI of Matlab. This is a bold approach. What about proramming the GUI in Matlab directly?

See https://www.mathworks.com/matlabcentral/answers/94822-are-there-any-examples-that-show-how-to-use-the-activex-automation-interface-to-connect-matlab-to-ex

Use "Save" instead of the "Saveas"

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

Jan 2021-2-4

在 MATLAB Online 中打开

See:

doc readtable
doc uitable

Aurea94 2021-2-5

Thanks Jan! I have a problem with readtable, as there are text values inside my excell table and they are not properly loaded into the table created in matlab. How can I make all the data is properly displayed and loaded?

Here excell info: