Load flow Analyzer Report to Excel

I would like to export the result of my load flow in simulink simscape to excel. However, I keep receiving an error message, "No version of Microsoft Excel detected".

How can I fix it? I have MS excel installed but I don't know why it wont download the report on xls format.

Answer 1

[Harimurali]

Hi Jenny,

I understand that you want to export the load flow analyzer report in Excel format but are unable to do so due to an error message that says that a version of Microsoft Excel is not detected.

The load flow analyzer app uses a COM server to communicate with Excel. In this case, COM functions are only available on the Windows operating system hence, it is not possible to generate an Excel report on the Mac operating system.

You can refer to the following documentation for more information about using COM objects in MATLAB:

https://www.mathworks.com/help/matlab/using-com-objects-in-matlab.html

Alternatively, the MATLAB report generator can be used to generate a report. Please refer to the following documentation for information about the MATLAB report generator:

https://www.mathworks.com/help/rptgen/

Hope this helps.