try this:
from StringIO import StringIO
at the top of your file
Kevin Horn
On 7/19/07, new2turbo <[EMAIL PROTECTED]> wrote:
>
>
> Hello Remi
>
> I change the code as u mentioned but the error that i got was
>
> File "C:\project\KillerMobileApp\killermobileapp\DroppedCallsController
> \controllers.py", line 184, in excel
> file = StringIO()
> NameError: global name 'StringIO' is not defined
>
> ^^^^^^^^^^^^^^^^^^^^^^^
> my code now looks like this...
>
> @expose(content_type="application/excel")
> def excel(self, *args, **kw):
> records = AmountSpend.select(order_by=[AmountSpend.c.dt])
> try:
> if not (cherrypy.session['query_results']):
> raise redirect("list")
> except:
> raise redirect("list")
>
> records = cherrypy.session['query_results']
>
> """Import to a EXCEL SpreadSheet."""
> w = Workbook()
> ws = w.add_sheet('Query Results')
> ws.write(0, 0, 'Date')
> ws.write(0, 1, 'Switch')
> ws.write(0, 2, 'Cell')
> ws.write(0, 3, 'Count')
>
> rowcount = 0
>
> for row in records:
> rowcount += 1
> colcount = 0
> for col in row:
> try:
> ws.write(rowcount, colcount, col)
> except:
> ws.write(rowcount, colcount, '')
> colcount += 1
>
> file = StringIO()
> w.save(file)
> return file.getvalue()
>
>
> any idea what I am doing wrong here...
> I have been trying to figure this out for a long time.. and I am just
> about to give up.....
>
> Many Thanks....
>
>
>
> On Jul 19, 1:30 am, remi jolin <[EMAIL PROTECTED]> wrote:
> > Hello,
> > le 18.07.2007 18:15 new2turbo a écrit:> This is an application that i
> inherited and the function used is as
> > > follows....
> >
> > > temporaryFile = '/tmp/saved_worksheet-' + str(int(time.time() *
> > > 1000)) + '.xls'
> > > #tempararyFile = '/tmp/temp.xls'
> > > w.save(temporaryFile)
> >
> > > f = open(temporaryFile, 'r')
> >
> > > return f.read()
> >
> > > .................
> >
> > If you get the latestet version in svn, you'll be able to use StringIO
> > as the file and use the following that will allow you not to create an
> > actual file :
> > ...
> > file = StringIO()
> > w.save(file)
> > return file.getvalue()
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
