MATLAB: How to add chart in a specific sheet in an excel workbook via Matlab

chart;excelimportsheet

I would like to add a chart in a specific sheet in an excel workbook via Matlab? Is this possible?

Best Answer

There are a few ways of doing this:

- If you use MATLAB Spreadsheet link Spreadsheet link this will enable you from Excel to call MATLAB and bring in MATLAB plots

- Some people like using Excel graphs and use MATLAB to refresh the data. So if have the data in MATLAB, and writetable or xlswrite to a specific sheet, then you can have the Excel create a chart based on that range, all you need is to update the chart.

- It is also possible to control Excel from MATLAB via the COM interface, however this takes a little more work.

- It is also possible to create an excel add-in with MATLAB Compiler SDK, that takes your MATLAB function and embeds it in Excel.

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: How to create chart objects in Excel from MATLAB 7.8 (R2008a)

To be able to access or create chart objects in excel sheets, you have to communicate with Excel from MATLAB using COM. To do this, you will have to create an Automation server in MATLAB using the actxserver command and use COM API to talk to Excel. Once you establish this connection, you can use commands similar to the excel VBA editor to programmatically add or edit objects in excel sheet.

Here is an example on how you could access data in excel sheet and draw chart objects. The chart Book.xlsx that contains the data is attached.

excel = actxserver('excel.application');
excel.Visible = 1;
wkbk = excel.Workbooks.Open('<FullPath>\Book.xlsx');
wkbk.ActiveSheet;
wkbk.ActiveSheet.Shapes.AddChart.Select;
wkbk.ActiveChart.SetSourceData(wkbk.ActiveSheet.get('Range','A2:B4'))
wkbk.ActiveChart.ChartType = 'xlBarClustered';
wkbk.SaveAs('<FullPath>\Book2.xlsx'); % save the changes
wkbk.Close;
excel.Quit; % close excel 
excel.delete;

The above API commands is provided by Microsoft Excel and for more specific information on these, refer to the Microsoft Excel's documentation page.

Best Answer

Related Solutions

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

MATLAB: How to create chart objects in Excel from MATLAB 7.8 (R2008a)

Related Question