Techie Zone

 ; import java.io.FileInputStream ; import java.io.IOException ; import java.io.InputStream ; import java.util.Locale ; import jxl.Cell ; import jxl.Sheet ; import jxl.Workbook ; import jxl.WorkbookSettings ; import jxl.read.biff.BiffException ; import jxl.DateCell ; public class ReadXLSheet { public void init ( String filePath ) { FileInputStream fs = null ; try { fs = new FileInputStream ( new File ( filePath ) ) ; contentReading ( fs ) ; } catch ( IOException e ) { e. printStackTrace ( ) ; } catch ( Exception e ) { e. printStackTrace ( ) ; } finally { try { fs. close ( ) ; } catch ( IOException e ) { e. printStackTrace ( ) ; } } } //Returns the Headings used inside the excel sheet public void getHeadingFromXlsFile ( Sheet sheet ) { int columnCount = sheet. getColumns ( ) ; for ( int i = 0 ; i < columnCount ; i ++ ) { System . out . println ( sheet. getCell ( i, 0 ) . getContents ( ) ) ; } } public void contentReading ( InputStream fileInputStream ) { WorkbookSettings ws = null ; Workbook workbook = null ; Sheet s = null ; Cell rowData [ ] = null ; int rowCount = '0' ; int columnCount = '0' ; DateCell dc = null ; int totalSheet = 0 ; try { ws = new WorkbookSettings ( ) ; ws. setLocale ( new Locale ( "en" , "EN" ) ) ; workbook = Workbook. getWorkbook ( fileInputStream, ws ) ; totalSheet = workbook. getNumberOfSheets ( ) ; if ( totalSheet > 0 ) { System . out . println ( "Total Sheet Found:" + totalSheet ) ; for ( int j = 0 ; j < totalsheet ; j ++ ) { System . out . println ( "Sheet Name:" + workbook. getSheet ( j ) . getName ( ) ) ; } } //Getting Default Sheet ie 0 s = workbook. getSheet ( 0 ) ; //Reading Individual Cell getHeadingFromXlsFile ( s ) ; //Total Total No Of Rows in Sheet, will return you no of rows that are occupied with some data System . out . println ( "Total Rows inside Sheet:" + s. getRows ( ) ) ; rowCount = s. getRows ( ) ; //Total Total No Of Columns in Sheet System . out . println ( "Total Column inside Sheet:" + s. getColumns ( ) ) ; columnCount = s. getColumns ( ) ; //Reading Individual Row Content for ( int i = 0 ; i < rowCount ; i ++ ) { //Get Individual Row rowData = s. getRow ( i ) ; if ( rowData [ 0 ] . getContents ( ) . length ( ) != 0 ) { // the first date column must not null for ( int j = 0 ; j < columnCount ; j ++ ) { switch ( j ) { case 0 : System . out . println ( "Employee Id:" + rowData [ j ] . getContents ( ) ) ; case 1 : System . out . println ( "Employee Name:" + rowData [ j ] . getContents ( ) ) ; case 2 : System . out . println ( "Employee Designation:" + rowData [ j ] . getContents ( ) ) ; default : break ; } } } } workbook. close ( ) ; } catch ( IOException e ) { e. printStackTrace ( ) ; } catch ( BiffException e ) { e. printStackTrace ( ) ; } } public static void main ( String [ ] args ) { try { ReadXLSheet xlReader = new ReadXLSheet ( ) ; xlReader. init ( "/home/hitesh/Desktop/test.xls" ) ; } catch ( Exception e ) { e. printStackTrace ( ) ; } } } import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import java.util.Locale; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.WorkbookSettings; import jxl.read.biff.BiffException; import jxl.DateCell public class ReadXLSheet (public void init (String FilePath) (FileInputStream fs = null; try (FS = new FileInputStream (ny fil (FilePath)); contentReading (FS);) catch (IOException e) (e. printStackTrace ();) catch (Exception e) (e. printStackTrace ();) slutligen (try (fs. close ();) catch (IOException e) (e . printStackTrace ();))) / / Returnerar de rubriker som används inne i Excel-blad public void getHeadingFromXlsFile (Tunnplåt) (int AntalKolumner = plåt. getColumns () for (int i = 0; i <AntalKolumner, i + +) (System. out. println (sheet. getCell (i, 0). getContents ());)) public void contentReading (InputStream fileInputStream) (WorkbookSettings var = null; arbetsbok arbetsboken = null; Sheet s = null; Cell rowData [] = null; int rowCount = '0 '; int AntalKolumner = '0'; DateCell DC = null; int totalSheet = 0; try (var = new WorkbookSettings (); var. setlocale (nytt Locale ( "en", "EN" )); arbetsbok = arbetsbok. getWorkbook (fileInputStream, var); totalSheet = arbetsbok. getNumberOfSheets () if (totalSheet> 0) (System. out. println ( "Totalt Sheet Found:" + totalSheet) for (int j = 0; j <totalsheet j + +) (System. out. println ( "Sheet Name:" + arbetsbok. getSheet (j). getName ());)) / / Getting Standard Sheet dvs 0 s = arbetsbok. getSheet ( 0), / / Reading enskild cell getHeadingFromXlsFile (s), / / Summa Totalt antal rader i blad, kommer du tillbaka några rader som är upptagna med något datasystem. out. println ( "Totalt antal rader inne Sheet:" + s . getRows ()); rowCount = s. getRows (), / / Summa Totalt antal kolumner i Sheet System. out. println ( "Totalt Kolumn inne Sheet:" + s. getColumns ()); AntalKolumner = s. getColumns ( ) / / avläsa enstaka Row Innehållet for (int i = 0; i <rowCount, i + +) (/ / hämta enskilda Row rowData = s. getRow (i) if (rowData [0]. getContents (). längd ()! = 0) (/ / det första datumkolumnen inte får null for (int j = 0; j <AntalKolumner j + +) (switch (j) (case 0: System. out. println ( "Employee Id: "+ rowData [j]. getContents ()); Fall 1: System. out. println (" Employee Name: "+ rowData [j]. getContents ()); Fall 2: System. out. println (" Employee Designation: "+ rowData [j]. getContents ()); default: break;)))) arbetsbok. close ();) catch (IOException e) (e. printStackTrace ();) catch (BiffException e) (e. printStackTrace ( );)) public static void main (String [] args) (try (ReadXLSheet xlReader = new ReadXLSheet (); xlReader. init ( "/ home / hitesh / Desktop / test.xls");) catch (Exception e) ( e. printStackTrace ();)))