Moving excel sheets within excel file

5 views (last 30 days)

Show older comments

Caroline on 18 Aug 2013

0
Link

Direct link to this question

https://ch.mathworks.com/matlabcentral/answers/84997-moving-excel-sheets-within-excel-file

Commented: Babajan Basha on 8 Jan 2020

Accepted Answer: Image Analyst

I was wondering how you can move an excel sheet in MATLAB within an excel file that already exists?

Thanks!

0 Comments
Show -2 older commentsHide -2 older comments

Accepted Answer

Image Analyst on 18 Aug 2013

1
Link

Direct link to this answer

https://ch.mathworks.com/matlabcentral/answers/84997-moving-excel-sheets-within-excel-file#answer_94529

I think you'll have to use ActiveX to copy the sheet, then delete the sheet, then insert a new sheet with the desired sheet number. Search this forum for ActiveX.

2 Comments
Show NoneHide None

Caroline on 18 Aug 2013

Thank you!

Pruthvi G on 30 Sep 2019

https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

Updated Answer

More Answers (1)

Pruthvi G on 30 Sep 2019

0
Link

Direct link to this answer

https://ch.mathworks.com/matlabcentral/answers/84997-moving-excel-sheets-within-excel-file#answer_394170

https://in.mathworks.com/matlabcentral/fileexchange/72901-copy-sheet-from-one-excel-file-to-another-excel-file

1 Comment
Show -1 older commentsHide -1 older comments

Babajan Basha on 8 Jan 2020

Thank you Pruthvi..

Community Treasure Hunt

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

Start Hunting!