Using COM to connect to Excel is a great way to accomplish this. Note that this approach will not work for non-Windows machines, since COM is used.
An Excel process may have multiple workbooks and worksheets open simultaneously. Before running your MATLAB code, make sure that only the specific workbook you want to use is open, and that the desired worksheet is active - that is, selected and visible above any other worksheets. The script relies on the correct workbook and worksheet being active in order to paste the figure into the intended location.
Attached is a simple script ("excel_figure_demo.m") that shows how one can connect to the Excel spreadsheet and add a figure from MATLAB.
Before running the script, make sure only one Excel process is running:
- Use the search box at the top of Task Manager to search for "excel" and confirm that only one Excel process is active. This ensures that you connect to the intended target workbook.
- You can also use the following MATLAB code to programmatically check how many Excel processes are running before running script:
>> [~, result] = system('tasklist /FI "IMAGENAME eq EXCEL.EXE"');
>> numExcelProcesses = count(result, 'EXCEL.EXE');
>> disp(['Number of Excel processes running: ', num2str(numExcelProcesses)]);
Note: The script above was tested and verified using MATLAB R2025a, and Microsoft Excel for Microsoft 365, Version 2509 (64-bit).
