Class: XlsProcessor

Inherits:
Object
  • Object
show all
Defined in:
lib/localio/processors/xls_processor.rb

Class Method Summary collapse

Class Method Details

.load_localizables(platform_options, options) ⇒ Object

Raises:

  • (ArgumentError) 


6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
 
# File 'lib/localio/processors/xls_processor.rb', line 6

def self.load_localizables(platform_options, options)

  # Parameter validations
  path = options[:path]
  raise ArgumentError, ':path attribute is missing from the source, and it is required for xls spreadsheets' if path.nil?

  override_default = nil
  override_default = platform_options[:override_default] unless platform_options.nil? or platform_options[:override_default].nil?

  Spreadsheet.client_encoding = 'UTF-8'

  book = Spreadsheet.open path

  # TODO we could pass a :page_index in the options hash and get that worksheet instead, defaulting to zero?
  worksheet = book.worksheet 0
  raise 'Unable to retrieve the first worksheet from the spreadsheet. Are there any pages?' if worksheet.nil?

  # At this point we have the worksheet, so we want to store all the key / values
  first_valid_row_index = nil
  last_valid_row_index = nil

  for row in 0..worksheet.row_count
    first_valid_row_index = row if worksheet[row, 0].to_s.downcase == '[key]'
    last_valid_row_index = row if worksheet[row, 0].to_s.downcase == '[end]'
  end

  raise IndexError, 'Invalid format: Could not find any [key] keyword in the A column of the worksheet' if first_valid_row_index.nil?
  raise IndexError, 'Invalid format: Could not find any [end] keyword in the A column of the worksheet' if last_valid_row_index.nil?
  raise IndexError, 'Invalid format: [end] must not be before [key] in the A column' if first_valid_row_index > last_valid_row_index

  languages = Hash.new('languages')
  default_language = nil

  for column in 1..worksheet.column_count
    col_all = worksheet[first_valid_row_index, column].to_s
    col_all.each_line(' ') do |col_text|
      default_language = col_text.downcase.gsub('*','') if col_text.include? '*'
      languages.store col_text.downcase.gsub('*',''), column unless col_text.to_s == ''
    end
  end

  raise 'There are no language columns in the worksheet' if languages.count == 0

  default_language = languages[0] if default_language.to_s == ''
  default_language = override_default unless override_default.nil?

  puts "Languages detected: #{languages.keys.join(', ')} -- using #{default_language} as default."

  puts 'Building terminology in memory...'

  terms = []
  first_term_row = first_valid_row_index+1
  last_term_row = last_valid_row_index-1

  for row in first_term_row..last_term_row
    key = worksheet[row, 0]
    unless key.to_s == ''
      term = Term.new(key)
      languages.each do |lang, column_index|
        term_text = worksheet[row, column_index]
        term.values.store lang, term_text
      end
      terms << term
    end
  end

  puts 'Loaded!'

  # Return the array of terms, languages and default language
  res = Hash.new
  res[:segments] = terms
  res[:languages] = languages
  res[:default_language] = default_language

  res

end