how to append data to existing excel row
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Fangjun Jiang
le 6 Oct 2011
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.
Réponses (1)
Laura Proctor
le 6 Oct 2011
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)];
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!