MATLAB: Disable “Excel COM server”

xlsread xlswrite "excel com server"

How can I disable "Excel COM server" in MATLAB ? (I am coding in a machine with MS Excel, but will run the code on non-Excel machine)

Thanks S

Best Answer

Do you mean when using the XLSREAD command? Use the "[num,txt,raw] = xlsread(filename,sheet,'','basic')" syntax.

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

The ability to programmatically add the Header and Footer to an Excel worksheet can be implemented in MATLAB using the COM interface.

The ACTXSERVER command can be used to create a COM server running Microsoft Excel. You can then add the Header and Footer using the different methods for the workbook and then call XLSWRITE to write the data to the Excel worksheet as follows:

a = actxserver('Excel.Application');
a.Visible =1;
a.Workbooks.Add;
a.activeWorkbook.activesheet.PageSetup.LeftFooter = 'MyFooter';
a.activeWorkbook.activesheet.PageSetup.LeftHeader = 'MyHeader';
a.activeWorkbook.SaveAs('test.xlsx');
a.activeWorkbook.Close;
xlswrite('test.xlsx',[1 2 3]);

The following options can also be modified in a similar way:

a.activeWorkbook.activeWorksheet.PageSetup.CenterHeader 
a.activeWorkbook.activeWorksheet.PageSetup.RightHeader 
a.activeWorkbook.activeWorksheet.PageSetup.CenterFooter 
a.activeWorkbook.activeWorksheet.PageSetup.RightFooter

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: How to add a Header or a Footer to an EXCEL worksheet using MATLAB 7.7 (R2008b)

Related Question