MATLAB Answers

How to save the splitted tables in excel using matlab

4 views (last 30 days)
Mandeep Kaur
Mandeep Kaur on 16 Sep 2021
Answered: Image Analyst on 16 Sep 2021
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.

Answers (1)

Image Analyst
Image Analyst on 16 Sep 2021
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.

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!