invalid value for Integer(): ""

[codescaptain]

Thanks for filing an issue. Following these instructions will help us solve your problem sooner.

Steps to reproduce

Issue

I have an xlsx file and I want to check first sheet's first_row. But I get this error: invalid value for Integer(): "". If I edit the sheet name the error goes. I checked the solution: 478 and new version of roo gem.

The code is:

 def read_excel
    spread_sheet = Roo::Spreadsheet.open(file_path).sheet(0)
    if spread_sheet.first_row.blank? # throws the error (invalid value for Integer(): "")
      fail Errors::ExcelImport::EmptyFile
    end
    spread_sheet
  end

System configuration

Roo version:
2.7.1

Ruby version:
2.7.2

[patrickkulling]

Hey @codescaptain can you share the exact spreadsheet that you are using or create an example sheet that is reproducing this exact issue?