Copy an Excel worksheet from one workbook to another with Matlab

171 views (last 30 days)
Hi everyone,
I hope you can help me with this problem. I need to copy a worksheet of workbook1 to another workbook2 with exact the same structure/format. There are empty cells and labels in between which I need to copy as well. I tried to save the range in a variable, but that doesn't work for me. I would like to do this via an ActiveX server. Is this possible and what would the code look like? Thanks in advance!
Greetings

Accepted Answer

Guillaume
Guillaume on 4 Sep 2019
You may as well write a macro in excel because you'd be using the same code in matlab:
excel = actxserver('Excel.Application'); %start excel
wbsource = workbooks.Open('C:\somefolder\somexcelfile.xlsx');
wbdest = workbooks.Open('C:\somefolder\someotherexcelfile.xlsx');
ws = wbsource.Worksheets.Item('NameOfSheet'); %or you can you the sheet index: ws = wbsource.Worksheets.Item(index);
ws.Copy(wdest.Worksheets.Item(1)); %copy worksheet before 1st worksheet of destination workbook
wdest.Save %save destination workbook
excel.Quit %quit excel
I've just written this on the fly. It's untested there may be bugs.Use MSDN to find the right functions to call.

More Answers (2)

Pruthvi G
Pruthvi G on 30 Sep 2019

Neuropragmatist
Neuropragmatist on 4 Sep 2019
Why does readtable followed by writetable not work?:
If the spreadsheets dont have to be in the same file you could also use movefile to just duplicate the original:
Sorry I don't really know about activeX servers.
Hope this helps,
M.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!