'σ' is not a valid table variable name.
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Guillaume
2019-8-16
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')
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!