mat to xlsx conversion

Question

Sugar Mummy 2022-1-4

回答： laurent jalabert 2022-1-5

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!

Rik 2022-1-4

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 2022-1-4

'sheetname' is probably needed.

Answer 1

laurent jalabert 2022-1-5

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