MATLAB: How to change table to 2×1 double for app designer

app designerexcel file input

Hi Everyone,

I am trying to translate my script from the editor to app designer. I am lacking to understand how my data input for MATLAB editor is different from the input for the app designer.

case input is a variable with a value of 2×1 double (my script works with this)
case input would be an excel file uploaded by the user (causes error: Unrecognised function or variable)

The code to upload the excel file is:

[file, path] = uigetfile('*.xlsx');
data = readtable(fullfile(path, file));
app.UITable.Data = data;
data2 = app.UITable.Data

The second case would be a table. The difference in the input files causes an error. I don’t want to change the rest of the script as it is coded for a scatterplot with specified colormaps, it would be a pain to change it again. I am just looking for a way to transform the table into a suitable format.

I am very new to MATLAB and would appreciate any kind of help.

Thanks,

Update: table2array gives me the following error:

Best Answer

Hi Jyotsna Talluri,

I have solved this issue by making 'data' a property and by adding:

app.UITable.Data = app.data;

Thank you for your message. The whole error can be seen in the screenshot, when sliding the window to the right.

It says:

Error using table2array (line 37)

Unable to concatenate the table variables 'Var1' and 'Var2', because their types are cell and double.

Best,

Thi

Related Solutions

MATLAB: Error importing excel table into app designer table

In case of your Journals.csv, you don't need to use table2cell. Just setting a table as a value works.

   x = readtable(fullpath);
   app.UITable.Data = x;
   % Change column name from imported data
   app.UITable.ColumnName = x.Properties.VariableNames;

Result in App Designer.

MATLAB: Piloting graph in app designer

Ok, app.BS is a uitable. app.BS.Data is the information displayed in that uitable.

What I would do, then, is create a property in the app to hold the raw data loaded from BS.txt.

properties (Access = private)
    data % raw data from text file
end

I would add a new variable summing Var2 and Var3 to it (I called it app.data). Then I would plot Var1 vs this new variable.

% Button pushed function: ChooseButton
function ChooseButtonPushed(app, event)
   [filename, pathname] = uigetfile({'*.txt'}, 'File Selector');
   app.data = readtable (fullfile(pathname, filename), 'HeaderLines', 0);
   app.BS.Data = app.data;
   app.BSEditField.Value = filename;
end
% Button pushed function: DisplayButton
function DisplayButtonPushed(app, event)
    app.data.sumVars = app.data.Var2+app.data.Var3;
    plot(app.UIAxes, app.BS.Data.Var1,app.data.sumVars)
end

Best Answer

Related Solutions

MATLAB: Error importing excel table into app designer table

MATLAB: Piloting graph in app designer

Related Question