1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
def output_xsl_clicked(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.du.table_kpi.columnCount()):
for currentRow in range(self.du.table_kpi.rowCount()):
try:
teext = str(self.du.table_kpi.item(currentRow, currentColumn).text())
sheet.write(currentRow, currentColumn, teext)
except AttributeError:
pass |
Partager