The way I'm using is this:
I have a template file with something like
${grid(data)}
where grid is a DataGrid object and data is a list of database records
from SqlAlchemy
To serve this I'm doing:
@expose('project.templates.excel',content_type="application/vnd.ms-
excel")
this way the browser thinks it's receiving a true MS-Excel file but
actualy receiving an html table (from DataGrid) - turns out excel
proceses this just fine!
good luck
Rotem
On Nov 4, 7:10 pm, Sean DiZazzo <[email protected]> wrote:
> Hi,
>
> I'm trying to make a generic widget that can export whatever records
> are being shown in a DataGrid. I have the code to generate the file
> and to serve it up to the user using cherrypy, but I'm brain farting
> on how to pass the records in to the widget. I want to just be able
> to pass them in via the template like you do with a datagrid. ie $
> {export_records(records).display()}.
>
> I started trying to make a simple form with only the submit button,
> but then I realized I couldn't get the records attached to the form.
> I could do it with a form the way I was trying to do it if I
> reselected the records from the database again, but I want to just
> have the button use the same records that were already filtered down
> by the controller method. All I need the button to do is call a
> function with the passed in records, and I should be able to create
> the spreadsheet and serve it up. I think I am missing something
> obvious. Any advice?
>
> ~Sean
--
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.
