title: PyQt populate QTableWidget from excel
body: <p>im trying to populate QTableWidget with some data from excel file, i want to add row to my QTable only if ID is on the listID, and i get no data in QTable cells</p>
  
  <p><a href="https://drive.google.com/file/d/0B_PFK3V2Ij4tSko4emplYmNuN1E/view?usp=sharing" rel="nofollow noreferrer">https://drive.google.com/file/d/0B_PFK3V2Ij4tSko4emplYmNuN1E/view?usp=sharing</a> here an excel file, it don't contain any formatin or formula, just empty rows and columns, because file is generated automaticaly</p>
  
  <p>here is my code</p>
  
  <pre><code>wb = openpyxl.load_workbook(os.path.join(os.getcwd(), file), read_only=True)
  ws = wb.active
  
  headers = []
  for item in ws[4]:
      headers.append(item.value)
  headers.pop(0)
  
  listID = []
  for index in range(self.listWidgetID.count()):
      listID.append(self.listWidgetID.item(index).text())
  
  data = ws.iter_rows(row_offset=5, column_offset=1)
  
  row_increment = 0
  self.tableWidgetDATA.setRowCount(1)
  self.tableWidgetDATA.setColumnCount(len(headers))
  self.tableWidgetDATA.setHorizontalHeaderLabels(headers)
  
  for x, rows in enumerate(data):
      if str(rows[0].value) in listID:
          for y, cell in enumerate(rows):
              item = QTableWidgetItem(str(cell.value))
              self.tableWidgetDATA.setItem(x, y, item)
          row_increment = row_increment + 1
          self.tableWidgetDATA.setRowCount(row_increment)
  </code></pre>