Hi Chris, there stuff looks pretty nice. I'll add that link to my research.
Marwan On Fri, Apr 8, 2011 at 9:22 AM, Chris Matthews <[email protected]> wrote: > 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: [email protected] [mailto:[email protected]] On > Behalf Of Marwan Al-Sabbagh > Sent: 07 April 2011 09:59 > To: [email protected] > 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 <[email protected]> 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: [email protected] [mailto:[email protected]] >> On Behalf Of Marwan Al-Sabbagh >> Sent: 06 April 2011 16:59 >> To: [email protected] >> 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 >> <[email protected]> wrote: >>> >>> >>> On 5 Apr, 17:06, alessio c <[email protected]> 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 [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> 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 [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
