Re: [web2py] Re: export data to OOO and Excel

Hello On request from user, I create a CSV file and an excel file. I would like to zip them both without creating additional temp file and serve them together to user. 2016-01-24 20:14 GMT+01:00 Massimo Di Pierro : > Can you tell us more. What do you want to zip?

[web2py] Re: export data to OOO and Excel

Is it possible to stram the file without creating a temp file and how can I zip it (without temp file) On Wednesday, July 1, 2015 at 4:45:36 PM UTC+2, Massimo Di Pierro wrote: > > i like handsontable. It displays data like excel and allows cut > to/from excel. It has a select all button > > On

[web2py] Re: export data to OOO and Excel

Can you tell us more. What do you want to zip? uploads/downloads should be automatically gzipped by browser. On Sunday, 24 January 2016 11:27:39 UTC-6, Yebach wrote: > > Is it possible to stram the file without creating a temp file and how can > I zip it (without temp file) > > On Wednesday,

[web2py] Re: export data to OOO and Excel

i like handsontable. It displays data like excel and allows cutpaste to/from excel. It has a select all button On Tuesday, 30 June 2015 18:52:27 UTC-5, 黄祥 wrote: yes, i know that CSV files can be open with excel, i think it's enough, if i need *.xls file i think, i can just open CSV files

[web2py] Re: export data to OOO and Excel

yes, i know that CSV files can be open with excel, i think it's enough, if i need *.xls file i think, i can just open CSV files with Excel save it on Excel with *.xls format thanks and best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: export data to OOO and Excel

just an idea why not put this on sqlform.grid as an export (seen csv, html, etc, but no excel on sqlform.grid export)? best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: export data to OOO and Excel

You can already open CSV files in Excel. Anyway, you can specify custom exporters in the grid via the exportclasses argument -- so you can use this if you implement a class for it. Anthony On Tuesday, June 30, 2015 at 6:06:59 PM UTC-4, 黄祥 wrote: just an idea why not put this on sqlform.grid

[web2py] Re: export data to OOO and Excel

@Philippe, Thanks a lot for your post. I'm interested in this. I did not understand what you mean by saying --- In Excel or OOo you link your spreadsheet to your URL. Linking excel or OO sheet to url means what? Do you want to say that an excel file to be opened by File--Open-- url of page? On

[web2py] Re: export data to OOO and Excel

I assessed both the libraries for exporting data to excel. python-excel is far better in terms of features. tablib doesn't have any feature for formatting of cells (such as fore/back color, font, border, etc.) Syntax of python-excel is more human-readable (especially the easysf class in it). I

[web2py] Re: export data to OOO and Excel

Sure. I will post here my observations after trying out the 2 excel libraries. Cheers :-) On Jul 26, 12:26 pm, Kenneth Lundström kenneth.t.lundst...@gmail.com wrote: Please let us know which one you found to be better. I m going to need to switch away from CSV to a real Excel format in  a

[web2py] Re: export data to OOO and Excel

Have a look at http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xls http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xlsx they use tablib (which includes xlwt, ...) http://docs.tablib.org/en/latest/index.html

Re: [web2py] Re: export data to OOO and Excel

How about a video tutorial exporting to excel? 2011/7/25 selecta gr...@delarue-berlin.de Have a look at http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xls http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/d68f1405e1c5/views/generic.xlsx they use tablib

[web2py] Re: export data to OOO and Excel

Say Dave, is xlwt included into current w2p version? Or I need to add the library by myself? On 22 июл, 05:05, Dave davidramsayreinh...@gmail.com wrote: I added these two lines and its working now!     response.headers['Content-Disposition']='attachment; filename=test.xls'    

[web2py] Re: export data to OOO and Excel

cyber, You can download it from here: http://www.python-excel.org/ If you are using ubuntu linux distribution you can install it like this: sudo apt-get install python-xlwt

[web2py] Re: export data to OOO and Excel

I added it to default.py controller, so it is working as an action there. When i go to that URL (.../default/excel_report), the file downloads as excel_report with no extension. I am testing using Mac OS, so not sure if that matters. The file is fine. When i rename it with the .xls extension

[web2py] Re: export data to OOO and Excel

I added these two lines and its working now! response.headers['Content-Disposition']='attachment; filename=test.xls' response.headers['Content-Title']='test.xls' Dave On Jul 21, 4:48 pm, Dave davidramsayreinh...@gmail.com wrote: I added it to default.py controller, so it is working as

[web2py] Re: export data to OOO and Excel

Hi Joaco, Thanks for your reply. The information given by you is very helpful. Thanks again. --Vineet On Jul 20, 4:56 pm, Joaquin Orbe joaquino...@gmail.com wrote: On Wed, Jul 20, 2011 at 5:45 AM, Vineet vineet.deod...@gmail.com wrote: I was looking for a library to export data to OpenOffice