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

5 vues (au cours des 30 derniers jours)
Sole
Sole le 15 Juin 2020
Commenté : Sole le 16 Juin 2020
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?

Connectez-vous pour répondre à cette question.

Réponses (1)

jmac
jmac le 15 Juin 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 commentaire
Sole
Sole le 16 Juin 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

Connectez-vous pour commenter.

Catégories

En savoir plus sur MATLAB Functions in Microsoft Excel dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by