how to write a matrix in excel by changing cells after loop

Question

Jo 2014-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165417-how-to-write-a-matrix-in-excel-by-changing-cells-after-loop

编辑： Ingrid 2014-12-5

Hello

I have a large spread sheet of data and I use a loop I=1:52 in order to do some calculations. After each loop, an array v(:,1) is formed. I want to export this array in the excel after each cycle. for I=1, I use the function xlswrite, and the array is exported at the right position 'C2'.

name=Acdelta(:,1);     %contains the name-data
site=Acdelta(:,3);     %contains the sites-data
T={'subjects';1:52};
xlswrite('TEST.xlsx',T,'MI','A1');
xlswrite('TEST.xlsx',1:52 'MI','C1'); %write the numbers 1:52, starting from the cell C1

when I=1, I write the array at the cell, 'C2', etc

xlswrite('TEST.xlsx',v(:,1),'MI','C2');

when I=2, I want to write the new array at the next cell, 'D2', etc

Many thanks in advance.

2 个评论
显示无隐藏无

Yona 2014-12-4

Do you run it? what was the result? do you get an error?

Jo 2014-12-5

for I=1 it runs ok and my data are written at the right cell 'C2'. my question is how to write the data at the cell 'D2' at the next cycle, when I=2 (at 'E2' when I=3, etc).

请先登录，再进行评论。

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

Answer 1

Ingrid 2014-12-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165417-how-to-write-a-matrix-in-excel-by-changing-cells-after-loop#answer_161387

编辑：Ingrid 2014-12-5

在 MATLAB Online 中打开

to speed up your code you can use the actxserver instead of xlswrite

      %Open an ActiveX connection to Excel
      h = actxserver('excel.application');
      %Create a new work book (excel file)
      wb=h.WorkBooks.Add();
      %Write the data
      h.Activesheet.Range('C2').value = dataValues;
      % save the file with the given file name, close Excel
      wb.SaveAs(file); 
      wb.Close;
      h.Quit;
      h.delete;

To find in which column to write your results (i.e. move the letter) I find the following code on file exchange very helpful: http://www.mathworks.com/matlabcentral/fileexchange/27182-excel-column-conversion

Just call it first to convert letter to number, than add 1, and than call again to find the next letter so for your specific case:

colNum = ExcelCol('C');
newColLetter = ExcelCol(colNum + 1);
xlswrite('TEST.xlsx',v(:,1),'MI',sprintf(%s2,newColLetter));

But as indicated before it is much faster to use the actxserver than to use xlswrite and it has the added advantage that you can manipulate much more things