loop for excel in MATLAB

Question

Samer Husam 2012-6-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/40514-loop-for-excel-in-matlab

hi all, I want to save values from MATLAB to excel so I want to write a loop to check if the cell has a value or not, for example: lets consider the column (B) I want the matlab to start checking from B4 which one is empty cell to save the new values in it, how this can be done ?? looking for your help please.

2 个评论
显示无隐藏无

per isakson 2012-6-7

Did you look in the Matlab on-line help?

Samer Husam 2012-6-7

I tried to, but couldn't find the way to do it,

actually i could write the code for the loop in order to check the value for a cell.

any suggestions please ?

请先登录，再进行评论。

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

Answer 1

Samer Husam 2012-6-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/40514-loop-for-excel-in-matlab#answer_50277

在 MATLAB Online 中打开

thanks all for your help, but I can't make this work cause its not really clear to me.. so, is there another way to do it ? for example: for column B in (excel) write loop program to check if the cell has value or not ?

%------a:is the variable to save------
for i=5
xlsread(('G:\\MATLAB Examples\Data_sheet.xlsx','Sheet1','B%i','value')==1;
i+1;
end
xlswrite(G:\\MATLAB Examples\Data_sheet.xlsx',a,'Sheet1','B%i,)

can something like this to be done between matlab and excel ??

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

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2012-6-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/40514-loop-for-excel-in-matlab#answer_50199

在 MATLAB Online 中打开

one way

[nt,nt,nt] = xlsread('nameyour.xlsx');
nt(cellfun(@isnan,nt)) = {256};
xlswrite('nameyour.xlsx',nt)

ON Samer's reply

eg, data:

xlswrite('Data_sheet.xlsx',[1;8;1;6;1],'B1:B5')

solution

a = 100;
[n,t,nt] = xlsread('Data_sheet.xlsx','B1:B5');
n(n == 1) = a;
xlswrite('Data_sheet.xlsx',n,'B1:B5')

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

Image Analyst 2012-6-8

He's setting those Excel cells (which are now in a MATLAB cell array called nt) that are not numbers to have the new value of 256. You can change the 256 to whatever number you want. Then it writes if back out to the same file. If you want just some submatrix (like B4..F42), then you'd have to extract that submatrix before running andrei's code on just that submatrix. Then insert the submatrix back into the full matrix and write out the full matrix.