MATLAB: Export multiple graphs to Excel

excelexportmatlab guiplot

Hi all,

I have some graphs in my GUI and i would like to export them to an excel file like this:

The graphs will be positioned by definition.

Example:

Graph 1 from A:G, 1:15. Graph 2 from H:N, 1:15.

Is it possible?

Best Answer

You can use xlswritefig function or MLGetFigure function to add plots to excel sheet.

with xlswritefig you can mention cell location for plot directly in the code whereas with MLGetFigure, you have to open the excel file and mention the command in excel cell.

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Structure Export

Structure, or structure array?

Structure case:

t = struct2cell(S);
fprintf(fid, '%s,%s,%s,%f\n', t{:});

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Structure Export

Related Question