Open Excel with apache poi - Java Native OS

Java examples for Native OS:Windows

  1. HOME
  2. Java
  3. Native OS
  4. Windows

Description

Open Excel with apache poi

Demo Code


import java.io.FileInputStream;
import java.util.ArrayList;

import com.sun.xml.internal.bind.v2.schemagen.xmlschema.List;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;

public class AppealFromExcel 
{

  private static final String FILE_PATH = "./ExcelTestData.xlsx";
  
  public static void main(String[] args) {
    FileInputStream fis = null;//w  ww . j a  va  2  s  .  c om
    try 
    {
      fis = new FileInputStream(FILE_PATH);
      Workbook workbook = new XSSFWorkbook(fis);
      int numberOfSheets = workbook.getNumberOfSheets();
      
      for (int i = 0; i < numberOfSheets; i++) {
        Sheet sheet = workbook.getSheetAt(i);
        Iterator rowIterator = sheet.iterator();
        //iterating over each row
        while (rowIterator.hasNext()) 
        {
          
          Row row = (Row) rowIterator.next();
          
          Iterator cellIterator = row.cellIterator();
          //Iterating over each cell (column wise)? in a particular row.
          while (cellIterator.hasNext()) 
          {
            Cell cell = (Cell) cellIterator.next();
             switch(cell.getColumnIndex())
            {
            case 0:
              System.out.println(cell.getStringCellValue());
            case 1:
              System.out.println(cell.getDateCellValue());
            case 2:
              System.out.println(cell.getDateCellValue());
            case 3:
              System.out.println(cell.getStringCellValue());
            }   
          }
        }
      }
      fis.close();
       
    }
    catch(Exception e)
    {
      
    }

  }
}

Related Tutorials