Guest User

Untitled

a guest
Jan 24th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. def save_file(self):
  2. filename = (QFileDialog.getSaveFileName(self, 'Сохранить', '', ".xls(*.xls)"))
  3. wbk = xlwt.Workbook()
  4. sheet = wbk.add_sheet("схема", cell_overwrite_ok=True)
  5. self.s_f(sheet)
  6. wbk.save(filename)
  7.  
  8. def s_f(self, sheet):
  9. for currentColumn in range(self.table.columnCount()):
  10. for currentRow in range(self.table.rowCount()):
  11.  
  12. my_icon = self.table.item(currentRow, currentColumn)
  13. sheet.write(currentRow, currentColumn, str(my_icon or ''))
  14.  
  15. def open_file(self):
  16. filename = QFileDialog.getOpenFileName(self, 'Открыть', '', '.xls(*.xls)')
  17.  
  18. book = xlrd.open_workbook(filename)
  19. sheet = book.sheet_by_index(0)
  20. data = [[sheet.cell_value(r, c)for c in range(sheet.ncols)]for r in range(sheet.nrows)]
  21.  
  22. for row, columnvalues in enumerate(data):
  23. for column, value in enumerate(columnvalues):
  24. item = QTableWidgetItem()
  25. item.setData(Qt.DisplayRole, str(value))
  26. self.table.setItem(row, column, item)
Add Comment
Please, Sign In to add comment