Create a HTML view. I name the view with alias viewname.xls
![](http://photos1.blogger.com/blogger/1597/356/200/view_Prop.1.jpg)
![](http://photos1.blogger.com/blogger/1597/356/200/view_Prop2.1.jpg)
In the header add in the required tag for a table <tr> and <td>
![](http://photos1.blogger.com/blogger/1597/356/200/viewdetail.1.jpg)
Then create a $$ViewTemplate for the view. In the Content Type, set it as application/msexcel
![](http://photos1.blogger.com/blogger/1597/356/200/form_Prop.0.jpg)
Embed the view into the viewtemplate then add in the opening and closing table tag for the view.
![](http://photos1.blogger.com/blogger/1597/356/200/form.0.jpg)
When you call the view (http://server/dbpath/viewname.xls) it should prompt you to save the view. The saved file can be open in Excel. The similar method can be used to export to other format like words, etc.
Show-n-Tell Thursday