Zona tecnólogo

 ; 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.File; import java.io.IOException; java.io.InputStream importação; java.util.Locale importação; jxl.Cell importação; jxl.Sheet importação; jxl.Workbook de importação; jxl.WorkbookSettings importação; jxl.read.biff.BiffException importação; 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 ();) (Exception e) (e. printStackTrace ();) finally (try (fs. close ();) catch (IOException e) (e . printStackTrace ();))) / / Retorna os títulos utilizados no interior da folha excel getHeadingFromXlsFile void (folha Sheet) (columnCount = folha. GetColumns (); for (int i = 0; columnCount i <; i + +) (System. fora. println (sheet. GetCell (i, 0). getContents ());)) contentReading void (FileInputStream InputStream) (WorkbookSettings foi = null; Workbook workbook = null; Folha de S = null; rowData Cell [] = null; int rowCount = '0 '; int ColumnCount = '0'; dc DateCell = null; totalSheet = 0; try (foi WorkbookSettings = new (); era. setLocale (new Locale ( "en", "PT" )); Workbook workbook = GetWorkbook. FileInputStream (foi); totalSheet = livro. getNumberOfSheets (); if (totalSheet> 0) (System. println fora. ( "total do Encontrado:" + totalSheet); for (int j = 0, j <totalsheet; j + +) (System. fora. println ( "Nome da Folha:" + livro. getSheet (j). getName ());)) / / Como padrão ou seja, s = 0 Folha de trabalho. getSheet ( 0); / / leitura individual getHeadingFromXlsFile Cell (s); / / Total n º total de linhas na Folha, você não vai voltar de linhas que são ocupadas com alguns dados do sistema. fora. println ( "total de linhas dentro Sheet:" + s . GetRows ()); GetRows rowCount = s. (); / / Total n º total de colunas na Folha de Sistema. fora. println ( "Total da coluna dentro Sheet:" + S. getColumns ()); getColumns columnCount = (s. ) / / leitura individual Row Content for (int i = 0; i <rowCount; i + +) (/ / Get rowData linha individual = getRow s. (i); if (rowData [0]. getContents () comprimento. ()! = 0) (/ / a coluna de data, não deve ser nulo para (j = 0; j columnCount <; j + +) (switch (j) (case 0: System. fora. println ( "Employee Id: "rowData + [j]. getContents ()); case 1: System. fora. println (" Nome do Funcionário: "+ rowData [j]. getContents ()); case 2: System. fora. println (" Employee Cargo: "rowData + [j]. getContents ()); default: break;)))) livro. close ();) catch (IOException e) (e. printStackTrace ();) catch (BiffException e) (e. printStackTrace ( );)) public static void main (String [] args) ((xlReader ReadXLSheet = ReadXLSheet novo (); xlReader init. ( "/ home hitesh / Desktop / test.xls");) (Exception e) ( e. printStackTrace ();)))