roo-rb / roo

Roo provides an interface to spreadsheets of several sorts.
MIT License
2.8k stars 502 forks source link

invalid value for Integer(): "" #574

Open codescaptain opened 2 years ago

codescaptain commented 2 years ago

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 commented 1 year ago

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