Generate chart using axlsx gem

Hello Rubies,

        I have generated the graph via axlsx gem of ruby. Follow the easy steps to generate 3D stacked bar graph.

Install axlsx gem via

   gem install axlsx

Lets, generate graph.rb file and than run ruby graph.rb

require "rubygems"

require "axlsx"

 p = Axlsx::Package.new
 wb = p.workbook

 wb.styles do |s|

    wb.add_worksheet(:name => "Bar graph demo") do |sheet|

        sheet.add_row ["A Simple Bar Chart"]

        sheet.add_chart(Axlsx::Bar3DChart, :start_at => "A1", :end_at => "F27", :grouping => :stacked, :show_legend => false, :shape => :box, :barDir => :col) do |chart|
         chart.valAxis.title = "Volumes"
         chart.catAxis.title = "Periods"
         chart.add_series :data => [1,2,3], :labels => ['Mar', 'Apr','May'], :colors => ['92D050', '92D050', '92D050']
         chart.add_series :data => [4,2,6], :labels => ['Mar', 'Apr', 'May'], :colors => ['FFFF00', 'FFFF00','FFFF00']

       end

   end  

end

file = File.open('/home/Desktop/graph.xlsx', 'w')
p.serialize(file)

Lets invoke ruby graph.rb on console and get the stacked bar chart.

Axlsx to support line break (\n)

Hello Rubies,
      Yesterday when i was playing with axlsx gem find something interesting. Requirement is need to allow line break in content. And current axlsx gem does not support that feature. So add this patch to your existing gem or either point directly to git repository b'coze that patch is unpublished as for now.

Add this line to axlsx1.2.3/lib/axlsx/workbook/worksheet/worksheet.rb

Remove line #500  

str.gsub(/[[:cntrl:]]/,'')

and Replace with

  if RUBY_VERSION == "1.8.7"
    nasty_control_char_matcher = Regexp.new("[\x01\x02\x03\x04\x05\x06\x07\x08\x1F\v\xE2]")
  else
    nasty_control_char_matcher = Regexp.new("[\x01\x02\x03\x04\x05\x06\x07\x08\x1F\v\u2028]")
  end

  str.gsub(nasty_control_char_matcher,'')

or

gem 'axlsx', '1.2.3', :git => 'git://github.com/randym/axlsx.git'

Hope this post is useful to you folks :).

jumping of browser window when using cursor keys

Hello Guys,

           There is wired problem when using auto completer on page and try to use arrow key for navigation.. it simply jump the browser window.

To over come this problem just add the patch in controls.js

replace line 212 to 214 with

    if(this.index > 0) {this.index--;}

    else {

      this.index = this.entryCount-1;

      this.update.scrollTop = this.update.scrollHeight;

    }

    selection = this.getEntry(this.index);

    selection_top = selection.offsetTop;

    if(selection_top < this.update.scrollTop){

    this.update.scrollTop = this.update.scrollTop-selection.offsetHeight;

    }

replace line 217 to 220 with

    if(this.index < this.entryCount-1) {this.index++;}

    else {

      this.index = 0;

      this.update.scrollTop = 0;

    }

    selection = this.getEntry(this.index);

    selection_bottom = selection.offsetTop+selection.offsetHeight;

    if(selection_bottom > this.update.scrollTop+this.update.offsetHeight){

      this.update.scrollTop = this.update.scrollTop+selection.offsetHeight;

    }

  

add line after 297

  this.update.scrollTop = 0;

In short by replacing two functions markPrevious() & markNext() will fix our problem.

Execute raw query and manual connection

Hello Rubies,

           Some time when we have huge query that it will be easy to use RAW SQL compare to ruby's active record query.

ActiveRecord::Base.connection.query <<-END

   /* Raw sql query */

  Select * from table where conditions

END

Custom connection and query

env = RAILS_ENV

config = YAML::load(File.open('config/database.yml'))

ActiveRecord::Base.establish_connection(config[env])

schemas = ActiveRecord::Base.connection.select_values("select * from pg_namespace where nspname not in ('public','information_schema') AND nspname NOT LIKE 'pg%'").inspect

Toggle div using ruby on rails

Hello Guys,

        Toggle is the function of prototype.js. We just have to use it to perform toggling.

eg.

html = "Toggle me <span id='collapse'>"

html << link_to_function(image_tag("arrow_normal.png", :style => 'border:none;'), "$('collapse').toggle();$('expand').toggle(); new Effect.Highlight('DIVID',{endcolor:'#ffffff', startcolor:'#ffffc8', duration:2.0}); return false;")

html << "</span>"    

html << "<span id='expand' style='display:none'>"

html << link_to_function(image_tag("arrow-down.png", :style => 'border:none;'), "$('collapse').toggle();$('expand').toggle();return false;")

html << "<div id='DIVID'> HELLO </div> </span>"

Initially it show the text as Toggle me with right arrow. but when you click on that i replace the right arrow to down arrow. And display the container area with text HELLO as per above eg.

undefined method

Hello Guys,

            When i was trying to configure browser cms along with ruby 1.8.7 and rails 2.3.11. It raise the error like `==': undefined method `name' for "abstract":String.

Than i have find the related solution. So follow below things.

Replace method ==(other) at gems/rails-2.3.11/lib/rails/gem_dependency.rb:277

def ==(other)
   if self.respond_to?(:name) && other.respond_to?(:name)
       self.name == other.name && self.requirement == other.requirement
    else
      if other.respond_to?(:requirement)
        self.requirement == other.requirement
      else
        false
      end
    end

end

Hope this will save you life :)

Replace double space with in javascript

Hello Guys,

        Last time when i was playing with double spaces.. found the interesting thing. When passing the double space string from javascript (view) to controller , it converts the valid space to non-breaking space.

Lets see the eg.

View: index.rhtml

a = "This  is the pen"

a.gsub("  ", "&nbsp;&nsbsp;")

<script language='javascript/text'>

 

  /* Now assign the value to input element by */

  $('txtid').value = <%= a %>;

 // Get value back encodeURIComponent($('txtid'))

</script>
 

at controller

def any_method

   # replace '\xC2\xA0' or '&nbsp;' with ' '

   params[:a].gsub("\xC2\xA0", " ").gsub("&nbsp;", " ")

end

Hope above article is helpful to you guys.

For more info follow: http://www.javascripter.net/faq/mathsymbols.htm

http://erisds.co.uk/code/getting-rid-of-non-breaking-spaces-nbsp