'σ' is not a valid table variable name.

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.

Answer 1

[Guillaume]

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')

[Knut Jørgen]

I will try it thanks.