Apache POI XSSF Read Excel

/**

* Read the contents of Excel data

*

* @param inputstream

*/

public void Readexcelcontent (InputStream is) {

try {

wb = new Xssfworkbook (IS);

sheet = wb.getsheetat (0);

//Gets all lines in the Excel file excluding the first row of headings

int rowNum = Sheet.getlastrownum ();

System.out.println ("Total number of rows:" +rownum);

//Traverse rows

for (int i = 1; I <=rowNum; i++) {

//Read left upper cell

Row row = Sheet.getrow (i);

//Line not empty

if (row! = null) {

String value = "";

//Get all the columns in the Excel file

int cells = Row.getphysicalnumberofcells ();

//Traversal column

for (int j = 0; J < cells; J + +) {

//Gets the value of the column

Cell cell = Row.getcell (j);

if (cell! = null) {

switch (Cell.getcelltype ()) {

Case Cell.cell_type_formula:

break;

Case Cell.cell_type_numeric:

Value + = Cell.getnumericcellvalue () + ",";

break;

Case cell.cell_type_string:

Value + = Cell.getstringcellvalue () + ",";

break;

Default:

Value + = "0";

break;

}

}

}

System.out.println ("Cell:" +value);

}

}

}catch (IOException e) {

e.printstacktrace ();

}

}

Apache POI XSSF Read Excel