Excel Results file in MAC

[r2rho1]

Hi. After running BEAR, I get the following error when trying to produce an Excel file with the results. I'm still trying to figure out how to solve this. I used to work with BEAR in Windows and never had this problem. I would appreciate any suggestion other than returning to Windows ;) Thanks

Warning: Unable to write to Excel format, attempting to write file to CSV format.

In xlswrite (line 198)
In bear.xlswritegeneral (line 31)
In bear.data.excelrecord4fcn (line 36)
In bear.irfdisp (line 214)
In BEARmain (line 979)
In BEARapp22a/RUNButtonPushed (line 771)
In appdesigner.internal.service/AppManagementService/executeCallback (line 172)
In matlab.apps.AppBase>@(source,event)executeCallback(ams,app,callback,requiresEventData,event) (line 62)
In appdesservices.internal.interfaces.model/AbstractModel/executeUserCallback (line 282)
In matlab.ui.control.internal.controller/ComponentController/handleUserInteraction (line 442)
In matlab.ui.control.internal.controller/PushButtonController/handleEvent (line 95)
In appdesservices.internal.interfaces.controller.AbstractController>@(varargin)obj.handleEvent(varargin{:}) (line 214)
In viewmodel.internal.factory.ManagerFactoryProducer>@(src,event)callback(src,viewmodel.internal.factory.ManagerFactoryProducer.convertStructToEventData(event)) (line 79)

[elisapainter]

any luck on fixing the issue?

[r2rho1]

any luck on fixing the issue?

Hi. Nope. I ended up installing Parallels, and running MatLab from there as a Windows session. It is a pain, but I couldn't find any way around it.

[elisapainter]

Hi, Try this workaround: 1) download the xlwrite.m for Macs (https://www.mathworks.com/matlabcentral/fileexchange/37560-xlwrite-export-data-to-excel-from-matlab-on-mac-win); 2) run the java that this code needs; 3) substitute in the xlswritegeneral the "xlswrite" for "xlwrite"; Wherever in the code there is .xlsx substitute it with .xls; This will generate the file in xls format in a Mac. Hope this works for you while the developers answer why is not working properly!

[tjunior23]

Hi. I'm guessing still no change on this

[elisapainter]

Hi, Did you try the workaround I posted on Oct 2024? it should work if you follow the instructions I detailed above...