I inherited this application and this is what the previous developer
has used...
-------Application is downloaded into and Excel SpreadSheet
@expose(content_type="application/excel")
def excel(self, *args, **kw):
"""List records in model"""
records = DroppedCalls.select(order_by=[DroppedCalls.c.dt])
log.debug('+++++++++++++++++++')
log.debug(args)
log.debug(kw)
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
temporaryFile = '/tmp/saved_worksheet-' + str(int(time.time() *
1000)) + '.xls'
#tempararyFile = '/tmp/temp.xls'
w.save(temporaryFile)
f = open(temporaryFile, 'r')
return f.read()
-----------------result------------
500 Internal error
The server encountered an unexpected condition which prevented it from
fulfilling the request.
Page handler: <bound method DroppedCallsController.excel of
<killermobileapp.DroppedCallsController.controllers.DroppedCallsController
object at 0x01822E70>>
Traceback (most recent call last):
File "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy
\_cphttptools.py", line 105, in _run
self.main()
File "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy
\_cphttptools.py", line 254, in main
body = page_handler(*virtual_path, **self.params)
File "<string>", line 3, in excel
File "c:\python24\lib\site-packages\TurboGears-1.0.2.2-py2.4.egg
\turbogears\controllers.py", line 334, in expose
output = database.run_with_transaction(
File "<string>", line 5, in run_with_transaction
File "c:\python24\lib\site-packages\TurboGears-1.0.2.2-py2.4.egg
\turbogears\database.py", line 354, in sa_rwt
retval = dispatch_exception(e,args,kw)
File "c:\python24\lib\site-packages\TurboGears-1.0.2.2-py2.4.egg
\turbogears\database.py", line 343, in sa_rwt
retval = func(*args, **kw)
File "<string>", line 5, in _expose
File "c:\python24\lib\site-packages\TurboGears-1.0.2.2-py2.4.egg
\turbogears\controllers.py", line 351, in <lambda>
mapping, fragment, args, kw)))
File "c:\python24\lib\site-packages\TurboGears-1.0.2.2-py2.4.egg
\turbogears\controllers.py", line 378, in _execute_func
output = errorhandling.try_call(func, *args, **kw)
File "c:\python24\lib\site-packages\TurboGears-1.0.2.2-py2.4.egg
\turbogears\errorhandling.py", line 73, in try_call
return func(self, *args, **kw)
File "F:\project\turbogears\KillerMobileApp\killermobileapp
\DroppedCallsController\controllers.py", line 171, in excel
w.save(temporaryFile)
File "build\bdist.win32\egg\pyExcelerator\Workbook.py", line 547, in
save
File "build\bdist.win32\egg\pyExcelerator\CompoundDoc.py", line 532,
in save
IOError: [Errno 2] No such file or directory: '/tmp/
saved_worksheet-1179506854703.xls'
Powered by CherryPy 2.2.1
Any idea what I am doing wrong here...
Is there any better way to do this....
On 18 Jul, 09:25, Marco Mariani <[EMAIL PROTECTED]> wrote:
> new2turbo ha scritto:
>
> > Hi,
> > I am trying to download the reports created into excel spreadsheet
> > using PyExcelerator but am having trouble.
>
> Please tell us more.
>
> > Has anyone has used it before
>
> Yep
>
> > or used any other method to do it...
>
> There has been a thread here on excel & word & ooo a few days ago, with
> alternative methods.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
