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

2016-01-25 Thread Vid Ogris
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? uploads/downloads should be > au

[web2py] Re: export data to OOO and Excel

2016-01-24 Thread Massimo Di Pierro
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, Jul

[web2py] Re: export data to OOO and Excel

2016-01-24 Thread Yebach
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&paste > to/from excel. It has a select all button >

[web2py] Re: export data to OOO and Excel

2015-07-01 Thread Massimo Di Pierro
i like handsontable. It displays data like excel and allows cut&paste 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

2015-06-30 Thread 黄祥
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) - http://gith

[web2py] Re: export data to OOO and Excel

2015-06-30 Thread Anthony
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.gr

[web2py] Re: export data to OOO and Excel

2015-06-30 Thread 黄祥
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) - https://code.google.com/p/web2

[web2py] Re: export data to OOO and Excel

2011-07-29 Thread Vineet
@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-- "? On Jul

[web2py] Re: export data to OOO and Excel

2011-07-28 Thread Vineet
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).

[web2py] Re: export data to OOO and Excel

2011-07-26 Thread Vineet
Sure. I will post here my observations after trying out the 2 excel libraries. Cheers :-) On Jul 26, 12:26 pm, Kenneth Lundström 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 couple of months. > > Kenneth

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

2011-07-26 Thread Kenneth Lundström
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 couple of months. Kenneth @selecta, thanks for directing to 'tablib'. It is also a good choice. I am assessing whether to use 'excel-python' or 'tablib'. :-| On Jul 2

[web2py] Re: export data to OOO and Excel

2011-07-25 Thread Vineet
@selecta, thanks for directing to 'tablib'. It is also a good choice. I am assessing whether to use 'excel-python' or 'tablib'. :-| On Jul 25, 1:52 pm, António Ramos wrote: > How about a video tutorial exporting to excel? > > 2011/7/25 selecta > > > > > Have a look at > > >http://tlc2.hg.sourcef

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

2011-07-25 Thread António Ramos
How about a video tutorial exporting to excel? 2011/7/25 selecta > 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 x

[web2py] Re: export data to OOO and Excel

2011-07-25 Thread selecta
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

[web2py] Re: export data to OOO and Excel

2011-07-23 Thread Alexandre Augusto
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

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

[web2py] Re: export data to OOO and Excel

2011-07-21 Thread Dave
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 wrote: > I added it to default.py controller, so it is working as an action > there. > > When

[web2py] Re: export data to OOO and Excel

2011-07-21 Thread Dave
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

2011-07-20 Thread Vineet
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 wrote: > On Wed, Jul 20, 2011 at 5:45 AM, Vineet wrote: > > I was looking for a library to export data to OpenOffice & Excel. > > I found 2 such open source proj