Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class Window(QtGui.QWidget):
- def __init__(self): #Initial a Window frame
- super(Window, self).__init__()
- self.labels() #insert labels
- self.buttons() #insert buttons
- self.draglists()
- self.table()
- .
- .
- .
- def table(self):
- table = QtGui.QTableWidget(self)
- table.setRowCount(20)
- table.setColumnCount(4)
- table.resize(450, 300)
- table.move(640, 100)
- horHeader = ['Date', 'Category', 'Item', 'Expense']
- table.setHorizontalHeaderLabels(horHeader)
- def savefile(self):
- filename = unicode(QtGui.QFileDialog.getSaveFileName(self, 'Save File', '', ".xls(*.xls)"))
- wbk = xlwt.Workbook()
- sheet = wbk.add_sheet("sheet", cell_overwrite_ok=True)
- self.add2(sheet)
- wbk.save(filename)
- def add2(self, sheet):
- for currentColumn in range(self.tableWidget.columnCount()):
- for currentRow in range(self.tableWidget.rowCount()):
- try:
- teext = str(self.tableWidget.item(currentRow, currentColumn)).text()
- sheet.write(currentRow, currentColumn, teext)
- except AttributeError:
- pass
- if __name__ == '__main__':
- app = QtGui.QApplication(sys.argv)
- ex = Window()
- ex.setGeometry (50, 50, 1200, 600)
- ex.show()
- ex.setWindowTitle("Search Engine for Expense")
- sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement