writetables data on excel

1 次查看（过去 30 天）

Nick Pappas 2020-4-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/515806-writetables-data-on-excel

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