Use POI to read all sheet tables in Excel

Use POI to read all sheet tables in Excel
Recently contacted the import and export of multiple sheet pages, now gives examples of how to use POI to read all sheet table contents in Excel through multiple loops.

Package poitest;
Import Java.io.File;
Import Java.io.FileInputStream;
Import Org.apache.poi.hssf.usermodel.HSSFRow;
Import Org.apache.poi.hssf.usermodel.HSSFSheet;
Import Org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class Getallexceldata {

public static void Main (string[] args) {
try {
Showexcel ();
catch (Exception e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
}
public static void Showexcel () throws Exception {
Hssfworkbook workbook=new Hssfworkbook (New FileInputStream ("/file/student.xls"));
Hssfsheet Sheet=null;
for (int i = 0; i < workbook.getnumberofsheets (); i++) {//Get each sheet table
Sheet=workbook.getsheetat (i);
for (int j = 0; J < Sheet.getphysicalnumberofrows (); j + +) {//Get each row
Hssfrow Row=sheet.getrow (j);
for (int k = 0; k < Row.getphysicalnumberofcells (); k++) {//Get each cell
System.out.print (Row.getcell (k) + "T");
}
SYSTEM.OUT.PRINTLN ("---sheet table" +i+ "Processing completed---");
}
}
}
}