MATLAB: How to insert multiple spreadsheets to a workbook from Matlab

insert sheetsMATLAB

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

Best Answer

You can add the number of sheets as an extra argument. So, for 5 sheets:

eNewSheet = Add(eSheets,[],eSheet1,5);

Related Solutions

MATLAB: Merge and Center in Excel

That's because of this line:

eSheet1 = eSheet1.get('Range', 'B1:C1');

which replace the former value of esheet1 which use to be a sheet by a range reference.

Typically with matlab, you don't have to use the get method to access excel objects. I would also recommend that you don't rely on ActiveAnything, there's no point in using ActiveWorkbook when you already have a reference to the workbook so why not use it:

e = actxserver('Excel.Application');
% Add a workbook.
eWorkbook = e.Workbooks.Open(dest);
e.Visible = 1;  %optional
%get 1st sheet of workbook
eSheet1 = eWorkbook.Sheets.Item(1); %No need to activate it
% Merge Cells for Title1
rg = eSheet1.Range('B1:C1');
rg.MergeCells = true;
rg.Value = 'Title1';
rg.Font.ColorIndex = 3;
rg.Font.Bold = 1;
rg.HorizontalAlignment = -4108;
% Merge Cells for Title2
rg = eSheet1.Range('D1:E1');
rg.MergeCells = true;
rg.Value = 'Title2';
rg.Font.ColorIndex = 3;
rg.Font.Bold = 1;
rg.HorizontalAlignment = -4108;

MATLAB: Manipulate Excel From Matlab

% MATLAB Automation client example 
%
% Open Excel, add workbook, change active worksheet, 
% get/put array, save.
% First, open an Excel Server.
e = actxserver('Excel.Application');
% Insert a new workbook.
eWorkbook = e.Workbooks.Add;
e.Visible = 1;
% Make the first sheet active.
eSheets = e.ActiveWorkbook.Sheets;
eSheet1 = eSheets.get('Item', 1);
eSheet1.Activate;
% Merge Cells
eActivesheetRange = e.Activesheet.get('Range', 'A1:B1');
eActivesheetRange.MergeCells = 1;

Best Answer

Related Solutions

MATLAB: Merge and Center in Excel

MATLAB: Manipulate Excel From Matlab

Related Question