A table variable name subscript must be a character vector
显示 更早的评论
What does my error mean? i am trying to upload a ".xls" file using "add button"and transfer the data into a table and "add button" will calculate for stress and strain and plot in UI.axes
% Button pushed function: AddButton
function AddButtonPushed(app, event)
strain = app.StrainEditField.Value;
stress = app.StressEditField.Value;
nr = {strain, stress};
app.UITable.Data = [app.t;nr];
end
% Button pushed function: PlotButton
function PlotButtonPushed(app, event)
app.t = readtable('BlankSheet.xlsx','Sheet',1);
strain = table2array(app.t(:,"")); %A table variable name subscript must be a character vector, string array, or cell array of character vectors.
stress = table2array(app.t(:,""));
plot(app.UIAxes,strain,stress);
end
end
采纳的回答
Ameer Hamza
2020-4-30
You need to write the name of column
strain = table2array(app.t(:,"strain_column_name")); %A table variable name subscript must be a character vector, string array, or cell array of character vectors.
stress = table2array(app.t(:,"stress_column_name"));
Also, you can avoid table2array to array by using brace indexing
strain = app.t{:,"strain_column_name"}; %A table variable name subscript must be a character vector, string array, or cell array of character vectors.
stress = app.t{:,"stress_column_name"};
4 个评论
sydney salvador
2020-5-1
编辑：sydney salvador
2020-5-1
Ameer Hamza
2020-5-1
编辑：Ameer Hamza
2020-5-1
sydney, columns in MATLAB tables must have a name. If you don't specify, then still MATLAB gives them a default name. For example, when I run these lines using your file
t = readtable('BlankSheet.xlsx','Sheet',1);
disp(t)
Var1 Var2
____ ____
0 2
5 2
6 4
The column names are Var1 and Var2. If the column had names in excel files, then MATLAB would have used those names. So to access the first Var1 column, you need to write it like this
strain = t{:,"Var1"};
stress = t{:,"Var2"};
You can also directly use the column number if you are confused about the name of column
strain = t{:,1};
stress = t{:,2};
Walter Roberson
2020-5-1
t{:, 2} for stress
Ameer Hamza
2020-5-1
Thanks for pointing out.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Stress and Strain 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
