'σ' is not a valid table variable name.
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Knut Jørgen
am 16 Aug. 2019
Kommentiert: Knut Jørgen
am 19 Aug. 2019
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.
0 Kommentare
Akzeptierte Antwort
Guillaume
am 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')
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!