'σ' is not a valid table variable name.

2 views (last 30 days)
I got this error when I wants to use 'σ' as variable name, is not a valid table variable name.
I have used these commands as I do no have excel on my Linux pc.
tbl = array2table(TABLE);
writetable(tbl,'TABLE.xls')
This works but I get this as headers
TABLE1 TABLE2 TABLE3 TABLE4 TABLE5 TABLE6 TABLE7 TABLE8 TABLE9 TABLE10 TABLE11
not this
{'information'} {'EER'} {'σ'}
But if I change the variable name to this {'information'} {'EER'} {'σ'} I get this error
'σ' is not a valid table variable name.
How can I use 'σ' as variable name as this is possible in windows with excel and xlswrite.

Accepted Answer

Guillaume
Guillaume on 16 Aug 2019
The problem is not excel but matlab, which currently only allows valid matlab variable names as table variables. For the moment, the only workaround is to convert your table to a cell array and append the header with whatever you want as the first row of the cell array. Assuming, R209a, you can then use writecell. In earlier versions, xlswrite.
c = table2cell(yourtable);
writecell([{'Information', 'EER', 'σ', 'morenames'}; c], 'C:\somewhere\somefile.xlsx')

More Answers (0)

Products


Release

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!