Tuesday 15 May 2012

How do I write combined (enumerated) lists in excel via django -



How do I write combined (enumerated) lists in excel via django -

i trying create programme using python , django publish table of generated primers in excel spreadsheet. currently, creates workbook worksheet not write primers , relavent fields cells. wondering if can give me hand. grateful.

below part of relavent code.

primera [keys] = filtered primeralist primerb [keys] = filtered_primerblist wb = xlwt.workbook() ws1 = wb.add_sheet('primera') ws2 = wb.add_sheet('primerb') iterate_ct_rownum = 0 iterate_ga_rownum = 0 keys in sequence_keylist: #dictionary of sequennces rownum, sublist in enumerate(primera[keys]): ws1.write(iterate_primera_rownum, 0, keys) column, value in enumerate(sublist): ws1.write(iterate_primera_rownum, column +1, value) iterate_primera_rownum += 1 rownum, sublist in enumerate(complete_nested_dic_ga[keys]): ws2.write(iterate_primerb_rownum, 0, keys) column, value in enumerate(sublist): ws2.write(iterate_primerb_rownum, column +1, value) iterate_primerb_rownum += 1 homecoming httpresponse(open('file.xls','r').read(), mimetype='application/ms-excel') #return response(open('file.xls','r').read(), #mimetype='application/ms-excel')

this works fine on command line cannot work in django app. help much appreciated.

django excel list xlwt

No comments:

Post a Comment