MATLAB: Csvwrite with a double

csvwritedouble

Hello I am having a great deal of difficulty writing a 512 x 1 cell array of type double in a .MAT file to excel I tried this:

exportlist = get(handles.listbox2,'string')

%we need to change the directory to the chosen output and after we have %re-loaded the .mat file into the workspace convert the files %The evalin evaluates the expression in 'base' or workspace

for a = 1:length(exportlist) outloc =get(handles.CSV_file, 'string'); cdstring = ['cd(''' outloc ''')']; eval(cdstring); csvwrite([exportlist{a},'.csv'],evalin('base',cell2mat(exportlist{a})))

end

No dice. The error I get is this:

??? Cell contents reference from a non-cell array object.

Error in ==> cell2mat at 44 cellclass = class(c{1});

Error in ==> MAT_to_Csv>convert_button_Callback at 319 csvwrite([exportlist{a},'.csv'],evalin('base',cell2mat(exportlist{a})))

Thanks

Bill

Best Answer

No. Your line probably should be:

csvwrite([exportlist{a},'.csv'],evalin('base',exportlist{a}))

Read my answer to your other question. I think you should really consider the dynamic field names like Vars.(exportlist{a}) to avoid using eval().

Your eval(cdstring) could be replaced by cd(outloc)

Related Solutions

MATLAB: CSV convert will not work with string file name

Your code can be considerably simplified. Yes, I know the below code is much longer, but I added a lot of error checking; the heart of the code is small and efficient.

olddir = cd;
outloc = get(handles.CSV_file, 'string');
try
  cd(outloc);
catch
  error(sprintf('failed to cd to %s', outloc));
end
filelocation= get(handles.MAT_file, 'string');
try  
  S = load(filelocation);
catch
  error(sprintf('failed to load file %s', filelocation));
end
for a = 1:length(exportlist)
  v = exportlist{a};
  if isfield(S, v)
    finaltag = [filelocation, v, '.csv'];
    try
      csvwrite([finaltag,'.csv'],S.(v));
    catch
      warning(sprintf('was unable to write variable %s to file %s', v, finaltag));
    end
  else
    warning(sprintf('input file %s does not contain variable %s, csv not written for variable', filelocation, v))
  end
end
cd(olddir)

MATLAB: CSVWRITE from listbox

Use eval() or evalin() to get the data from a string representing the variable name. You probably should also include '.csv' in your csv file name. In your example, a is probably a cell array of string, so you should do:

csvwrite([a{1},'.csv'],eval(a{1}))
or
csvwrite([a{1},'.csv'],evalin('base',a{1}))

Considering your previous question, I assume you want to write certain variables in a .mat file to a .csv file, using a GUI for the user to pick and choose the variables. In your call-back function, you can use Vars=load('MyData.mat') to load the data. All the variables will be put in the fields of the structure data Vars. Use VariableNames=fieldnames(Var) to get the list of variable names and use it for your list box. Once you get the chosen variable name in a{1} as shown in your example, Vars.(a{1}) is the data you want to write to your .csv file. Try this at Command line to understand and get familiar with the syntax and then implement it in your code. That way, you can avoid using the eval() function.

Best Answer

Related Solutions

MATLAB: CSV convert will not work with string file name

MATLAB: CSVWRITE from listbox

Related Question