How to read a excel file in java

//You need Apache POI library in order to work this code

//Using Apache POI
    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("C:\\demo\\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();  
    }  
    }  
    }

Similar codes

-2 votes197 views2 answers
Java ceil
Java
2 votes245 views1 answer
How to set frame colo in java
Java
2 votes218 views6 answers
How to reverse a number in java
Java
0 vote256 views1 answer
<selector xmlns:android="http://schemas.android.com/apk/res/android><item android;drawable="@drawable/bluebtn" android: state_enabled="false"/>
Java
0 vote201 views1 answer
Image show by timer android studio
Java
0 vote196 views2 answers
Output audio to bluetooth
Java
-1 vote196 views1 answer
Class java.lang.Integer cannot be cast to class java.lang.Long (java.lang.Integer and java.lang.Long are in module java.base of loader 'bootstrap')
Java
1 vote399 views1 answer
Find shortest string in array java
Java
1 vote232 views2 answers
Volley dependency
Java
4 votes198 views3 answers
Java uuid from string
Java