Issues with tables and writetable from data passed from uitable
Hello, I have an array in a uitable that I want to save to a csv file as well as the column headings. It seems out of the write options available (writecell,writematrix, writetable) – it is only writetable that allows this
Writetable appears to work, but when I open the CSV file it hasn’t and I can’t understand why
This is my code:
T=app.UITable;
data=T.Data;
C=array2table(data); % Create table format
T.ColumnName
C.Properties.VariableNames=T.ColumnName;
C.Properties.Description=’Scan Profile’;
C = addprop(C,{‘ScanStart’,’ScanTime’},{‘table’,’table’});
C.Properties.CustomProperties.ScanStart = app.scannow;
C.Properties.CustomProperties.ScanTime = app.scantime;
C.Properties
% C.Properties.VariableNames
writetable(C,savepath);
ReportMessage(app,’ Data Saved Using Writetable’);
And in the command window I get this, indicating all is O.K
ans =
6×1 cell array
{‘Idx’ }
{‘YPos(mm)’}
{‘Sep1’ }
{‘Sep2’ }
{‘<Sep>’ }
{‘dpixel’ }
ans =
TableProperties with properties:
Description: ‘Surface Profile’
UserData: []
DimensionNames: {‘Row’ ‘Variables’}
VariableNames: {‘Idx’ ‘YPos(mm)’ ‘Sep1’ ‘Sep2’ ‘<Sep>’ ‘dpixel’}
VariableDescriptions: {}
VariableUnits: {}
VariableContinuity: []
RowNames: {}
Custom Properties (access using t.Properties.CustomProperties.<name>):
ScanStart: "29-Jan-2025 09:41:35"
ScanTime: ‘174.2796’
But then the file looks like this:
So no headings.
And When i also try to load via readtable – all of the description and custom propeerrties are not present
ans =
TableProperties with properties:
Description: ”
UserData: []
DimensionNames: {‘Row’ ‘Variables’}
VariableNames: {‘Var1’ ‘Var2’ ‘Var3’ ‘Var4’ ‘Var5’ ‘Var6’}
VariableDescriptions: {}
VariableUnits: {}
VariableContinuity: []
RowNames: {}
CustomProperties: No custom properties are set.
Use addprop and rmprop to modify CustomProperties.Hello, I have an array in a uitable that I want to save to a csv file as well as the column headings. It seems out of the write options available (writecell,writematrix, writetable) – it is only writetable that allows this
Writetable appears to work, but when I open the CSV file it hasn’t and I can’t understand why
This is my code:
T=app.UITable;
data=T.Data;
C=array2table(data); % Create table format
T.ColumnName
C.Properties.VariableNames=T.ColumnName;
C.Properties.Description=’Scan Profile’;
C = addprop(C,{‘ScanStart’,’ScanTime’},{‘table’,’table’});
C.Properties.CustomProperties.ScanStart = app.scannow;
C.Properties.CustomProperties.ScanTime = app.scantime;
C.Properties
% C.Properties.VariableNames
writetable(C,savepath);
ReportMessage(app,’ Data Saved Using Writetable’);
And in the command window I get this, indicating all is O.K
ans =
6×1 cell array
{‘Idx’ }
{‘YPos(mm)’}
{‘Sep1’ }
{‘Sep2’ }
{‘<Sep>’ }
{‘dpixel’ }
ans =
TableProperties with properties:
Description: ‘Surface Profile’
UserData: []
DimensionNames: {‘Row’ ‘Variables’}
VariableNames: {‘Idx’ ‘YPos(mm)’ ‘Sep1’ ‘Sep2’ ‘<Sep>’ ‘dpixel’}
VariableDescriptions: {}
VariableUnits: {}
VariableContinuity: []
RowNames: {}
Custom Properties (access using t.Properties.CustomProperties.<name>):
ScanStart: "29-Jan-2025 09:41:35"
ScanTime: ‘174.2796’
But then the file looks like this:
So no headings.
And When i also try to load via readtable – all of the description and custom propeerrties are not present
ans =
TableProperties with properties:
Description: ”
UserData: []
DimensionNames: {‘Row’ ‘Variables’}
VariableNames: {‘Var1’ ‘Var2’ ‘Var3’ ‘Var4’ ‘Var5’ ‘Var6’}
VariableDescriptions: {}
VariableUnits: {}
VariableContinuity: []
RowNames: {}
CustomProperties: No custom properties are set.
Use addprop and rmprop to modify CustomProperties. Hello, I have an array in a uitable that I want to save to a csv file as well as the column headings. It seems out of the write options available (writecell,writematrix, writetable) – it is only writetable that allows this
Writetable appears to work, but when I open the CSV file it hasn’t and I can’t understand why
This is my code:
T=app.UITable;
data=T.Data;
C=array2table(data); % Create table format
T.ColumnName
C.Properties.VariableNames=T.ColumnName;
C.Properties.Description=’Scan Profile’;
C = addprop(C,{‘ScanStart’,’ScanTime’},{‘table’,’table’});
C.Properties.CustomProperties.ScanStart = app.scannow;
C.Properties.CustomProperties.ScanTime = app.scantime;
C.Properties
% C.Properties.VariableNames
writetable(C,savepath);
ReportMessage(app,’ Data Saved Using Writetable’);
And in the command window I get this, indicating all is O.K
ans =
6×1 cell array
{‘Idx’ }
{‘YPos(mm)’}
{‘Sep1’ }
{‘Sep2’ }
{‘<Sep>’ }
{‘dpixel’ }
ans =
TableProperties with properties:
Description: ‘Surface Profile’
UserData: []
DimensionNames: {‘Row’ ‘Variables’}
VariableNames: {‘Idx’ ‘YPos(mm)’ ‘Sep1’ ‘Sep2’ ‘<Sep>’ ‘dpixel’}
VariableDescriptions: {}
VariableUnits: {}
VariableContinuity: []
RowNames: {}
Custom Properties (access using t.Properties.CustomProperties.<name>):
ScanStart: "29-Jan-2025 09:41:35"
ScanTime: ‘174.2796’
But then the file looks like this:
So no headings.
And When i also try to load via readtable – all of the description and custom propeerrties are not present
ans =
TableProperties with properties:
Description: ”
UserData: []
DimensionNames: {‘Row’ ‘Variables’}
VariableNames: {‘Var1’ ‘Var2’ ‘Var3’ ‘Var4’ ‘Var5’ ‘Var6’}
VariableDescriptions: {}
VariableUnits: {}
VariableContinuity: []
RowNames: {}
CustomProperties: No custom properties are set.
Use addprop and rmprop to modify CustomProperties. writetable, uitable MATLAB Answers — New Questions
