my data in excel keep overwriting

Question

Jonatan Morisson 2017-10-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364066-my-data-in-excel-keep-overwriting

评论： Jan 2017-11-2

hi guys this is my code

function GLCM()
directory = 'C:\Users\Jonatan Morisson\Desktop\Skhrip-shi\data\Fixed Data\Aseman';
files = dir([directory '\*.jpg']);
    for x = 1:10
      image{x} = imread([directory '\' files(x).name]);
        image{x} = rgb2gray(image{x});
        g1{x} = graycomatrix(image{x}, 'Offset', [-1 1]);
        s1{x} = graycoprops (g1{x});
        %c{x} = struct2cell(s1{x});
        %xlswrite('name.xlsx', c{x);
        xlFilename = 'C:\Program Files\MATLAB\MATLAB\bin\aaaa.xlsx';
        xlRange = strcat(strcat(strcat('A',int2str(x+1)),':'),strcat('E',int2str(x+1)));
        writetable(struct2table(s1{x}),xlFilename);
        %xlswrite(xlFilename,struct2cell(s1{x}),'Sheet 1',xlRange);
        disp (s1{x})
    end
end

but my excel just like this :

can someone help me?? much thanks !!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2017-10-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364066-my-data-in-excel-keep-overwriting#answer_288489

编辑：Jan 2017-10-30

在 MATLAB Online 中打开

We see the working code and the output, which is created exactly how the code does define it. To help you, we need an explanation what you want instead. Perhaps you want to use the range as in the commented code using xlsread?

writetable(struct2table(s1{x}), xlFilename, 'Range', xlRange);

What about creating a table with all results at first and write them at once after the loops? This is more elegant and probably faster.

2 个评论
显示无隐藏无

Jonatan Morisson 2017-10-31

在 MATLAB Online 中打开

sir i already got the answer,

writetable(struct2table(s1{x}), xlFilename,'Range', xlRange,'WriteVariableNames',0);

it always bring its row variable name now it works like a charm,

but sir can i ask one more question? can i put the name of the image file in the E1-E10 as the name of the feature? i already do another writetable with the files(x).name as the table but it got me error "Undefined function 'write' for input arguments of type 'char'." can u help me sir?

Jan 2017-11-2

Please post the failing line. "Undefined function 'write' for input arguments of type 'char'" sounds like you have written "write" instead of "writetable".

请先登录，再进行评论。