Converting Cell to Double
显示 更早的评论
Hi everybody! i have a matrix named as data having n X 1 cell-elements, which comes from a text file. I am trying to convert its numeric elements to double type in order to export it as a excel file.
e.g.
data(3,1) = '0.0500 0.1236 36.00 0.00 1.00 -0.0000 0.0000 0.3337 30 30'
Its aimed to save any single value(for example 0.0500) seperately in a single array in excel output. Any suggestion? tnx
采纳的回答
There may be a better way to import the text file so the data is automatically read in as numeric values. Try using the Import Data button on the Home menu and see if you can change the settings for the data to be read in how you would like.
Post a couple lines of text file and I may be able to identify the best way to read it in.
If that doesn't work this is a way to reformat the data.
You could use regexp to split the string or the function strsplit. This will give you a cell array of the values you can then to convert to a numeric array after removing and empty values.
% split the string
sepVals = regexp(data{3, 1}, ' ', 'split');
% remove empties
sepVals = sepVals(~cellfun(@isempty, sepVals ));
% convert to numbers
numbers = str2double(sepVals);
You can then use xlswrite to write the array numbers to an excel sheet.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Translated by 
