MATLAB: Unable to cast COM object of type ‘microsoft.office.interop.word.applicationclass’ to interface type ‘Microsoft Office interop.word._Application’ error while importing word files into Simulink Requirements.

simulinkSimulink Requirements

I am trying to import word files into Simulink for requirements. I have office 2013.

I am facing the following error:

Unable to cast COM object of type 'microsoft.office.interop.word.applicationclass' to interface type 'Microsoft Office interop.word._Application'

Best Answer

This is related to a installation issue with MS office. Please try the following commands from Windows PowerShell?

$a = New-Object -comobject Word.Application
$a
$a.Visible = $True

You should be able to reproduce the above error. This confirms that the issue is related to Word installation.

I suggest you to look at the following page to resolve the issue:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/d34c4f78-46f3-478e-9c44-95ea8461e46f/unable-to-cast-com-object-of-office-interop-word?forum=vsto

Related Solutions

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

MATLAB: Save Excel worksheet as csv Using com Object

Apparently 'xlCSV' just stands for '6', which Excel interprets as saving as CSV format. So if I do:

SaveAs(eSheet1,'C:\myfile.csv','6') % Saves as CSV

this works and solves my issue. I have no idea why 'xlCSV' does not work, but I'll leave this post in case others have similar issues in the future.

Best Answer

Related Solutions

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

MATLAB: Save Excel worksheet as csv Using com Object

Related Question