MATLAB: Xlswrite and the single quote ‘ character

excelMATLABxlswrite

I want to add a formula to an Excel file using xlswrite but the formula has the ' character. This is giving me an error. Any suggestions to get around this?

For example, if I want to write the word " 'test " in cell A1 of Sheet1 I thought I would use:

xlswrite([foldername ExcelFileName '.xls'], {''test'},'Sheet1', 'A1');

But no, I get an error…

Best Answer

Well, post the entire error and I don't get any problem with:

xlswrite(filename, {'test'},'Sheet1','A1')

To have 'test you have to double it when using matlab strings:

xlswrite(filename, {'''test'},'Sheet1','A1')

But then on excel you won't see the ' before test... (but I expect it to be a desired result)

Oleg

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