Effacer les filtres
Effacer les filtres

writetables data on excel

2 vues (au cours des 30 derniers jours)
Nick Pappas
Nick Pappas le 6 Avr 2020
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

Réponses (0)

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!

Translated by