# encoding: utf-8

wb = xlsx_package.workbook

wb.add_worksheet(name: "Subscribe") do |sheet|

  heading = sheet.styles.add_style(:b => true, :locked => true)
  body = sheet.styles.add_style(:font_name => '微軟正黑體')
  row = []
  row << t('email')
  row << t('language')

  sheet.add_row row, :style => heading

  @subscribers.each do |subscriber|
    row = []
    row << subscriber.email
    row << subscriber.language
    sheet.add_row row, :style => body, :types => [:string,:string]
  end
end

wb.add_worksheet(name: "Unsubscribe") do |sheet|

  heading = sheet.styles.add_style(:b => true, :locked => true)
  body = sheet.styles.add_style(:font_name => '微軟正黑體')
  row = []
  row << t('email')
  row << t('language')

  sheet.add_row row, :style => heading

  @unsubscribers.each do |subscriber|
    row = []
    row << subscriber.email
    row << subscriber.language
    sheet.add_row row, :style => body, :types => [:string,:string]
  end
end