Java uses POI to get sheet, number of rows, number of columns

FileInputStream INP =NewFileInputStream ("E:\\weian.xls"); Hssfworkbook WB=NewHssfworkbook (INP); Hssfsheet sheet= Wb.getsheetat (2);//Get a third workbook (2008 workbook)//populate the table above, the data needs to be queried from the databaseHssfrow row5 = Sheet.getrow (4);//get the fifth line of the workbookHssfcell cell54 = Row5.getcell (3);//get the fourth cell of row fifthCell54.setcellvalue ("Test taxpayer name");//Assigning a value to a cell//get total number of columnsintColoumnum=sheet.getrow (0). Getphysicalnumberofcells ();intRownum=sheet.getlastrownum ();//get total number of rows

Java uses POI to get sheet, number of rows, number of columns