writetables data on excel
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(0 个)
另请参阅
类别
在 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!