MATLAB Answers

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

1 ビュー (過去 30 日間)
Aurea94 2021 年 2 月 2 日
コメント済み: 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 件のコメント
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 日
This means, that you use Excel as GUI of Matlab. This is a bold approach. What about proramming the GUI in Matlab directly?
Use "Save" instead of the "Saveas"
  6 件のコメント
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:
Here the uitable generated in matlab:





Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by