Reading excel in simple java

Reading excel in simple java

Import java. io. IOException; import java. io. inputStream; import java. util. iterator; 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 org. apache. poi. poifs. filesystem. POIFSFileSystem; public class ReadE {public static void main (String [] args) {try {InputStream input = new FileInputStream ("demo.xls "); // modify the file path POIFSFileSystem fs = new POIFSFileSystem (input); HSSFWorkbook wb = new HSSFWorkbook (fs); HSSFSheet sheet = wb. getSheetAt (0); // here, modify the Iterator rows = sheet. rowIterator (); while (rows. hasNext () {HSSFRow row = (HSSFRow) rows. next (); Iterator cells = row. cellIterator (); while (cells. hasNext () {HSSFCell cell = (HSSFCell) cells. next (); switch (cell. getCellType () {case HSSFCell. CELL_TYPE_NUMERIC: System. out. print (cell. getNumericCellValue () + "\ t"); break; case HSSFCell. CELL_TYPE_STRING: System. out. print (cell. getStringCellValue () + "\ t"); break; case HSSFCell. CELL_TYPE_BOOLEAN: System. out. print (cell. getBooleanCellValue () + "\ t"); break; case HSSFCell. CELL_TYPE_FORMULA: System. out. print (cell. getCellFormula () + "\ t"); break; default: System. out. print ("unsuported partition type" + "\ t"); break ;}} System. out. println () ;}} catch (IOException ex) {ex. printStackTrace ();}}}