Errors when using optforce

[hongzhonglu]

Hi all, when I run the optforce, I meet the followed error. Could you help me find the reason?
The code and error is as followed:

constrOpt = struct('rxnList', {{'r_1714', 'r_2111', 'new5'}}, 'values', [-1.634, 0, 1.9]');
[mustLSet, pos_mustL] = findMustL(model1, minFluxesW, maxFluxesW, 'constrOpt', constrOpt, ...
'runID', runID, 'outputFolder', 'OutputsFindMustL', ...
'outputFileName', 'MustL' , 'printExcel', 1, 'printText', 1, ...
'printReport', 1, 'keepInputs', 1, 'verbose', 0);
No constructor 'org.apache.poi.xssf.usermodel.XSSFWorkbook' with matching signature found.

Error in xlwrite (line 150)
xlsWorkbook = XSSFWorkbook();

Error in findMustL (line 333)
xlwrite([outputFileName '_Info'], Info);

[tpfau]

You, very likely have Matlabs Text Analytics toolbox installed, which is, unfortunately, shipped with a customized version of the POI library needed for xlwrite. Therefore the POI library that is shipped with the COBRA toolbox is shadowed, and thus can't be used.
Could you try uninstalling the Text Analytics toolbox from Matlab and running optforce again?

[hongzhonglu]

Thanks for your help! I find the Text Analytics toolbox. I will try it again after uninstall it.

[tpfau]

It looks like you have it installed though. Or some other toolbox that ships with a version of java POI.
What matlab version are you running and what toolboxes do you have installed.
Could you post the results of generateSystemConfigReport() ?

[hongzhonglu]

Hi Please find the information:

MATLAB Version: 9.3.0.713579 (R2017b)
MATLAB License Number: 650541
Operating System: Mac OS X Version: 10.13.6 Build: 17G6030
Java Version: Java 1.8.0_121-b13 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode

MATLAB Version 9.3 (R2017b)
Simulink Version 9.0 (R2017b)
Aerospace Blockset Version 3.20 (R2017b)
Aerospace Toolbox Version 2.20 (R2017b)
Antenna Toolbox Version 3.0 (R2017b)
Audio System Toolbox Version 1.3 (R2017b)
Automated Driving System Toolbox Version 1.1 (R2017b)
Bioinformatics Toolbox Version 4.9 (R2017b)
Communications System Toolbox Version 6.5 (R2017b)
Computer Vision System Toolbox Version 8.0 (R2017b)
Control System Toolbox Version 10.3 (R2017b)
Curve Fitting Toolbox Version 3.5.6 (R2017b)
DSP System Toolbox Version 9.5 (R2017b)
Database Toolbox Version 8.0 (R2017b)
Datafeed Toolbox Version 5.6 (R2017b)
Econometrics Toolbox Version 4.1 (R2017b)
Embedded Coder Version 6.13 (R2017b)
Filter Design HDL Coder Version 3.1.2 (R2017b)
Financial Instruments Toolbox Version 2.6 (R2017b)
Financial Toolbox Version 5.10 (R2017b)
Fixed-Point Designer Version 6.0 (R2017b)
Fuzzy Logic Toolbox Version 2.3 (R2017b)
Global Optimization Toolbox Version 3.4.3 (R2017b)
HDL Coder Version 3.11 (R2017b)
Image Acquisition Toolbox Version 5.3 (R2017b)
Image Processing Toolbox Version 10.1 (R2017b)
Instrument Control Toolbox Version 3.12 (R2017b)
LTE HDL Toolbox Version 1.0 (R2017b)
LTE System Toolbox Version 2.5 (R2017b)
MATLAB Coder Version 3.4 (R2017b)
MATLAB Compiler Version 6.5 (R2017b)
MATLAB Compiler SDK Version 6.4 (R2017b)
MATLAB Report Generator Version 5.3 (R2017b)
Mapping Toolbox Version 4.5.1 (R2017b)
Model Predictive Control Toolbox Version 6.0 (R2017b)
Neural Network Toolbox Version 11.0 (R2017b)
Optimization Toolbox Version 8.0 (R2017b)
Parallel Computing Toolbox Version 6.11 (R2017b)
Partial Differential Equation Toolbox Version 2.5 (R2017b)
Phased Array System Toolbox Version 3.5 (R2017b)
Polyspace Bug Finder Version 2.4 (R2017b)
Polyspace Code Prover Version 9.8 (R2017b)
Powertrain Blockset Version 1.2 (R2017b)
RF Blockset Version 6.1 (R2017b)
RF Toolbox Version 3.3 (R2017b)
Risk Management Toolbox Version 1.2 (R2017b)
Robotics System Toolbox Version 1.5 (R2017b)
Robust Control Toolbox Version 6.4 (R2017b)
Signal Processing Toolbox Version 7.5 (R2017b)
SimBiology Version 5.7 (R2017b)
SimEvents Version 5.3 (R2017b)
Simscape Version 4.3 (R2017b)
Simscape Driveline Version 2.13 (R2017b)
Simscape Electronics Version 2.12 (R2017b)
Simscape Fluids Version 2.3 (R2017b)
Simscape Multibody Version 5.1 (R2017b)
Simscape Power Systems Version 6.8 (R2017b)
Simulink 3D Animation Version 7.8 (R2017b)
Simulink Check Version 4.0 (R2017b)
Simulink Coder Version 8.13 (R2017b)
Simulink Control Design Version 5.0 (R2017b)
Simulink Coverage Version 4.0 (R2017b)
Simulink Design Optimization Version 3.3 (R2017b)
Simulink Design Verifier Version 3.4 (R2017b)
Simulink Desktop Real-Time Version 5.5 (R2017b)
Simulink Report Generator Version 5.3 (R2017b)
Simulink Requirements Version 1.0 (R2017b)
Simulink Test Version 2.3 (R2017b)
Stateflow Version 9.0 (R2017b)
Statistics and Machine Learning Toolbox Version 11.2 (R2017b)
Symbolic Math Toolbox Version 8.0 (R2017b)
System Identification Toolbox Version 9.7 (R2017b)
Tracking and Sensor Fusion Toolbox Version 1.0 (R2017b)
Trading Toolbox Version 3.3 (R2017b)
WLAN System Toolbox Version 1.4 (R2017b)
Wavelet Toolbox Version 4.19 (R2017b)

Default shell : /bin/bash
Version of shell : GNU bash, version 3.2.57(1)-release (x86_64-apple-darwin17)
Copyright (C) 2007 Free Software Foundation, Inc.
Architecture : MACI64
MATLAB folder : /Applications/MATLAB_R2017b.app
COBRA Toolbox root : /Users/luho/Documents/GitHub/cobratoolbox
git version : git version 2.17.2 (Apple Git-113)
curl version : curl 7.54.0 (x86_64-apple-darwin17.0)
CBT_LP_SOLVER : gurobi
CBT_MILP_SOLVER : gurobi
CBT_QP_SOLVER : gurobi
CBT_MIQP_SOLVER : gurobi
CBT_NLP_SOLVER : matlab
GUROBI_PATH : /Library/gurobi810/mac64/matlab
ILOG_CPLEX_PATH :
TOMLAB_PATH :
MOSEK_PATH :