Hi, for creating graph reports I strongly suggest to use Pswave and latex. There is a big lack of software in this direction (have you ever thought how easy could it be to make an app for running catalogues?). Here we fill power point slides that have to be updated everymonth because data change...
Mostly, there are 2 types of reports: those to provide a clue to managers, those to be shown in presentations. For the first I would go for a web based solution (so you don't need to ask people to install python or R or Sage, etc.), for the second I would improve current libraries to create tabular data and pivots (which is the real strenght of excel) and work on a solution with latex or restructured text. I am not sure what would you like to do with excel, but once you have a nice way to handle tables, you have a solution right there. 2011/4/7 Chris Matthews <ch...@bbd.co.za> > Hi Marwan, > > I am considering an "Excel Export" button wherever I have a table (or > jQuery-UI grid). > > If you just want data sheets, before writing something, consider this: > xlwt 0.7.2 Library to create spreadsheet files compatible with MS Excel > 97/2000/XP/2003 XLS files, on any platform, with Python 2.3 to 2.6 > http://pypi.python.org/pypi/xlwt > > Example (using xwlt) to do export_selected_objects > http://davidmburke.com/tag/django/ > > Xwlt does not do graphs. > > There is probably a lot on graphs but I just saw this: > http://www.gnuplot.info/ and then also a Python interface > http://gnuplot-py.sourceforge.net/ > > Or > http://sourceforge.net/projects/django-dataplot/ > > > For a interesting take on spreadsheets: > Use Django and jQuery to create a spreadsheet application > http://www.ibm.com/developerworks/web/library/wa-django/?ca=drs- > > http://www.spreadsheetgear.com/ seemed cool but you net .Net and it will > cost you (not sure if it will save you some money). > > Regards > Chris > > -----Original Message----- > From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] > On Behalf Of Marwan Al-Sabbagh > Sent: 06 April 2011 16:59 > To: django-users@googlegroups.com > Subject: Re: Django app for data management and visualization > > 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. > > -- > 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.
