Class: N42translation::XLSX

Inherits:
Object
  • Object
show all
Defined in:
lib/n42translation/xlsx.rb

Class Method Summary collapse

Class Method Details

.create(csv, output_path, project_name) ⇒ Object 



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
 
# File 'lib/n42translation/xlsx.rb', line 7

def self.create(csv, output_path, project_name)
  workbook = WriteXLSX.new(output_path)
  worksheet = workbook.add_worksheet(project_name)

  todo_format = workbook.add_format
  todo_format.set_bold
  todo_format.set_color('red')
  todo_format.set_align('left')

  default_format = workbook.add_format
  default_format.set_color('black')
  default_format.set_align('left')

  bold_format = workbook.add_format
  bold_format.set_bold

  csv.each_with_index do |line, row_index|
    contains_unfinished = line.any? {|translation| translation.include? "TODO: "}
    line.each_with_index do |translation, col_index|
      if contains_unfinished
        # write first column red if a translation is missing in column
        if col_index == 0 || (translation.include? "TODO: ")
          worksheet.write(row_index, col_index, translation, todo_format)
        else
          worksheet.write(row_index, col_index, translation, default_format)
        end
      else
        if col_index == 0 || row_index == 0
          # write bold in first col & row
          worksheet.write(row_index, col_index, translation, bold_format)
        else
          worksheet.write(row_index, col_index, translation, default_format)
        end
      end
    end
  end

  workbook.close
end