writetables data on excel
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi guys,
I have an array and i convert it to a table so i can put it on an excel file. My problem is that i want to play more with the excel.
My code is scanning 200 data and then save them to an excel. My problem is with the current code if the code reach in the next cut spot at 400 data it will replace the old ones. I don't want that. I want to add the new 200 data under the old ones in the excel.So overal i will have 200 old data + 200 new data under of the old data.
In excel it could be A1:A200 and the new data to A201:401
Does anyone have any ideas on how to do it ?
Thank you for your time!
-Nick
My code is:
if (intex == 200)
T = array2table(myvar);
filename= 'Untitled1.xlsx';
writetable(T,filename,'Sheet',1,'Range','A4');
intex =0;
end
0 commentaires
Réponses (0)
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!