How to export data and plot from app designer to excel?

I have created a plot using a table and used slider to smooth the graph, i don't know how to obtain the smoothed value table and the smoothed plot to excel in Matlab app designer

Answer 1

[Kevin Holly]

Please see the app attached. You can use writetable to save your data to an Excel file. You can use xlswritefig found on the File Exchange to save the figure to an Excel file.

[Kavinprasad M]

Please find the attached app. i want to export "Smooth Static Effort Filtered Graph" to specific location in an excel file

[Kavinprasad M]

When i run the app, i get this error for export plot, please support

[Kevin Holly]

Download the funciton from the File Exchange here:

https://www.mathworks.com/matlabcentral/fileexchange/24424-xlswritefig

Here are changes I would make to your app:

function ExportButtonPushed(app, event)
%             app.Result = 'result.xlsx';
            [filename, folder] = uiputfile("result.xlsx");
%             writetable(app.stf,app.Result)
              writetable(app.stf,fullfile(folder,filename))
%             exportgraphics(app.UIAxes2,'result.pdf')
            xlswritefig(app.UIAxes2,fullfile(folder,filename))
        end

[Kavinprasad M]

Thankyou, This works great :), I'll be back with more doubts related to my app >.<