Hi Marwan, Another option that I'll investigate is Google Chart Tools / Image Charts (aka Chart API) see http://code.google.com/apis/chart/ Regards Chris
-----Original Message----- From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Marwan Al-Sabbagh Sent: 07 April 2011 09:59 To: django-users@googlegroups.com Subject: Re: Django app for data management and visualization Hi Chris, thanks so much for all the information and the links, Its really helpful. I really like xlwt it's easy, fast, and powerful. I'll most likely start with allowing the user to export a table of results to an excel sheet where they can do whatever additional calculations, formatting, or analysis they want. I'm very interested in dealing with charts and graphs but I must say at this stage its more of a bonus then something our users are demanding. I'll keep you guys updated on my progress and would love to get all your feedback on the direction I'm taking and if it's something that any of you can use on your projects. looking forward to it. cheers, Marwan On Thu, Apr 7, 2011 at 9:50 AM, Chris Matthews <ch...@bbd.co.za> wrote: > 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. -- 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.
