MATLAB: How to convert this .mat file to .xls or.dat file

.mat to .datxls

here is my dataset of a 3X2 array

Best Answer

Your .mat file contains a 3x2 cell array, each cell of which contains a 1x9 numeric array: this data cannot be saved in a 2D array file format such as a text file or an Excel file. To save in a 2D array file format (i.e. a text file or Excel file) you will need to have a cell array containing scalar values, or use a numeric array, or use some format that encodes nested data (this is not trivial). Here I used cell2mat to form one 3x18 numeric array, which can easily be saved in a text file or an Excel file:

>> S = load('20-8-2018.mat');
>> M = cell2mat(S.feature_vec);
>> csvwrite('output.dat',M) % to make a text file
>> xlswrite('output.xls',M) % to make an Excel file

Related Solutions

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

MATLAB: Xlswrite not writing few entries

From

doc xlswrite
...
Input Arguments
...
A — Data to writematrix | cell array
Data to write, specified as a two-dimensional numeric or character array, or, if each cell
contains a single element, a cell array.
If A is a cell array containing something other than a scalar numeric or a string, 
then xlswrite silently leaves the corresponding cell in the spreadsheet empty.

It seems there must be that there's something not meeting that criterion in the cell array.

Best Answer

Related Solutions

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

MATLAB: Xlswrite not writing few entries

Related Question