how to append data to existing excel row

Question

Max Bernstein 2011-10-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/17621-how-to-append-data-to-existing-excel-row

Hello,

I have an excel file with string already in it for the first 2 colums and I want to append numeric data after that but I'm having trouble trying to write to the correct row.

 Filename           Date of addition  Number of Cycles    Length
                #              (s) 
379Q1172e.v26  10/6/2011 10:58

Below is the code I have written

for i=1:length(cycle)
%extract excel data
      [xnum,xtxt,xraw] = xlsread(excel_file);
%find cycle length
      comp_cycle=(cycle(i,;2)-cycle(i,1))/100
%find correct cell position to write to
      posi = ['C',num2str(length(xraw(:,3)))];
      xlswrite(excel_file,{i,comp_cycle},'Data',posi);
end

The problem I'm having is when its read the excel file, the length of the column C returns 3, not 2, so it writes data to the row below it and not the same row as the filename.

Any idea how I can fix this?

Thanks!

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

Max Bernstein 2011-10-6

Yeah you're right, there is a blank space and shows as []. Is there anyway to overwrite that blank space?

I tried to use posi = ['C',num2str(length(xraw(:,3))-1)];

but it overwrites C2, not C3.

Fangjun Jiang 2011-10-6

It's easier if you clear your Excel file of those blank cells. Whatever trouble you have, you can put a break point in that line and debug your code. Check the value of posi and you'll know where it starts writing and whether that is what you are expecting.

请先登录，再进行评论。

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