How to insert multiple spreadsheets to a workbook from Matlab
3 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
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);
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!