Converting Cell to Double
3 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
Justin
2014-5-5
编辑:Justin
2014-5-5
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.
3 个评论
Justin
2014-5-5
Is your data variable a cell array of strings?
Perhaps try using data(3, 1) or data{3, 1}? What is in the sepVals variable?
更多回答(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!