MATLAB Answers

Copy an Excel worksheet from one workbook to another with Matlab

174 views (last 30 days)
Franziska
Franziska on 4 Sep 2019
Answered: Pruthvi G on 30 Sep 2019
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

  0 Comments

Sign in to comment.

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)

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.

  2 Comments

Image Analyst
Image Analyst on 4 Sep 2019
Does readtable retain formatting? Like font size, color, background fill, border sizes, etc.? I'd doubt it.

Sign in to comment.


Community Treasure Hunt

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

Start Hunting!