Hi Everyone


#1

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