Tuesday, August 29, 2006

How to export web data to MS Excel

Philippe GAUVIN wrote an good article on how to export web data to MS Excel. Basically the concept is to display the view as Comma Seperated View (CSV). Then use $$Viewtemplate to set the Content-Type as text/csv. Basically when you load the view, it should open in MS Excel (only for those pc which associate csv file with MS Excel). This is an easy and fast way to "export" the data out. Check out the article.

1 comment:

Sean Burgess said...

In the current set of applications I support, we export to excel using an agent that sets content-type to application/msexcel, content-disposition to attachment with an associated filename, and then spits out the data as an HTML table. This allows us to easily create exports/reports in the browser, excel, or word.