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

5 次查看（过去 30 天）

Sole 2020-6-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/548793-copying-and-pasting-data-from-one-excel-worksheet-to-another-or-from-the-workspace-to-an-existing-wo

评论： Sole 2020-6-16

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

jmac 2020-6-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/548793-copying-and-pasting-data-from-one-excel-worksheet-to-another-or-from-the-workspace-to-an-existing-wo#answer_451650

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sole 2020-6-16

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

请先登录，再进行评论。

请先登录，再回答此问题。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

另请参阅

类别

标签

Community Treasure Hunt

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

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

另请参阅

类别

标签

Community Treasure Hunt

WeChat

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论