Copying and pasting data from one excel worksheet to another or from the workspace to an existing worksheet

6 views (last 30 days)
I have a macro enabled excel workbook with multiple sheets. Without creating a new workbook, how do I copy data from one existing workbook to another? Or from one sheet to another? Or from the workspace to an existing worksheet?

Answers (1)

jmac
jmac on 15 Jun 2020
I find the spreadsheet link toolbox pretty handy https://www.mathworks.com/products/spreadsheet-link.html
Initialize the link, then use =MLGetMatrix() in Excel
  1 Comment
Sole
Sole on 16 Jun 2020
Except I don't see the Spreadsheet Link for use with MATLAB and Excel check box on the Add-Ins. I'm using Excel 2016

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!