title: how read excel file having more than 100000 row in java?
body: <p>I am trying read excel file having more than 100000 rows in java using apache poi. but I am encountering few problems. </p>
  
  <p>1-) It is taking 10 to 15 min in fetching data from excel file. </p>
  
  <p>2-) As I run my code, my laptop starts hanging. Because of that it is became difficult to fetch data and then I have to restart my laptop. </p>
  
  <p>Is there any other way by which I can fetch data from my excel file in less time using java ??</p>
  
  <p>Here is my current code:</p>
  
  <pre><code>public class ReadRfdsDump {
  
      public void readRfdsDump() {
          try {
              FileInputStream file = new FileInputStream(new File("C:\\Users\\esatnir\\Videos\\sprint\\sprintvision.sprint.com_Trackor Browser_RF Design Sheet_07062018122740.xlsx"));
               XSSFWorkbook workbook = new XSSFWorkbook(file);
               XSSFSheet sheet = workbook.getSheetAt(0);
               DataFormatter df = new DataFormatter();
  
               for(int i=0;i&lt;2;i++) {
                   Row row= sheet.getRow(i);
                   System.out.println(df.formatCellValue(row.getCell(1)));
               }
          }catch(Exception e) {
              e.printStackTrace();
          }
      }
  }
  </code></pre>