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; java.io.FileInputStream importation; java.io.IOException importation; java.io.InputStream importation; java.util.Locale importation; jxl.Cell importation; jxl.Sheet importation; jxl.Workbook importation; jxl.WorkbookSettings importation; jxl.read.biff.BiffException importation; jxl.DateCell importation; 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) ( . printStackTrace ();))) / / Retourne les rubriques utilisées dans la feuille Excel getHeadingFromXlsFile public void (fiche de renseignements) (int = columnCount feuille. getColumns (); for (int i = 0; i <columnCount; i + +) (System.. out.println (sheet. getCell (i, 0). getContents ());)) public void contentReading (FileInputStream InputStream) (WorkbookSettings ws = null; Cahier classeur = null; feuille S = null; rowData Cell [] = null; rowCount int = '0 '; columnCount int = '0'; DateCell dc = null; totalSheet int = 0; try (a = WorkbookSettings new (); était. setLocale (new Locale ( "fr", "EN" )); classeur = classeur. getWorkbook (FileInputStream, a été); totalSheet = classeur. getNumberOfSheets (); if (totalSheet> 0) (System.. out.println ( "total du bilan Trouvé:" + totalSheet) for (int j = 0; j <totalsheet; j + +) (System.. out.println ( "Nom de la feuille:" + classeur. getSheet (j). getName ());)) / / Mise en défaut Sheet soit 0 s = classeur. getSheet ( 0); / / lecture individuelle getHeadingFromXlsFile cellule (s) / / Total Total n ° de lignes de feuille, vous permettra de revenir aucune de lignes qui sont occupés par quelques données System.. out.println ( "nombre total de lignes dans la feuille:" + s . GetRows ()); = GetRows rowCount art (); / / Total Nombre total de colonnes dans la feuille System.. out.println ( "Total en colonnes dans la feuille:" + a. getColumns ()); = columnCount art getColumns ( ) / / lecture individuelle Row Content for (int i = 0; i <rowCount; i + +) (/ / Get rowData ligne individuelle = s. getRow (i); if (rowData [0]. getContents (). longueur ()! = 0) (/ / la date de la première colonne ne doit pas 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 (" Nom de l'employé: "+ rowData [j]. getContents ()); case 2: System.. out.println (" Employee Désignation: "+ rowData [j]. getContents ());: default break;)))) classeur. close ();) catch (IOException e) (e. printStackTrace ();) catch (BiffException e) (e. printStackTrace ( );)) public static void main (String [] args) (try (xlReader ReadXLSheet = new ReadXLSheet (); xlReader. init ( "/ home / hitesh / Desktop / Test.xls");) catch (Exception e) ( e. printStackTrace ();)))