Copy an Excel worksheet from one workbook to another with Matlab

조회 수: 186(최근 30일)
Franziska 2019년 9월 4일
답변: Pruthvi G 2019년 9월 30일
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!

채택된 답변

Guillaume 2019년 9월 4일
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.
  댓글 수: 1
Franziska 2019년 9월 5일
Thank you very much! This works perfectly! :)

댓글을 달려면 로그인하십시오.

추가 답변(2개)

Pruthvi G
Pruthvi G 2019년 9월 30일

Neuropragmatist 2019년 9월 4일
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,
  댓글 수: 2
Neuropragmatist 2019년 9월 6일
No you are right it doesn't...

댓글을 달려면 로그인하십시오.

Community Treasure Hunt

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

Start Hunting!

Translated by