Another solution : You can simply link data to a Excel/OOo spreadsheet. >From web2Py, you only need a view with a HTML table of your data. In Excel or OOo you link your spreadsheet to your URL.
Advantages : - you don't have to build your Excel file in w2p (no extra module) - you can link your data with different worksheets - you can refresh data in Excel/OOo (manual or automatic) - layout and formatting is preserved at each refresh 2011/7/20 Vineet <vineet.deod...@gmail.com>: > I was looking for a library to export data to OpenOffice & Excel. > I found 2 such open source projects. > > For OOO --- > http://ooolib.sourceforge.net/ > > For Excel --- > http://www.python-excel.org/ > > What I intend to do is, keep the classes in web2py folder, import the > classes in controller, then parse the result fetched from MySQL and > export the data to OOO or Excel. > > Reasons as to why I am posting it here are-- > > 1] Whether anybody has tried these and knows if these are mostly bug- > free (may not be 100%) > 2] Whether anybody knows any other (better suited, may be) projects > like these (considering integration into w2p, feature-rich, tested, > etc.) > 3] To share my findings with the list (might be useful to someone > new). > > Cheers > :-) >