Rails中导出excel的快速简便的方法

最新推荐文章于 2019-09-26 23:22:04 发布

iteye_3589

最新推荐文章于 2019-09-26 23:22:04 发布

阅读量88

点赞数

文章标签： Excel Rails Ruby Cache HTML

本文链接：https://blog.csdn.net/iteye_3589/article/details/81755636

版权

controller:


  def to_excele
    headers['Content-Type'] = "application/vnd.ms-excel"
    headers['Content-Disposition'] = 'attachment; filename="report.xls"'
    headers['Cache-Control'] = ''
    @posts = Post.find(:all)
    render :layout => false
  end

views:

<html>
  <head>
  <meta http-equiv="Content-Type" content="charset=utf-8" />
  <title>excele表格</title>
  </head>
  <body>
<table border="1">
  <tr><td>标题</td></tr>
  <%@posts.each do |post|%>
<tr>
  <td><%=post.title%></td>
</tr>
<% end %>
</table>
</body>
</html>