How do I create Google spreadsheet from my html table?

[quinc...@gmail.com]

My javascript application running on Google app engine creates a html
table.
How do I create a Google spreadsheet from the html table?

[quinc...@gmail.com]

[Barry Hunter]

At the same time it renders the table, it could send the data to a spreadsheet?

http://code.google.com/apis/spreadsheets/

> --
> You received this message because you are subscribed to the Google Groups "Google App Engine" group.
> To post to this group, send email to google-a...@googlegroups.com.
> To unsubscribe from this group, send email to google-appengi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
>
>

[voscausa]

submit your data to app engine and and download the data as csv. With Excel you can read the CSV

To download the data you van use :

        self.response.headers['Content-Type'] = 'application/csv'

        self.response.headers['Content-Disposition'] = 'attachment; filename=%s.csv' % (file_batch)

        after that you can send the rows with : self.response.out.write

In my case I also added a UTF-8 BOM before the header :

self.response.out.write(codecs.BOM_UTF8.decode('utf-8') + csv_header + '\n')