README.rdoc in to_xls-0.0.3 vs README.rdoc in to_xls-0.1.0
- old
+ new
@@ -4,21 +4,27 @@
== Usage
@users = User.all
- #
- # defaults are export headers and all fields
- #
-
@users.to_xls
@users.to_xls(:headers => false)
@users.to_xls(:columns => [:name, :role])
@users.to_xls(:columns => [:name, {:company => [:name, :address]}])
@users.to_xls(:columns => [:name, {:company => [:name, :address]}], :headers => [:name, :company, :address])
+In order to send a file from the controller, you can save it on your server first:
+ @users.to_xls.write '/path/to/file/users.xls'
+ send_file '/path/to/file/users.xls'
+
+Alternatively you can use the method to_xls_data and send_data
+
+ send_data @users.to_xls_data, :filename => 'users.xls'
+
+The method to_xls_data accepts the same parameters as to_xls.
+
== Requirements
In config/initializers/mime_types.rb register the custom mime type.
Mime::Type.register "application/vnd.ms-excel", :xls
@@ -33,31 +39,21 @@
@users = User.all
respond_to do |format|
format.html
format.xml { render :xml => @users }
- format.xls { send_data @users.to_xls }
+ format.xls { send_data @users.to_xls_data, :filename => 'users.xls' }
end
end
-
- def show...
- def new...
- def edit...
- def create...
- def update...
- def destroy...
-
end
== Dependencies
spreadsheet gem
-
== Install
Include next gems in your environment.rb config file:
- config.gem 'spreadsheet'
config.gem 'to_xls'