How to convert .mat to .xls

Please help me out in a detail manner xlswrite command is not working

[Jürgen]

please show the code that you already tried?

[PRABHU SRINIVASAN]

Hi I tried to convert my .mat data to .xls but unable to do it. The .mat file data struct contains huge amount of data i.e the 107968x1 for all the variables. I want to convert it to a .xls can anyone give idea in this regard.

[Walter Roberson]

Xls files are limited to 65535 rows. If you managed to create a file that big then Excel itself would be unable to read it.

You will need to use xlsx

[PRABHU SRINIVASAN]

Can i export my .mat file data to xlsx? Is there any procedure for doing with matlab code? Please advise...

[Walter Roberson]

xlswrite() can write .xlsx files.

If your data is in the form of a table() or timetable() object, then writetable() can write it to .xlsx

[Christine Zarief]

I have an error for converting .mat files into .xlsx files ,I used this code

load('train_subject01.mat')
xlswrite('kokytest.xlsx', train_subject01)

and matlab gives me this error message

Undefined function or variable 'train_subject01'.

so please could anyone help me to solve it ?

Thanks in advance

[Walter Roberson]

Your .mat file train_subject01.mat did not contain a variable named train_subject01 . You should use

whos -file train_subject01.mat

to see the names of the variables in the file.

[Zhibo]

我做了一个matToExcel工具可以在线处理这个问题

MatToExcel

Answer 1

[Azzi Abdelmalek]

 data=load('FileName');
 f=fieldnames(data);
 for k=1:size(f,1)
   xlswrite('FileName.xlsx',data.(f{k}),f{k})
 end

[Farhan]

Thanks for your reply Actually the problem is in my mat file i have many date types like CELL, Structure,character etc.

[Image Analyst]

Doesn't matter. Just make up one big cell array with all your various variables in it, and pass it to xlswrite().

[Albert Yam]

Should still work, Azzi's answer puts everything on it's own sheet.

If you know how you want your excel to look, format into a giant cell (per sheet), ala Image Analyst's answer.

[akrim]

thank you, i have a same problem and this work for me.

[ElizabethR]

i also have the same problem and now it has been solved. thanks!

[shilpa gangarudraiah]

Thankyou ...

[Yassin Mounir]

Thank you the mat file successfully saved as excel sheet

[Heera R Nair]

Thank you so much. It worked

[jd net]

guddddddddddd

[Rebecca Hadley]

Hi,

I used the code provided by Azzi to write a .mat file to .xlsx, but halfway through Matlab provides a warning saying that it will use writecsv instead. To quicken the process, I tried changing the xlswrite to csvwrite (perhaps naively so) and Matlab keeps coming up with the error: 'not a valid attribute or row offset'. What would be the best way to use csvwrite with a pre saved .mat file?

[Hakeem Niyas]

I am getting the below error

Error using xlswrite (line 170)

Input data must be a numeric, cell, or a logical array

[Walter Roberson]

When you see a warning that writecsv will be used instead, then you know that either you are not using MS Windows, or else you are using MS Windows but Excel cannot be found. In such a case you should switch to using writetable() instead if possible.

[Walter Roberson]

xlswrite() cannot be used to write variables of arbitrary datatype to xls or xlsx files. It can only be used to write numeric arrays, or logical arrays, or cell arrays in which each entry is a numeric value, or a logical value, or a character vector (or, these days, a string() scalar).

writetable() can handle some additional datatypes, but some datatypes it will simply leave empty cells for. For example, it will leave empty cells for Control System Toolbox transfer functions, or for symbolic expressions.

[Anthony Santana]

Hi,

I am trying to convert an output mat file which contains 1.5MM rows of numbers to an excel file.Smeone suggested I change it from 3D to 2D first. I tried the following codes and nothing works. Can you fix it?

S=load('QQ_full.mat');

data=S.QQ;

data=reshape(data,size(data,1)*size(data,2),size(data,3));

writetable(S.QQ,data,'Sheet',1,'Range','A1')

Error using writetable (line 248)

Unsupported type 'double'. Use writematrix instead.

Did you mean:

>> writematrix(S.QQ,data,'Sheet',1,'Range','A1')

Error using matlab.io.xml.internal.write.errorIfXML (line 6)

FILENAME must be a non-empty character vector or string scalar.

Error in writematrix (line 196)

fileType = matlab.io.xml.internal.write.errorIfXML(filename, supportedFileTypes, varargin{:});

[Walter Roberson]

S=load('QQ_full.mat');
data=S.QQ;

Okay, at that point S.QQ and data are the same.

data=reshape(data,size(data,1)*size(data,2),size(data,3));

and data gets reshaped so S.QQ and data now have the same content but different shape.

writematrix(S.QQ,data,'Sheet',1,'Range','A1')

You are asking to write out S.QQ, which is the original shape, and you are asking that it be written to a file whos name is stored in data .

You should be using something like

writematrix(data, 'Q_reshaped.xlsx', 'Sheet', 1, 'Range', 'A1')

However...

I am trying to convert an output mat file which contains 1.5MM rows of numbers to an excel file.

You have a problem. The largest file that excel supports is 1048576 rows, and you are creating more rows when you reshape.

The maximum number of columns for excel is 16384, so you would need to use permute() and reshape() to re-arrange your data to have fewer rows but more columns, but still fit within the 2^20 x 2^14 = 2^34 element = 16 giga-element (powers-of-two meaning of "giga" here). If numel(s.QQ) > 2^34 then you have no hope of fitting it into a single excel sheet.

You might want to write sections to different sheets.

What is size(S.QQ) ?

Answer 2

[kinju Prajapati]

how to load my own datset for training and testing....

nprtool only respond inbuilt or example dataset..not my dataset,,,,

[Walter Roberson]

How are your datasets represented? nprtool permits you to indicate which variable to use, or if you use the '...' button to the right of that, you can select a text file or .mat file to read data from.

[arun anoop m]

This code working fine(mat to xls).

[Abhishek]

Hi @arun anoop m, can you show me how to transfer all data dictionary data to excel ?

[Walter Roberson]

@Abhishek

I am not clear whether you are referring to a Simulink Data Dictionary https://www.mathworks.com/help/simulink/slref/simulink.data.dictionary.html or if you are referring to the releative new dictionary mapping object?