MATLAB: How to solve string error in xlswrite

MATLABstringxlswrite

Here in following code and decr are vectors in for loop.I want to write xls file as

xlswrite(data_cells,header,colnames,strcat('initial',num2str(data_num),'_decreased',num2str(decr),'.xls'));

But I am getting error: ??? Error using ==> xlswrite at 156 Filename must be a string.

Can any body please explain how to remove solve this error.

Thank You.

Best Answer

what version of MATLAB are you using, looks like you are referring to this link

http://www.mathworks.com/matlabcentral/fileexchange/2855-xlswrite, if that is the case you need to download the corresponding file from file exchange

Related Solutions

MATLAB: MIssing actxserver function for xlswrite

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.

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;

Best Answer

Related Solutions

MATLAB: MIssing actxserver function for xlswrite

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

Related Question