Well, my suggestion would be forget the XLS format for the first iteration. Use CSV. If you're not concerned with formulas, that's the cleanest route, and included in the default python install. (csv module). I use it all the time for my load test frameworks I build.
It's not only very easy to use, but since it's VERY easy to export from excel, it shouldn't be much of a burden on the users. In a second iteration, if the license matches, you could do an import from xls format. On Mar 16, 8:03 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > This can be done. I need to check the licence of the xls readers. > > On Mar 16, 3:45 am, Vincent Borghi <vincent.borgh...@gmail.com> wrote: > > > > > Hello > > > I have used web2py to (quickly) implement a simple phone directory of > > customer contacts, > > for a small phone call center. > > Before that, people tried to maintain their contact information in an > > Excel spreadsheet > > that was exchanged thru mail and/or a windows sharedc folder... > > > ( Also note that I deal with two zope/plone sites, but I cannot (/don't > > want) to > > fully understand all the stuff that has been added/changed with the > > Plone 3 release > > and soon the Plone 4 one -- too complicated for me. > > However, as a CMS, Plone has advantages, and afaik there is nothing really > > production-ready in the web2py world ) > > > By the way: > > Feature request: xlstoweb2py > > =============================== > > For me, web2py could be the killer framework everywhere there are > > simple xls Excel files > > circulating among people who try to share and maintain information as > > they can (and > > they are numerous in many companies...). > > > In fact, in many cases, Excel sheets made by people involve no formula, but > > are > > just tables of static data. To deal with this frequent use case, I am > > looking for an > > "xlstoweb2py" utility that would take an xls file as input, and would > > automatically > > convert the data to an sqlite database, would build a base web2py > > application > > implementing CRUD features and perhaps some form of access control policy. > > The base app would be possibly ready to use, but as the resulting code > > would be > > web2py- and python-based, it would be easy for a > > developer/administrator (as me) to customize/enhance the generated app. > > > For me, such a "xlstoweb2py" would be a killer app. > > We could even imagine a web service oriented towards the end-user (not to > > developers), which would allow the user to upload an xls file, and in > > turn, would > > generate and host a (possibly customizable) web app for the user, to let him > > manage/share his data thru the web. > > > Regards > > Vincent Borghi > > > PS: thanks to web2py developers for theit great work! -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
