How to save the splitted tables in excel using matlab

1 次查看(过去 30 天)
I split my table into three different tables by row as given below
output = [ Time(:,1) xAvg yAvg X(:,1) Y(:,1) X(:,2) Y(:,2) DEdif SEdif rmseGTDE rmseGTSE];
Table = array2table(output,'VariableNames',{'Time','xAvg','yAvg','xDE','yDE','xSE','ySE','DEdif','SEdif','rmseGTDE','rmseGTSE'});
writetable(Table,[filename1(1) '-Avg-filteredSEDEWS_10.xls']);
v=[2 100 200];
Splittable=cell(numel(v)-1,1);
for k=2:numel(v)
Splittable{k-1}=Table(v(k-1):v(k)-1,:);
end
Splittable{k}=Table(v(end):end,:);
Three different table are created in MATLAB. But I want to save these three tables directly in Excel. How I cab do this. Thank you.

采纳的回答

Image Analyst
Image Analyst 2021-9-16
What do you mean by directly? You can use ActiveX if you're in Windows to directly control Excel.
Or you can simply write the data to a workbook or workbooks using functions like writetable(), writematrix(), writecell(), or xlswrite(). Create a filename in your loop.

更多回答(0 个)

标签

产品


版本

R2020b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by