and how do i add excel file to zip?
On Jan 23, 2016 8:09 PM, "Niphlod" <niph...@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+unsubscr...@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 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.
