title: Excel to String xls/xlsx different result
body: <p><br>
  I want to compare Excel files with each other just to see if they are the same or not. I can choose my Excel Files and Read them. I have 2 Excel Sheets with the same Content but one in .xls and on in .xlsx format. 
  I use the following Code to read my files (for xls with HSSFWorkbook and so on)</p>
  
  <pre><code>private String xlsx(File inputFile) {
          String outputString = "";
  
          // For storing data into String
          StringBuffer data = new StringBuffer();
          try {
              // Get the workbook object for XLSX file
              XSSFWorkbook wBook = new XSSFWorkbook(new FileInputStream(inputFile));
  
              // Get first sheet from the workbook
              XSSFSheet sheet = wBook.getSheetAt(0);
              Row row;
              Cell cell;
  
              // Iterate through each rows from first sheet
              Iterator&lt;Row&gt; rowIterator = sheet.iterator();
  
              while (rowIterator.hasNext()) {
                  row = rowIterator.next();
  
                  // For each row, iterate through each columns
                  Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
                  while (cellIterator.hasNext()) {
  
                      cell = cellIterator.next();
  
                      data.append(cell + ";");
                  }
                  data.append("\n");
              }
              System.out.println(data.toString());
              outputString = data.toString();
              wBook.close();
          } catch (Exception ioe) {
              ioe.printStackTrace();
          }
  
          return outputString;
      }
  </code></pre>
  
  <p>In my Excel I have blank cells - when i read them with xls I get <code>DATA;;;;;DATA</code> which is correct but When i Do the same in xlsx I get <code>DATA;DATA</code></p>
  
  <p>Somehow the Code skips empty cells?! How can I fix this Problem?
  Thanks in Advance</p>