How to convert MATLAB plots to xls (Excel) sheets ?

4 次查看（过去 30 天）

Adnan Hayat 2020-8-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/582755-how-to-convert-matlab-plots-to-xls-excel-sheets

评论： Adnan Hayat 2020-8-24

I have almost ten to fifteen MATLAB figures which I've got by running a MATLAB code. The code takes hours to plot a figure. My professor has now asked me to make .xls (Excel) sheets from the data associated with these figures. Although, I know how to do it and that is by using the "xlswrite" command, but, really ?, I have to run the code for hours again? Can anybody recoomend me an easy way using which I could get data files directly from the MATLAB figures ?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Arthur Roué 2020-8-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/582755-how-to-convert-matlab-plots-to-xls-excel-sheets#answer_483182

编辑：Arthur Roué 2020-8-21

在 MATLAB Online 中打开

You can access data of a plot with the line handle. For instance :

% Current figure handle (or use openfig if you saved the figure in a FIG-File)
hFigure = gcf;
% Find line handle
hLines = findobj(gcf, 'Type', 'Line')
% Here are your data
hLines.XData
hLines.YData

In this example, I assume you have only one line in each plot.

Since R2019a, prefer writetable, writematrix, or writecell instead of xlswrite

11 个评论
显示 9更早的评论隐藏 9更早的评论

Arthur Roué 2020-8-24

在 MATLAB Online 中打开

Here you go

% Current figure handle (or use openfig if you saved the figure in a FIG-File)
hFigure = gcf;
% Find lines handles
vhLines = findobj(gcf, 'Type', 'Line');
% X data, I assume it's the same for all lines (otherwise use interp1)
vX = vhLines(1).XData;
% All Y data
mY = vertcat(vhLines.YData)';
% All names
cNames = {vhLines.DisplayName};
% Cell to export
cToExport = [
    't [s]', cNames; % Headers
    num2cell([vX', mY])];
% Write into file
xlswrite('YourWorkbook.xlsx', cToExport, 'YourSheetName')