title: how to solve JXL error : jxl.read.biff.BiffException: Unable to recognize OLE stream
body: <p>i am trying to get cell data from my .csv file but it gets error : 
  jxl.read.biff.BiffException: Unable to recognize OLE stream</p>
  
  <p>I don't understand how to solve this,please give me some solution 
  this code is for jxl api &amp; is that api support to .csv?</p>
  
  <p>Code for reference:</p>
  
  <pre><code>public void read() throws IOException, BiffException  {
  
      File inputWorkbook = new File(inputFile);
  
      try
      {
          w = Workbook.getWorkbook(inputWorkbook.getAbsoluteFile());
          // Get the first sheet
          Sheet sheet = w.getSheet(0);
          // Loop over first 10 column and lines
  
          for (row = 1; row &lt; sheet.getRows(); row++) 
          {
              ReadExcelLotSizeEntity readExcelLotSizeEntity =new ReadExcelLotSizeEntity();
  
                  cell = sheet.getCell(1,row);
                  type= cell.getType();
                  if (cell.getType() == CellType.LABEL)
                  {
  
                      symbol=cell.getContents();
                      System.out.println(":::::::::::::::::"+symbol);
                      readExcelLotSizeEntity.setSymbol(symbol);
                  }   
  
                  int col=2;
                  cell = sheet.getCell(col,row);
                  while(!cell.getContents().equals("")||cell.getContents()!=null)
                  {
                      System.out.println("||||||||||||||||"+cell.getContents());
                      cell=sheet.getCell(col,row);
                      col++;
                  }
                  lotSize= new Double(cell.getContents());
                  readExcelLotSizeEntity.setLotSize(lotSize);
                  readExcelLotSizeEntity.setCreateUserId(1L);
                  readExcelLotSizeEntity.setCreateDtTm(new Date());
                  readExcelLotSizeHome.persist(readExcelLotSizeEntity);
              }
  
      } catch (BiffException e) {
          e.printStackTrace();
      }
  
  }
  </code></pre>