How to insert multiple spreadsheets to a workbook from Matlab

2020 7 29
1 个回答
回答已采纳
更新时间：2020 9 28
3 次查看（30 天）

0 个投票

Matlab provide a method to insert one spreadsheet: using the command
eNewSheet = Add(eSheets,[],eSheet1);
However, if I know I need to add multiple spreadsheets, e.g. 5, is there a way to tell Add comment, or I have to do a for loop to insert 5 sheets?
Thanks

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

 采纳的回答

Michael Croucher
Michael Croucher 2020-9-28

0 个投票

You can add the number of sheets as an extra argument. So, for 5 sheets:
eNewSheet = Add(eSheets,[],eSheet1,5);

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

wangm
wangm 2020-9-28
编辑：Walter Roberson 2020-9-28
Thanks Michael. It works.
I also tried to test if I can add spreadsheet before using the method provided in Matlab, i got error. Have you got the same error. here is the link Matlab provided:
https://www.mathworks.com/help/matlab/matlab_external/insert-a-spreadsheet-after-sheet-1.html
I followed the exact commend:
e = actxserver('Excel.Application');
Add(e.Workbooks);
e.Visible = 1;
eSheets = e.ActiveWorkbook.Sheets;
eSheet1 = Item(eSheets,1);
eNewSheet = Add(eSheets,[],eSheet1);
It works if I want to add sheet after the first. But if I want to add sheet before the first sheet by typing
eNewSheet = Add([], eSheets,eSheet1);
I got error: Undefined command/function 'Add'.
How do you interpolate the explanation:
To call Add with the After argument, omit the first argument, Before, by using an empty array [] in its place.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

产品

版本

R2011b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by