Got an error when using cell2csv in Matlab 2014b version

5 次查看（过去 30 天）
Simon Wang
Simon Wang 2015-2-23
回答： Simon Wang 2015-2-27
The error message is the following
Undefined function 'cell2csv' for input arguments of type 'cell'.
My Matlab code: cell2csv(fileName, aCellInstance);
Can you help to see if I used it in the wrong way or the function is not available in 2014b.
Thanks!
Simon

请先登录，再回答此问题。

回答（5 个）

Abhishek GS
Abhishek GS 2015-2-24
Simon,
cell2csv is not a MATLAB built in function. But if you want to write a cell array into a comma separated value text, you could use some of the files from MATLAB Central which can be found here , here , here and here .
Konstantinos Sofos
Konstantinos Sofos 2015-2-24
Hi Simon, As Abhishek mentioned cell2csv is not a MATLAB built in function. You can use something from MATLAB file exchange e.g.
function cell2csv(filename,cellArray,delimiter)
% Writes cell array content into a *.csv file.
%
% CELL2CSV(filename,cellArray,delimiter)
%
% filename = Name of the file to save. [ i.e. 'text.csv' ]
% cellarray = Name of the Cell Array where the data is in
% delimiter = seperating sign, normally:',' (it's default)
%
% by Sylvain Fiedler, KA, 2004
% modified by Rob Kohr, Rutgers, 2005 - changed to english and fixed delimiter
if nargin<3
delimiter = ',';
end
datei = fopen(filename,'w'); for z=1:size(cellArray,1) for s=1:size(cellArray,2)
var = eval(['cellArray{z,s}']);
if size(var,1) == 0
var = '';
end
if isnumeric(var) == 1
var = num2str(var);
end
fprintf(datei,var);
if s ~= size(cellArray,2)
fprintf(datei,[delimiter]);
end
end
fprintf(datei,'\n');
end
fclose(datei);
Example:
>> A = rand(5); >> B = num2cell(A); >> cell2csv('dummy.csv',B)
Simon Wang
Simon Wang 2015-2-25
Thank you very much on this. Things worked execpt that if I have a cell array of strings which happen to contain a comma (e.g. "ABC company, inc"), the function split the cell into two fields - "ABC company" and "inc" while I am expecting to have just one field. Any clue on how to resolve it? I believe this is related to the use of below command:
fprintf(datei,var);
Once it sees a comma, it will treat it as a delimiter.
Konstantinos Sofos
Konstantinos Sofos 2015-2-26
Hi Simon,
You could use another delimiter e.g. semicolon (";").
Initially it was to be a comma (CSV-Comma separated values), however as the comma is often used as a decimal point it wouldn't be such good separator, hence others like the semicolon.
i prefer ; since it causes less problems with decimal points, digit grouping and does not appear in much text. In windows it is dependent on the "Regional and Language Options".
Regards
Simon Wang
Simon Wang 2015-2-27
Thanks! It works.

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Identification 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by