How to insert multiple spreadsheets to a workbook from Matlab

2 次查看（过去 30 天）
wangm
wangm 2020-7-29
编辑： Walter Roberson 2020-9-28
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
You can add the number of sheets as an extra argument. So, for 5 sheets:
eNewSheet = Add(eSheets,[],eSheet1,5);
  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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

产品


版本

R2011b

Community Treasure Hunt

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

Start Hunting!

Translated by