@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 Jul 29, 1:14 pm, Philippe ENTZMANN <[email protected]> wrote: > 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 <[email protected]>: > > > > > 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 > > :-)- Hide quoted text - > > - Show quoted text -
