error accessing 2 sheets of an excel

[Achyuth Pydmarri]

Hello all,

I am trying to access multiple sheets of a excel file at a time and facing issue, below is the code

  book = Spreadsheet.open(file_name)

  sheet1 = book.worksheets.find { |sheet| sheet.name == sheetname1 } 

  sheet2 = book.worksheets.find { |sheet| sheet.name == sheetname2 } 

5.upto(sheet2.rows.count) do |findrownum|

0.upto(sheet2.column_count) do |findcolnum|

end

end

error which i am getting is , not sure why it is not able to read sheet2 

NoMethodError: undefined method `rows' for nil:NilClass