Wednesday, 15 June 2011

Matlab: get numeric values from table -


I am importing one sheet from matlab to Excel using the "readtable" command:

  table = readable (Excel.FN, 'Sheet', Excel.Sheet);  

The table contains both numeric values ​​and strings. If I try to use numerical values, then I can not get them twice

  table {j, i} = '0.00069807'  

is still a cell

  cell 2 enum ( Table {j, i}} = nan cell 2 matte (table {j, i}) = 0.00069807,  

but it is a four. So I use

  str2num (cell2mat (table {j, i}))  

to get numerical value. An easy way should be you can please tell me the command.

If you do not insist on readtable , xlsread < / Code> will be better for you Loaded data is "matlab-friendly" with this function.

I'm not sure whether there is a simple solution with readtable I think that this is the only value you can call "raw" data such as CSV or Do not work with ordinary text files to pay.


No comments:

Post a Comment