reading the api, save() there just takes a filename as an argument. there's a save_virtual_workbook() method that seems to support a similar feature (https://openpyxl.readthedocs.org/en/2.4/api/openpyxl.writer.excel.html?highlight=save_virtual_workbook#openpyxl.writer.excel.save_virtual_workbook)
On Monday, January 25, 2016 at 11:46:23 AM UTC+1, Yebach wrote: > > I had to change to openpyxl library > > Is it any different there? > > 2016-01-25 11:33 GMT+01:00 Niphlod <nip...@gmail.com <javascript:>>: > >> 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 <nip...@gmail.com>: >>> >>>> 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" <nip...@gmail.com> 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 >>>>>> web2py+un...@googlegroups.com. >>>>>> 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 >>>> web2py+un...@googlegroups.com. >>>> 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 >> web2py+un...@googlegroups.com <javascript:>. >> 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
