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.
0 件のコメント
採用された回答
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 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!