MATLAB: MIssing actxserver function for xlswrite

xlswrite actxserver

Hi, I just tried xlswrite and it looks like I am missing actxserver in both R2013(mac) and R2007b(windows). Not sure why but if I try

Warning: Could not start Excel server for export.

XLSWRITE will attempt to write file in CSV format.

> In xlswrite at 175

>> Excel = actxserver('Excel.Application');

Undefined function 'actxserver' for input arguments of type 'char'.

Any ideas?

Best Answer

activex cannot be used on OS-X or Linux as those operating systems do not support ActiveX. It should be present on MS Windows; but if you do not have Excel installed on your MS Windows machine then it would revert to Basic mode.

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 properly use xlswrite

Try

xlswrite(FILENAME, {xlsTitle}, OUTSPREADSHEET, 'A1')

However if you are not using MS Windows or if you do not have Excel installed on MS Windows, then xlswrite cannot handle the task for you: without Excel on Windows, xlswrite is restricted to pure numeric values or to putting one character in each cell. If that situation applies to you then consider using writetable()

Best Answer

Related Solutions

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

MATLAB: How to properly use xlswrite

Related Question