saving the data in excel

Question

phani 2012-6-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/41133-saving-the-data-in-excel

hi all, i am having a 50 files in which every time i want to read a single file and perform some operations on the data and i get an output of 13x1 matrix i want to save this data in an excel file in sheet 1( i can use xlswrite options), when i am reading the second file it has to store output in sheet 2 automatilcally how can i do this?. i want to run this in a for loop. how to save the each output in different sheet. someone please help me. thanks in advacne.

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

请先登录，再进行评论。

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

Answer 1

Ilham Hardy 2012-6-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/41133-saving-the-data-in-excel#answer_50705

在 MATLAB Online 中打开

Hi,

you can define sheet name on the xlswrite function.

xlswrite(filename, M, sheet)

I can imagine that you can put the integer as (a part of) sheet name

add

warning off MATLAB:xlswrite:AddSheet

to supress addsheet warning

HTH,

IH

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

phani 2012-6-14

hi, thanks for your reply, i don't want to add the sheet number manually every time, i want it to happen in the loop . i am providing the code below

for i=1:1:24

fname='figure';

ext='.png';

fnamer=sprintf('%s %d%s',fname,i,ext);

I=imread(fnamer);

a=rgb2gray(I);

end

% i want to perform some mathematical operations on matrix 'a' , which gives me an output of 13x1 matrix and i want to save this in sheet1 in a excel file. when i value increments to 2 again it will give me a 13x1 matrix as output and i want to save this in sheet2 of the same excel file and as the loop progress i want it to save in the appending sheets.

thank you .

请先登录，再进行评论。