this sounds very interesting to me too. I'm working at a financial institution and I'm facing a similar challenge of allowing the users to generate ad hoc reports and export those reports to excel. I've already implemented this requirement in PHP and I'm in the process of migrating these reporting systems to django. I'm very interested to see how you plan to do excel exports. I'll also be righting a library within the next two months to do that, because I haven't found anything that meets our requirements. If it's something you are interested in please shoot me an email. as far as importing data from excel sheets into a database check out www.python-excel.org and specifically their xlrd package that lets you read excel files and traverse the cells. You could use this to extract values and populate your database.
Marwan On Tue, Apr 5, 2011 at 7:03 PM, Gianluca Riccardi <riccardi.gianl...@gmail.com> wrote: > > > On 5 Apr, 17:06, alessio c <viandant...@gmail.com> wrote: >> Ciao, > > ciao Alessio, > >> >> yes I do. I need more basic stuff then that and I need tables. Think of this >> as tentative to reduce Excel use (which is killing me). >> >> I can use matplotlib or openflash if I want to go really fancy. However, now >> I need to set up the framework. After that, I have a platform from which I >> can run all my scripts. >> >> Let's say I have a database with invoice data from different subsidiaries. I >> want to be able to: 1) create different views (subsidiary level, macro >> level, invoice level, first 10 invoice, first 10 customers, etc.); 2) upload >> data from different formats (because people are lazy and it is impossible to >> impose a single format); 3) allow some users to upload data (to avoid them >> to send me excel files by email, this is a huge feature...); 4) allow some >> other users (managers) to access and download online reports (tables and >> graphs). >> >> Theoretically, when I get this right I am hoping to start a project on git. >> The main idea is to create a shared reporting tool. > > sounds like your going to have some fun ;) good luck, especially if > you can get rid of dealing with spreadsheets and automate it I'm sure > users will be happier(you at first;) > > if You start a public git repo i'd like to read your progresses > > regards, > Gianluca Riccardi > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
