How can I Install POI library on Mac?

I want to use XLSwrite on macbook. So I need to install POI library. How can I install it?

Answer 1

[Walter Roberson]

https://www.tutorialspoint.com/apache_poi/apache_poi_environment.htm

Be careful with changing JAVA_HOME, as MATLAB pays attention to it. Also to make the change permanent you would have to put the command into your ~/.bash_profile

Where the tutorial talks about changing CLASSPATH you should look at https://www.mathworks.com/help/matlab/matlab_external/java-class-path.html

[Butterflyfish]

Unfortunately tutorial is for Windows or Linux based systems. Any advice to do it on OSX?

[Walter Roberson]

You can use /usr/libexec/java_home to find the value you should use for JAVA_HOME .

Answer 2

[Butterflyfish]

In your Matlab code, add:

    addpath('/dir/20130227_xlwrite/poi_library')
    javaaddpath('poi_library/poi-3.8-20120326.jar');
    javaaddpath('poi_library/poi-ooxml-3.8-20120326.jar');
    javaaddpath('poi_library/poi-ooxml-schemas-3.8-20120326.jar');
    javaaddpath('poi_library/xmlbeans-2.3.0.jar');
    javaaddpath('poi_library/dom4j-1.6.1.jar');
    javaaddpath('poi_library/stax-api-1.0.1.jar');

Answer 3

[Samar Guharay]

Since I have a MAC, I am trying to use xlwrite instead of the standard xlswrite. I am getting the following comments. Any suggestions to solve this problem?

"The POI library is not loaded in Matlab. Check that POI jar files are in Matlab Java path!"

[Butterflyfish]

Have you tried to add the code above in your script?