Information Technology Inspiration: Read Excel Menggunakan Java

Berikut adalah contoh membaca excel dengan menggunakan Java

1. Persiapan Componen

2. Buat File excel : student.xls

3. Buat file readxls.java

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.FormulaEvaluator;

import org.apache.poi.ss.usermodel.Row;

public class ReadExcelFileDemo

{

public static void main(String args[]) throws IOException
{

//obtaining input bytes from a file
FileInputStream fis=new FileInputStream(new File("D:\\student.xls"));
//creating workbook instance that refers to .xls file
HSSFWorkbook wb=new HSSFWorkbook(fis);
//creating a Sheet object to retrieve the object
HSSFSheet sheet=wb.getSheetAt(0);
//evaluating cell type
FormulaEvaluator formulaEvaluator=wb.getCreationHelper().createFormulaEvaluator();
for(Row row: sheet) //iteration over row using for each loop
{

for(Cell cell: row) //iteration over cell using for each loop

{
switch(formulaEvaluator.evaluateInCell(cell).getCellType())
{
case Cell.CELL_TYPE_NUMERIC: //field that represents numeric cell type
//getting the value of the cell as a number
System.out.print(cell.getNumericCellValue()+ "\t\t");
break;
case Cell.CELL_TYPE_STRING: //field that represents string cell type
//getting the value of the cell as a string
System.out.print(cell.getStringCellValue()+ "\t\t");
break;
}

}

System.out.println();

}

}

Hasil :

Read Excel Menggunakan Java - I [ XLS ]