Read and Write excel file using POI 3.0


import org.apache.poi.hssf.record.formula.functions.Row;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class ReadExcel {

public static void main (String args [])
{
try {
 
   FileInputStream file = new FileInputStream(new File("D:\\test.xls"));
 
   //Get the workbook instance for XLS file
   HSSFWorkbook workbook = new HSSFWorkbook(file);

   //Get first sheet from the workbook
   HSSFSheet sheet = workbook.getSheetAt(0);
 
   //Iterate through each rows from first sheet
   Iterator rowIterator = sheet.iterator();
   while(rowIterator.hasNext()) {
    HSSFRow row =(HSSFRow) rowIterator.next();
     
       //For each row, iterate through each columns
       Iterator cellIterator = row.cellIterator();
       while(cellIterator.hasNext()) {
         
        HSSFCell  cell =(HSSFCell) cellIterator.next();
         
           switch(((HSSFCell) cell).getCellType()) {
               case HSSFCell.CELL_TYPE_BOOLEAN:
                   System.out.print(cell.getBooleanCellValue() + "\t\t");
                   break;
               case HSSFCell.CELL_TYPE_NUMERIC:
                   System.out.print(cell.getNumericCellValue() + "\t\t");
                   break;
               case HSSFCell.CELL_TYPE_STRING:
                   System.out.print(cell.getStringCellValue() + "\t\t");
                   break;
           }
       }
       System.out.println("");
   }
   file.close();
   FileOutputStream out =
       new FileOutputStream(new File("D://test1.xls"));
   workbook.write(out);
   out.close();
 
} catch (FileNotFoundException e) {
   e.printStackTrace();
} catch (IOException e) {
   e.printStackTrace();
}
}

}


Comments

Popular Posts