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] <javascript:>> 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] <javascript:>. >> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
