class GdocTransWriter

Public Class Methods

new(worksheet) click to toggle source
# File lib/transync/gdoc_trans/gdoc_trans_writer.rb, line 6
def initialize(worksheet)
  @worksheet = worksheet
end

Public Instance Methods

get_language_column_index(language) click to toggle source
# File lib/transync/gdoc_trans/gdoc_trans_writer.rb, line 27
def get_language_column_index(language)
  (2..@worksheet.num_cols).each do |column|
    return column if @worksheet[1, column].downcase == language.downcase
  end
  0
end
write(trans_hash) click to toggle source
# File lib/transync/gdoc_trans/gdoc_trans_writer.rb, line 10
def write(trans_hash)
  language    = trans_hash[:language]
  lang_column = get_language_column_index(language)
  abort("\u{2717} Language (#{language}) not found in worksheet '#{@worksheet.title}'!".colorize(:red)) if lang_column == 0

  row = 2

  trans_hash[:translations].keys.each do |trans_key|
    trans_value = trans_hash[:translations][trans_key]
    @worksheet[row, 1]           = trans_key
    @worksheet[row, lang_column] = trans_value
    row += 1
  end

  @worksheet.save
end