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 <javascript:>>:
>
>> 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 <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.
