How i can write array cell to excel sheet using loops?

Question

ahmad Al sarairah 2019-6-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465249-how-i-can-write-array-cell-to-excel-sheet-using-loops

回答： Murugan C 2019-6-3

I am trying to write cell array contents from matlab to excel sheet , the cell array is (1x4) cell .

The first cell({1,1}) contains a string (glcm11) ,and the second cell({1,2}) contains (glcm12) ,the third cell({1,3}) contain (glcm13) , and the fourth cell is (glcm14) .

How i can write these cells to excel sheet using loops to range (a2:a5)?

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

请先登录，再进行评论。

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

Answer 1

Raj 2019-6-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465249-how-i-can-write-array-cell-to-excel-sheet-using-loops#answer_377587

在 MATLAB Online 中打开

What is the issue? Is this what you are looking for:

a{1,1}='glcm11';
a{1,2}='glcm12';
a{1,3}='glcm13';
a{1,4}='glcm14';
xlswrite('test.xls',a,'A2:A5')

"How i can write these cells to excel sheet using loops to range (a2:a5)" - What is the need to use loops?

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

请先登录，再进行评论。

Answer 2

Murugan C 2019-6-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465249-how-i-can-write-array-cell-to-excel-sheet-using-loops#answer_377589

在 MATLAB Online 中打开

Hi ahamd,

use below script.

% with for loop
input_data = {'glcm11','glcm12','glcm13','glcm14'};
for i = 1 : length(input_data)
    write_data = input_data(i);
    range = strcat('A',num2str(i+1));
    xlswrite('new.xlsx',write_data,'sheet1',range);
end
% OR  without for loop
input_data = {'glcm11','glcm12','glcm13','glcm14'}';
xlswrite('new.xlsx',input_data,'sheet1','A2');