Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

currency number format using spreadsheet gem

Tags:

ruby

ruby-on-rails

gem

spreadsheet

I 'm using Spreadsheet gem to create excel sheet. how can I apply 'currency' number format to a particular cell ?

like image 417
Rutvij Pandya Avatar asked Apr 02 '12 08:04

Rutvij Pandya

1 Answers

Not tried it out but perhaps the following will point you in the right direction:

nb_format = Spreadsheet::Format.new  :number_format => '$#,###.##'
cell.set_format(0, nb_format)
like image 88
Yule Avatar answered Sep 29 '22 14:09

Yule
Sign in to Comment

Related questions

Asset:Precompile too verbose
How to add first Cucumber test to a Rails app
rspec user test gives "undefined local variable or method `confirmed_at' "
Readline errors prevent me running rails console
Using rails presenters - memoizable getting deprecated in 3.1 - use ||= instead?
gem.add_dependency Jeweler how do you format a git source?
Ruby on Rails 3: Devise::LdapAdapter.get_ldap_param undefined method error
Rails / Postgresql: How can I quickly group records using a datetime field by date in a specific time zone?
Creating a Factory association that defaults to nil?
Add vendor/assets/javascripts to my valid assets route
xmpp server and ruby on rails integration recommendations?
Where to put private documents to use in Rails applications?
RABL: JSON objects without root key
rails console with wirble?
Retrieve rails/devise current_user from Backbone
Is there an alternative to the Rails assets pipeline for Django?
When blocks are more useful than functions (ruby)?
where is my database located when using mysql in rails?
Unicorn.rb configuration depending on environment
Sanitize HTML and close incomplete tags

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!