Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. class Window(QtGui.QWidget):
  2. def __init__(self): #Initial a Window frame
  3. super(Window, self).__init__()
  4. self.labels() #insert labels
  5. self.buttons() #insert buttons
  6. self.draglists()
  7. self.table()
  8. .
  9. .
  10. .
  11.  
  12. def table(self):
  13. table = QtGui.QTableWidget(self)
  14. table.setRowCount(20)
  15. table.setColumnCount(4)
  16. table.resize(450, 300)
  17. table.move(640, 100)
  18. horHeader = ['Date', 'Category', 'Item', 'Expense']
  19. table.setHorizontalHeaderLabels(horHeader)
  20. def savefile(self):
  21. filename = unicode(QtGui.QFileDialog.getSaveFileName(self, 'Save File', '', ".xls(*.xls)"))
  22. wbk = xlwt.Workbook()
  23. sheet = wbk.add_sheet("sheet", cell_overwrite_ok=True)
  24. self.add2(sheet)
  25. wbk.save(filename)
  26.  
  27. def add2(self, sheet):
  28. for currentColumn in range(self.tableWidget.columnCount()):
  29. for currentRow in range(self.tableWidget.rowCount()):
  30. try:
  31. teext = str(self.tableWidget.item(currentRow, currentColumn)).text()
  32. sheet.write(currentRow, currentColumn, teext)
  33. except AttributeError:
  34. pass
  35.  
  36. if __name__ == '__main__':
  37. app = QtGui.QApplication(sys.argv)
  38. ex = Window()
  39. ex.setGeometry (50, 50, 1200, 600)
  40. ex.show()
  41. ex.setWindowTitle("Search Engine for Expense")
  42. sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement