title: Search in xlsx and xls file using java
body: <p>I have a large xlsx file which as huge amount of data on which I have to implement search option I have used Apache POI jar as well as jxl jar so that the search between rows and column have been made. But it took huge time to traverse between big data can some one help me that is any jar files or any other concept available to do the search faster on Excel files...</p>
  
  <pre><code>    String searchValue="my_value_to_search";
      for (int i = 0; i &lt; sheet.getColumns(); i++) {
          for (int j = 0; j &lt; sheet.getRows(); j++) {
              value = sheet.getCell(i, j);
              valueType = value.getType();
              String val=getCellType(valueType, value);
              if (val != null&amp;&amp;val==searchValue) {
                  //   To do manipulation.
              }
          }
      }
  </code></pre>