I had to change to openpyxl library Is it any different there?
2016-01-25 11:33 GMT+01:00 Niphlod <[email protected]>: > watching at the API (http://xlwt.readthedocs.org/en/latest/api.html) it > seems that the save() method accepts a StringIO object. > so you just need to create another stream, call save() on it (which will > fill it with the needed content) and then use it in the zipfile > > On Sunday, January 24, 2016 at 5:13:44 PM UTC+1, Yebach wrote: >> >> I write to sheet with >> >> xls_dat = xlwt.Workbook(encoding='utf-8') >> sheet = xls_dat.add_sheet('sheet 1', cell_overwrite_ok = True) >> >> >> for i,rec in enumerate(workers): >> sheet.write(i + 1, 0, rec, style1) >> for a, rr in enumerate(dates): >> sheet.write(0, a+1, rr, date_format) >> for b, rrr in enumerate(dict_result): >> if (rrr["rw_worker_nick"] == rec) and rrr["rw_date"] >> == rr: >> sheet.write(i+1, a+1, rrr["rw_shift"]) >> >> >> id I would be creating a file xls_dat.save(fle) >> >> but since I want to stream everything i guess i have to do it differently >> >> thank you >> >> 2016-01-23 20:13 GMT+01:00 Niphlod <[email protected]>: >> >>> where is your excel file created ? >>> >>> On Saturday, January 23, 2016 at 8:10:18 PM UTC+1, Yebach wrote: >>>> >>>> and how do i add excel file to zip? >>>> On Jan 23, 2016 8:09 PM, "Niphlod" <[email protected]> wrote: >>>> >>>>> something is wrong with the code.... >>>>> >>>>> zipf.writestr('ExportAllWorkers.csv', rows) >>>>> >>>>> you can't pipe in to writestr "rows", which in your case is the >>>>> uber-rich Rows object spitted by DAL, as writestr expects a file-like >>>>> object or a string. >>>>> >>>>> Maybe what you're trying to do is to pipe in the default >>>>> representation of a Rows, which is a csv-like string.... but you need to >>>>> force it as str(rows). >>>>> >>>>> On Saturday, January 23, 2016 at 7:54:11 PM UTC+1, Yebach wrote: >>>>>> >>>>>> Hello >>>>>> >>>>>> I have the following problem >>>>>> >>>>>> I need to download a csv and an excel file together in a zip file >>>>>> >>>>>> I would like to skip the part to create file(s) on server and then >>>>>> serve it and remove it. >>>>>> >>>>>> I am getting an error while using >>>>>> >>>>>> import csv, cStringIO >>>>>> import zipfile >>>>>> exported_chunks_zip = cStringIO.StringIO() >>>>>> rows.export_to_csv_file(exported_chunks_zip, delimiter=';', >>>>>> quoting=csv.QUOTE_NONNUMERIC) >>>>>> zipf = zipfile.ZipFile(exported_chunks_zip, "w", >>>>>> compression=zipfile.ZIP_DEFLATED) >>>>>> zipf.writestr('ExportAllWorkers.csv', rows) >>>>>> >>>>>> must be string or read-only buffer, not Rows >>>>>> >>>>>> >>>>>> rows is value from db. >>>>>> >>>>>> Also when I try to make an excel file how do i serve it to zip? >>>>>> >>>>>> Any suggestions? >>>>>> >>>>>> Thank you >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>> Resources: >>>>> - http://web2py.com >>>>> - http://web2py.com/book (Documentation) >>>>> - http://github.com/web2py/web2py (Source code) >>>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "web2py-users" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/web2py/cIltc3IDPFA/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/web2py/cIltc3IDPFA/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Lep pozdrav >> >> Vid Ogris >> >> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/cIltc3IDPFA/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Lep pozdrav Vid Ogris -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
