Method: ExcelValidator::ValidateFile#keyword_present?

Defined in:
lib/excel_validator.rb

#keyword_present?(sheet_number, keyword, case_sensitive = false) ⇒ Boolean

Checks if a keyword is present in the sheet

Returns:

  • (Boolean) 


91
92
93
94
95
96
97
98
99
 
# File 'lib/excel_validator.rb', line 91

def keyword_present?(sheet_number, keyword, case_sensitive=false )
  set_default_sheet(sheet_number)
  @file.first_row.upto @file.last_row do |row|
    @file.first_column.upto @file.last_column do |column|
      return true if ( (case_sensitive) ? @file.cell(row, column) == keyword : @file.cell(row, column).to_s.downcase == keyword.to_s.downcase )
    end
  end
  false
end