LightBlog
Contact at mumbai.academics@gmail.com or 8097636691/9323040215
Responsive Ads Here

Saturday, 30 June 2018

Apache POI PPT - Installation

Apache POI PPT - Installation


This chapter takes you through the process of setting up Apache POI on Windows and Linux based systems. Apache POI can easily be installed and integrated with your current Java environment, following a few simple steps without any complex setup procedures. User administration is required for installation.

System Requirements

JDKJava SE 2 JDK 1.5 or above
Memory1 GB RAM (recommended)
Disk SpaceNo minimum requirement
Operating System VersionWindows XP or above, Linux
Let us now proceed with the steps to install Apache POI.

Step 1: Verify your Java Installation

First of all, you need to have Java Software Development Kit (SDK) installed on your system. To verify this, execute any of the following two commands depending on the platform you are working on.
If the Java installation has been done properly, then it will display the current version and specification of your Java installation. A sample output is given in the following table.
PlatformCommandSample Output
Windows
Open Command Console and type −
\>java –version
Java version "1.7.0_60"
Java (TM) SE Run Time
Environment (build 1.7.0_60-b19)
Java Hotspot (TM) 64-bit Server
VM (build 24.60-b09,mixed mode)
Linux
Open Command terminal and type −
$java –version
java version "1.7.0_25"
Open JDK Runtime Environment (rhel-2.3.10.4.el6_4-x86_64)
Open JDK 64-Bit Server VM (build 23.7-b01, mixed mode)

Step 2: Set your Java Environment

Set the environment variable JAVA_HOME to point to the base directory location where Java is installed on your machine. For example,
PlatformDescription
WindowsSet JAVA_HOME to C:\ProgramFiles\java\jdk1.7.0_60
LinuxExport JAVA_HOME = /usr/local/java-current
Append the full path of Java compiler location to the System Path.
PlatformDescription
WindowsAppend the String "C:\Program Files\Java\jdk1.7.0_60\bin" to the end of the system variable PATH.
LinuxExport PATH = $PATH:$JAVA_HOME/bin/
Execute the command java -version from the command prompt as explained above.

Step 3: Install Apache POI Library

Download the latest version of Apache POI from https://poi.apache.org/download.html and unzip its contents to a folder from where the required libraries can be linked to your Java program. Let us assume the files are collected in a folder on C drive.
The following images show the directories and the file structures inside the downloaded folder −
Jar Hierarchy1
Jar Hierarchy2
Add the complete path of the five jars as highlighted in the above image to the CLASSPATH.
PlatformDescription
Windows
Append the following strings to the end of the user variable CLASSPATH −
“C:\poi-3.9\poi-3.9-20121203.jar;”
“C:\poi-3.9\poi-ooxml-3.9-20121203.jar;”
“C:\poi-3.9\poi-ooxml-schemas-3.9-20121203.jar;”
“C:\poi-3.9\ooxml-lib\dom4j-1.6.1.jar;”
“C:\poi-3.9\ooxml-lib\xmlbeans-2.3.0.jar;.;”
Linux
Export CLASSPATH = $CLASSPATH:
/usr/share/poi-3.9/poi-3.9-20121203.tar:
/usr/share/poi-3.9/poi-ooxml-schemas-3.9-20121203.tar:
/usr/share/poi-3.9/poi-ooxml-3.9-20121203.tar:
/usr/share/poi-3.9/ooxml-lib/dom4j-1.6.1.tar:
/usr/share/poi-3.9/ooxml-lib/xmlbeans-2.3.0.tar

No comments:

Post a Comment