MATLAB: Xlswrite

xlswrite cell arrays

Hi,

I am trying to write a cell array (1718×142 cell) back to xls. Neither xlswrite command nor a simple manual copy paste works. I think my problem is that the cell array itself is composed of individual single cell arrays of short strings or empty cell. I would like to have an advise how to convert to a single layer cell array that I can then copy to xls.

Thank you in advance

Best Answer

If the entries in your cell array are indeed 1x1 cells of strings or empty cells, try to convert each cell entry to a string: xConverted = cellfun(@char, xOriginal, 'Uniformoutput', false);

Titus

Related Solutions

MATLAB: Manipulation of a cell array-

Cell_array = {1,[],magic(2);'stirng',[],[]}
cellfun('isempty',Cell_array)

MATLAB: Can I write a cell array containing matrices into multiple cells of a Microsoft Excel file using XLSWRITE in MATLAB 7.x(R14SP2+)

The ability to write cell arrays that contain matrices and strings in a single XLSWRITE command is not available. XLSWRITE works with matrices that are not contained in cell arrays, and with cell arrays that combine scalars (single numbers) and strings, but not with cell arrays that contain matrices or vectors.

To work around this issue, you can either convert your data in MATLAB to a single cell array in this format, or you can issue multiple commands to XLSWRITE, each specifying a sheet and location.

In the example shown in this problem report, you can write the data to a single spreadsheet with the following two commands:

xlswrite('xlsexample.xls',a{1},'Sheet1','A1');
xlswrite('xlsexample.xls',a{2},'Sheet1','A3');

Also, if all of the data in the cell array is numeric, of the same type, and of appropriate sizes, you may be able to convert the cell array to a matrix using the CELL2MAT function. To see the documentation on CELL2MAT, including a description of the limitations on the input cell array, type:

doc cell2mat

Best Answer

Related Solutions

MATLAB: Manipulation of a cell array-

MATLAB: Can I write a cell array containing matrices into multiple cells of a Microsoft Excel file using XLSWRITE in MATLAB 7.x(R14SP2+)

Related Question