Hi Everyone

Rails
1

I need to generate the Excel Sheet through the Ruby On Rails.I have to
create the excel sheet with the database fields as headers and the data
in
the sheet

I installed the required gems…

  • gem install spreadsheet-excel -v = 0.3.5.1*

and i worte the code as

  • wb = Spreadsheet::Excel.new(“E:/RailsApps/application/sample.xls”)
    version = Excel::VERSION*

  •           f4 = Format.new(:num_format => "d mmm yyyy")
          f5 = Format.new(:num_format => 0x0f)
          wb.add_format(f4)
          wb.add_format(f5)*

  •            ws1 = wb.add_worksheet("employee")
          header = ['ID','Name','Designation','Salary','JoinDate']
              len = header.length - 1
         for k in 0..len do
           puts "Header of K #{header[k]}"
           ws1.write(0,k,header[k],f1)
         end

  •            rij = 1             #de gegevens worden getoond vanaf

de
2de rij
ws1.write(rij,0,employee.id)
ws1.write(rij,0,employee.name)
ws1.write(rij,0,employee.desg)
ws1.write(rij,0,employee.salary)
ws1.write(rij,0,employee.joindate)*

It is Showing the Following Error :

[DEPRECATED] By requiring ‘spreadsheet/excel’ you are loading a
Compatibility
layer which provides a drop-in replacement for
Spreadsheet::Excel
versions <= 0.3.5.1. This code will be removed in
Spreadsheet
version 1.0.0

Can Anyone PLease help me…