Code for Reading a xlsx file in java
Written by Ankur Goel
Here is a small code to read xlsx file thoug java code.
You may need to include some of the jar files like
- xmlbeans-2.3.0.jar
- dom4j-1.1.jar
- poi-ooxml-schemas-3.6-20091214.jar
- poi-ooxml-3.6-20091214.jar
- poi-3.6-20091214.jar
You can google it and download and include it along with the below code.
You have to include a simple xlsx file with some values in it (string values) and run the code. This code will fetch the values and print it on the screen.
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import java.util.Iterator;
import java.io.*;
public class Main {
public void ReadSheet() throws Exception
{
String filename = "book1.xlsx";
FileInputStream fis = null;
try {
fis = new FileInputStream(filename);
XSSFWorkbook workbook = new XSSFWorkbook(fis);
XSSFSheet sheet = workbook.getSheetAt(0);
Iterator rows = sheet.rowIterator();
int number=sheet.getLastRowNum();
System.out.println(" number of rows"+ number);
while (rows.hasNext())
{
XSSFRow row = ((XSSFRow) rows.next());
Iterator cells = row.cellIterator();
while(cells.hasNext())
{
XSSFCell cell = (XSSFCell) cells.next();
String Value=cell.getStringCellValue();
System.out.println(Value);
}
}
} catch (IOException e) {
e.printStackTrace();
} finally {
if (fis != null) {
fis.close();
}
}
}
public static void main(String[] args) {
Main object=new Main();
try{
object.ReadSheet();
}catch(Exception e)
{
e.printStackTrace();
}
}
}
Similarly you can do for the numeric cells. Or i will paste a different code for it. Leave a comment if you need some help.
Add this page to your favorite Social Bookmarking websites
Comments
if yes,can you give info about the sheet
thx in advance
java.lang.RuntimeExceptio n: Buffer underrun - requested 2 bytes but 0 was available
at org.apache.poi.poifs.filesystem.ODocumentInputS tream.checkAvaliable(ODocumentInputS tream.java:192)
at org.apache.poi.poifs.filesystem.ODocumentInputS tream.readUShort(ODocumentInputS tream.java:293)
* dom4j-1.1.jar
* poi-ooxml-schem as-3.6-20091214.jar
* poi-ooxml-3.6-20091214.jar
* poi-3.6-20091214.jar
required ?