how to append data to existing excel row
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
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.
回答(1 个)
Laura Proctor
2011-10-6
Is it just a matter of subtracting one from the length to keep writing on the same row?
posi = ['C',num2str(length(xraw(:,3))-1)];
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!