def cursorToTable(targetCursor): """Converts the given cursor object into a table input : A Cursor object which is the result of a query Returns : A table filled with the information from cursor""" desc=targetCursor.description headerList=[]; for field in desc: headerList.append( field[0]) resultTable=idLogTable(headerList) rowList=targetCursor.fetchall() for row in rowList: lRow=list(row) resultTable.addRow(lRow) return resultTable
for col_idx in xrange(1, len(rowList) + 1): col = get_column_letter(col_idx) entrySheet.cell("%s%s" % (col, row)).value = str(rowList[col_idx - 1]) wb.save(filename=path) def saveAsPDF(table, path): return def saveAsXML(table, path): return def saveAsHTML(table, path): return if __name__ == "__main__": print "hello" dummyTable = idLogTable(["id", "username", "category", "blabla", "created"]) dummyTable.setHeaders(["id", "username", "category", "content", "created"]) dummyTable.addRow([1, "alpsayin", "farnell", "raspberry pi siparisleri verildi", datetime.now()]) dummyTable.addRow([2, "alpsayin", "farnell", "raspberry pi siparisleri elimize ulasti", datetime.now()]) dummyTable.addRow([3, "umutgultepe", "g-man", "some entry", datetime.now()], 6) # dummyTable.printTable() saveAsTXT(dummyTable, "alp.txt") saveAsXLSX(dummyTable, "alp.xlsx") print "bye bye"