# Hi Everyone

**URL:** <https://www.ruby-forum.com/t/hi-everyone/152461>\
**Category:** Rails\
**Created:** [November 4, 2008, 8:15am UTC](https://www.ruby-forum.com/t/hi-everyone/152461 "2008-11-04T08:15:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hema\_mca](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/h/779978/32.png) [@hema\_mca](https://www.ruby-forum.com/u/hema_mca)\
**Post date:** [November 4, 2008, 8:15am UTC](https://www.ruby-forum.com/t/hi-everyone/152461/1 "2008-11-04T08:15:32Z")

</div>

I am Generating the Excel sheet using the ruby on rails  
I installed the gem spreadsheet/excel  
and the spreadsheet

and in my code i wrote the lines  
require ‘spreadsheet/excel’  
require ‘spreadsheet’

i used to format the excel sheet

wb = Spreadsheet::Excel.new(path) # creates the Excel sheet

ws = wb.add\_worksheet(“employee”) # creates the work sheet

and i defined the format as the

f5 = Format.new(:number\_format =\> “#,###,##0.00”)

then it is generating the error as  
Error : uninitialized constant GenerateExcelSheet::Format

then i kept as Spreadsheet::Format.new()

then the :bold,:num\_format and some fields are not working  
it is throwing the errror as  
Error in GenerateExcelSheet undefined method `bold=’ for  
#Spreadsheet::Format:0x4735574

i used to open the application in the netbeans …  
the database i used is sqlserver  
i copied the ADO.rb and it is throwing the exception --unable to load  
module  
dbi

Can anyone please help me… it is urgent