I m trying to generate reports. I already created the HTML table in a view and wanted to follow the approach talked about in "Exporting data to CSV and Excel in your Rails app".
页: 1
“根据我的项目,我将html表保存在档案中,而是将xls的延伸而不是html。 e. 表格。 然后,我把它送到有Excel mime型号的浏览器,Excel将打开这一档案,并将像html表一样编排表格,这样,你就能够取得大胆的标子和细胞背景。 “......
“我知道的最容易的方式是制作一张带有一张桌子的超文本文档,并把它延期。 尊重超文本标记,你可以像你想要的那样有线性突破,几乎或大端人不是问题,对头角加以界定,并且已经为建立档案提供了大量解决办法。
我怎么能把超文本的表格保存到档案中,并给它一个<代码>。 XLS 分机开放
Don t know if that s good advice or not. Personally I always stick to csv. But here s how you would do it.
class ExportController < ApplicationController
def export
html = build_html_table()
respond_to do |format|
format.xls { send_data html, :type => application/vnd.ms-excel; charset=utf-8; header=present , :filename => export.xls }
end
end
end
然后,在座标/初始器/mime_型号中,你需要证明:
Mime::Type.register application/vnd.ms-excel , :xls
collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...
We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...
As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...
I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?
I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...
I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml
guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...