MATLAB: Xlswrite not saving too an Excel file

excelfilexlswrite

Hi guys, Iam having problem saving my results from a code as an excel file, it does comes up as an unregistered 02 file that cant be opened by excel though I am wondering if anyone has had similar problems?

Best Answer

I speculate that the filename you are passing to xlswrite ends in '.02' and that you are expecting xlswrite to add on a .xls or .xlsx extension to that. xlswrite() only automatically adds on extensions if there are no '.' in the file portion of the name (that is, excluding any directory)

Related Solutions

MATLAB: Xlswrite to create file with xlsx extension

xlswrite('file.xls',Your_data)

MATLAB: Putting columns from an array into evenly spaced columns in excel

You could always write it in a loop, e.g. using the char-int conversion.

As an alternative: instead of writing a matrix, you can write a cell array. This allows you to leave certain cells and columns empty. Here is an example:

Tresult = randn(5,10);
% write settings
filename1 = 'hProfile';
start_cell = 'C1';  % starting cell
Sheet = 1;          % sheet number
skip_col = 1;       % number of empty columns between entries
% transform into cell and insert empty columns
Nrows = size(Tresult,1);
Ncols = size(Tresult,2);
Tresult_cell = cell(Nrows,(1+skip_col)*Ncols);
Tresult_cell(:,1:(1+skip_col):end) = num2cell(Tresult);
% write file
xlswrite(filename1,Tresult_cell,Sheet,start_cell);

! Note that this will overwrite whatever was in your excel file before, i.e. the "empty" cells will also be written, but they will just be empty.

Cheers

Best Answer

Related Solutions

MATLAB: Xlswrite to create file with xlsx extension

MATLAB: Putting columns from an array into evenly spaced columns in excel

Related Question