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

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.

[Walter Roberson]

Windows with Excel installed? If so then maybe you could use ActiveX to command that the data be saved.

[Aurea94]

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

[Aurea94]

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?

Answer 1

[Jan]

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"

See also: https://www.mathworks.com/help/matlab/matlab_external/example-reading-excel-spreadsheet-data.html

[Aurea94]

Yes tha's true. However, I have several cases and each of the cases has 20 properties so I prefer having each case in an Excell column and choosing the column I want instead of typing each time the properties in a Matlab GUI.

[Aurea94]

I looked at the demo in the link you proposed, however from what I understood that code is to create an excell file from Matlab, operate with it and save it.

However, what I only want to do is open a specific ecell file, whch is already full of the desired values and SAVE it, before loading the data to Matlab workspace.

I tried:

DataFile = strcat(pwd,'\InputDataSpline.xlsx');
Excel = actxserver('Excel.Application');  
invoke(Excel.ActiveWorkbook,'Save');

However I got the error:

Check for missing argument or incorrect argument data type in call to function 'invoke'.

Error in GenSpline_v14 (line 62)
invoke(Excel.ActiveWorkbook,'Save');

[Jan]

I tried some methods also. Whenever I've edited an Excel file, which was opened by Matlab, I cannot access the methods anymore due to the error: "Error: Call was rejected by callee."

What about importing the data and displaying them in a uitable object? There you do not need the complex interaction between Excel and Matlab.

[Aurea94]

Perhaps it is the option, but I have no idea how to do that. Could you send any link?

[Jan]

See:

doc readtable
doc uitable

[Aurea94]

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: