Nov
29
2015

read xlsx file in java

In this post of java tutorials we will see how to read xlsx file . We need few jar  for this. So before running this program please add following jars in your classpath. This program and jar files used in this are available in github repository.

dom4.jar
org.apache.poi-osgi-3.8-sources.jar
poi-3.5-FINAL.jar
poi-3.8-beta2-20110408.jar
poi-ooxml-3.7-20101029.jar
poi-ooxml-schemas-3.7-beta1.jar
xmlbeans-2.5.0.jar
xmlbeans-xmlpublic-2.4.0.jar

When i run this program here is output

cellvalue :Product Category
cellvalue :Product Subcategory
cellvalue : productcode

cellvalue :productHeight
cellvalue :productWidth
cellvalue :productWeight
cellvalue :productDiameter
cellvalue :numberOfItems
cellvalue : numberOfLights
cellvalue :imageurl1
cellvalue :imageurl2
cellvalue :imageurl3
cellvalue :Lighting
cellvalue :Chandeliers
cellvalue :PH-CH-01
cellvalue :https://dl.dropboxusercontent.com/s/mmdd6xfkqb7x9qc/1448337633840.png?dl=0
cellvalue :https://dl.dropboxusercontent.com/s/mmdd6xfkqb7x9qc/1448337633840.png?dl=0
cellvalue :https://dl.dropboxusercontent.com/s/mmdd6xfkqb7x9qc/1448337633840.png?dl=0
cellvalue :Lighting
cellvalue :Chandeliers
cellvalue :PH-CH-02
cellvalue :https://dl.dropboxusercontent.com/s/mmdd6xfkqb7x9qc/1448337633840.png?dl=0
cellvalue :https://dl.dropboxusercontent.com/s/mmdd6xfkqb7x9qc/1448337633840.png?dl=0
cellvalue :https://dl.dropboxusercontent.com/s/mmdd6xfkqb7x9qc/1448337633840.png?dl=0

I hope this is somehow helpful to you. If there is any modification need please do share i with me to improve it.

Comments are closed.