mat to xlsx conversion

2 views (last 30 days)
Sugar Mummy
Sugar Mummy on 4 Jan 2022
Answered: laurent jalabert on 5 Jan 2022
Hello everyone! I am trying to convert my .mat file using the following code
data=load('Check.mat');
f=fieldnames(data);
for k=1:size(f,1)
writetable('Check.xlsx',data.(f{k}),f{k})
end
Here I am getting the following error.
Error using writematrix (line 191)
Wrong number of arguments. A filename must be provided when supplying additional parameters, and each parameter name must be followed by a value.
Any help would be highly appreciated. Thanks!
  2 Comments
Rik
Rik on 4 Jan 2022
These are the syntax options:
writematrix(A)
writematrix(A,filename)
writematrix(___,Name,Value)
You are using none of the above.
You should have a read in the optional parameters section. This will probably overwrite your data each pass.
Walter Roberson
Walter Roberson on 4 Jan 2022
'sheetname' is probably needed.

Sign in to comment.

Answers (1)

laurent jalabert
laurent jalabert on 5 Jan 2022
YourArray = [col1;col2;...]; % vectors
varNames_ARR = {'col_1';'col_2';...}; %strings - header of your vector column (do not use space, -, or anything else than _)
Z_MOY_name = 'name';
a=1 ; %sheet number 1
Z_MOY = array2table(YourArray,'VariableNames',varNames_ARR);
writetable(Z_MOY,Z_MOY_name,'Sheet',a); % array, name,'sheet',index

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!