Variable Names not being read into uitable using readmatrix
Hi, I am trying to read a csv files into a uitable and am having problems reading the variable names in. The csv was saved using writetable and the first few lines are here:
Idx,pos,sep1,sep2,avgsep,deltaPix
1,101.1,1799.918,1868.078,1833.998,0.769999999999
2,101.2,1801.527,1868.695,1835.111,1.88299999999
3,101.3,1802.028,1869.09,1835.559,2.3309999999
4,101.4,1801.645,1869.739,1835.692,2.46399999999
5,101.5,1802.023,1869.453,1835.738,2.50999999999
This is my code to read the file :
table=app.UItable;
C=readtable(fullpath,’VariableNamingRule’,’preserve’,’FileType’,’text’);
C=table2array(C); % Wasn’t sure if I needed this
opts = detectImportOptions(fullpath)
opts.VariableNames
ReportMessage(app,’Opened Successfully’)
table.Data=C;
Its not reading in the variable name
The opts.variablenames is showing the variable names are present
ans =
1×6 cell array
{‘Idx’} {‘pos’} {‘sep1’} {‘sep2’} {‘avgsep’} {‘deltaPix’}
and opts is:
opts =
DelimitedTextImportOptions with properties:
Format Properties:
Delimiter: {‘,’}
Whitespace: ‘bt ‘
LineEnding: {‘n’ ‘r’ ‘rn’}
CommentStyle: {}
ConsecutiveDelimitersRule: ‘split’
LeadingDelimitersRule: ‘keep’
TrailingDelimitersRule: ‘ignore’
EmptyLineRule: ‘skip’
Encoding: ‘UTF-8’
Replacement Properties:
MissingRule: ‘fill’
ImportErrorRule: ‘fill’
ExtraColumnsRule: ‘addvars’
Variable Import Properties: Set types by name using setvartype
VariableNames: {‘Idx’, ‘pos’, ‘sep1’ … and 3 more}
VariableTypes: {‘double’, ‘double’, ‘double’ … and 3 more}
SelectedVariableNames: {‘Idx’, ‘pos’, ‘sep1’ … and 3 more}
VariableOptions: Show all 6 VariableOptions
Access VariableOptions sub-properties using setvaropts/getvaropts
VariableNamingRule: ‘modify’
Any reason why the variable names aren’t being populated into the uitable?
ThanksHi, I am trying to read a csv files into a uitable and am having problems reading the variable names in. The csv was saved using writetable and the first few lines are here:
Idx,pos,sep1,sep2,avgsep,deltaPix
1,101.1,1799.918,1868.078,1833.998,0.769999999999
2,101.2,1801.527,1868.695,1835.111,1.88299999999
3,101.3,1802.028,1869.09,1835.559,2.3309999999
4,101.4,1801.645,1869.739,1835.692,2.46399999999
5,101.5,1802.023,1869.453,1835.738,2.50999999999
This is my code to read the file :
table=app.UItable;
C=readtable(fullpath,’VariableNamingRule’,’preserve’,’FileType’,’text’);
C=table2array(C); % Wasn’t sure if I needed this
opts = detectImportOptions(fullpath)
opts.VariableNames
ReportMessage(app,’Opened Successfully’)
table.Data=C;
Its not reading in the variable name
The opts.variablenames is showing the variable names are present
ans =
1×6 cell array
{‘Idx’} {‘pos’} {‘sep1’} {‘sep2’} {‘avgsep’} {‘deltaPix’}
and opts is:
opts =
DelimitedTextImportOptions with properties:
Format Properties:
Delimiter: {‘,’}
Whitespace: ‘bt ‘
LineEnding: {‘n’ ‘r’ ‘rn’}
CommentStyle: {}
ConsecutiveDelimitersRule: ‘split’
LeadingDelimitersRule: ‘keep’
TrailingDelimitersRule: ‘ignore’
EmptyLineRule: ‘skip’
Encoding: ‘UTF-8’
Replacement Properties:
MissingRule: ‘fill’
ImportErrorRule: ‘fill’
ExtraColumnsRule: ‘addvars’
Variable Import Properties: Set types by name using setvartype
VariableNames: {‘Idx’, ‘pos’, ‘sep1’ … and 3 more}
VariableTypes: {‘double’, ‘double’, ‘double’ … and 3 more}
SelectedVariableNames: {‘Idx’, ‘pos’, ‘sep1’ … and 3 more}
VariableOptions: Show all 6 VariableOptions
Access VariableOptions sub-properties using setvaropts/getvaropts
VariableNamingRule: ‘modify’
Any reason why the variable names aren’t being populated into the uitable?
Thanks Hi, I am trying to read a csv files into a uitable and am having problems reading the variable names in. The csv was saved using writetable and the first few lines are here:
Idx,pos,sep1,sep2,avgsep,deltaPix
1,101.1,1799.918,1868.078,1833.998,0.769999999999
2,101.2,1801.527,1868.695,1835.111,1.88299999999
3,101.3,1802.028,1869.09,1835.559,2.3309999999
4,101.4,1801.645,1869.739,1835.692,2.46399999999
5,101.5,1802.023,1869.453,1835.738,2.50999999999
This is my code to read the file :
table=app.UItable;
C=readtable(fullpath,’VariableNamingRule’,’preserve’,’FileType’,’text’);
C=table2array(C); % Wasn’t sure if I needed this
opts = detectImportOptions(fullpath)
opts.VariableNames
ReportMessage(app,’Opened Successfully’)
table.Data=C;
Its not reading in the variable name
The opts.variablenames is showing the variable names are present
ans =
1×6 cell array
{‘Idx’} {‘pos’} {‘sep1’} {‘sep2’} {‘avgsep’} {‘deltaPix’}
and opts is:
opts =
DelimitedTextImportOptions with properties:
Format Properties:
Delimiter: {‘,’}
Whitespace: ‘bt ‘
LineEnding: {‘n’ ‘r’ ‘rn’}
CommentStyle: {}
ConsecutiveDelimitersRule: ‘split’
LeadingDelimitersRule: ‘keep’
TrailingDelimitersRule: ‘ignore’
EmptyLineRule: ‘skip’
Encoding: ‘UTF-8’
Replacement Properties:
MissingRule: ‘fill’
ImportErrorRule: ‘fill’
ExtraColumnsRule: ‘addvars’
Variable Import Properties: Set types by name using setvartype
VariableNames: {‘Idx’, ‘pos’, ‘sep1’ … and 3 more}
VariableTypes: {‘double’, ‘double’, ‘double’ … and 3 more}
SelectedVariableNames: {‘Idx’, ‘pos’, ‘sep1’ … and 3 more}
VariableOptions: Show all 6 VariableOptions
Access VariableOptions sub-properties using setvaropts/getvaropts
VariableNamingRule: ‘modify’
Any reason why the variable names aren’t being populated into the uitable?
Thanks readmatrix, uitable, variablenames MATLAB Answers — New Questions
