Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel Results file in MAC #59

Open
r2rho1 opened this issue Aug 29, 2024 · 3 comments
Open

Excel Results file in MAC #59

r2rho1 opened this issue Aug 29, 2024 · 3 comments

Comments

@r2rho1
Copy link

r2rho1 commented Aug 29, 2024

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
Copy link

any luck on fixing the issue?

@r2rho1
Copy link
Author

r2rho1 commented Sep 17, 2024

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
Copy link

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants