Write in Excel With Matlab on continues Cells

Question

Virginia 2013-6-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80261-write-in-excel-with-matlab-on-continues-cells

Hello!, I'm trying to make a code which writes data of a matrix in an Excel Worksheet, however, I'd like to write several matrices one after the other, the problem is that with the function xlswrite I have to specify the cell were the matrix is going to be written, and depends on the data there will be diferents quantities of matrices.

Right now I have this:

 fprintf('Select file location \n');
 ubic=uigetdir;
 name=input('Specify Name of the file: ','s');
 comp=strcat(ubic, '\',name, '.xls');
 nomhoja='Desplazamiento';
 for i=1:np
 head={'t (seg)', 'x (cm)'};
 xlswrite(comp, head, nomhoja, 'A1');
 xlswrite(comp, [rangT',maximox(i,1:num)'], nomhoja, 'A2');
 end

As you can see I need to write this matrix [rangT',maximox(i,1:num)'] 'np' times, so when I write 'A1' for the first loop it's fine but for the next one I need it to be 'C1', the next one 'E1'.. etc

Hope You can help me

Thanks!!

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

请先登录，再进行评论。

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

Answer 1

Iman Ansari 2013-6-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80261-write-in-excel-with-matlab-on-continues-cells#answer_89958

在 MATLAB Online 中打开

First put your data in a cell array then write it:

 rangT = 1:10;
 maximox = rand(10,10);
 fprintf('Select file location \n');
 ubic=uigetdir;
 name=input('Specify Name of the file: ','s');
 comp=strcat(ubic, '\',name, '.xls');
 nomhoja='Desplazamiento';
 C = cell(10,20);
 for i=1:10
    C(:,(2*i-1):(2*i)) = num2cell([rangT',maximox(i,1:10)']);
 end
 head={'t (seg)', 'x (cm)'};
 Data = [repmat(head,1,10);C];
 xlswrite(comp, Data, nomhoja);

6 个评论
显示 4更早的评论隐藏 4更早的评论

Virginia 2013-6-26

在 MATLAB Online 中打开

it returns me this error In an assignment A(:) = B, the number of elements in A and B must be the same.

this is the code I introduced:

 nomhoja='Desplazamiento';
 C=cell(c,num);
 for i=1:np
    C(:,(2*i-1):(2*i)) = num2cell([rangT',maximox(i,1:num)']);
 end
 header(1:2:num) = strcat({'Story '},num2str((1:np)'));
 header(end+1) = cell(1);
 head={'t (seg)', 'x (cm)'};
 Data = [header;repmat(head,1,num);C];
 xlswrite(comp, Data, nomhoja);

Iman Ansari 2013-6-26

在 MATLAB Online 中打开

np = 10;
num = 8;
rangT = 1:8;
maximox = rand(10,8);
nomhoja='Desplazamiento';
C=cell(num,2*np);
for i=1:np
   C(:,(2*i-1):(2*i)) = num2cell([rangT',maximox(i,1:num)']);
end
header(1:2:2*np) = strcat({'Story '},num2str((1:np)'));
header(end+1) = cell(1);
head={'t (seg)', 'x (cm)'};
Data = [header;repmat(head,1,np);C];
xlswrite(comp, Data, nomhoja);