Method: Cuker::RubyXLFile#initialize

Defined in:
lib/cuker/helpers/writers/ruby_x_l_writer.rb

#initialize(file_name, template_file_name) ⇒ RubyXLFile

Returns a new instance of RubyXLFile.



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
83
84
85
86
87
88
89
90
91
92
93
 
# File 'lib/cuker/helpers/writers/ruby_x_l_writer.rb', line 56

def initialize file_name, template_file_name

  premade = File.basename(file_name) =~ /xlsm/
  # premade = true
  # premade = false
  # template_file_name = "simple_macro_template.xlsm"
  template_file_path = File.join File.dirname(__FILE__), template_file_name
  # template_file_name = './lib/cuker/helpers/writers/simple_macro_template.xlsm'
  # template_file_name = './lib/cuker/helpers/writers/demo_file2.xlsm'
  @file_name = premade ? template_file_path : file_name

  super @file_name
  @log.debug "Making new #{self.class} => #{@file_name}"

  @workbook = premade ? RubyXL::Parser.parse(@file_name) : RubyXL::Workbook.new
  # @workbook.add_worksheet('Acceptance Tests')
  # @workbook[0].sheet_name = 'Acceptance Tests'

  @worksheets = @workbook.worksheets

  # todo: delete sheet convenienve method
  # @workbook['test_id'].delete

  # delete_sheet 'null'
  locate_sheet 'test_id'

  # @worksheet = @workbook[0]
  @worksheet = @workbook['Acceptance Tests raw']


  @rows = sheet_rows.dup # starting Row
  @offset = 0 # starting Col

  # inserting a blank cell to make sure title format is not being copied
  @worksheet.add_cell(@rows.size, @offset, ' ')

  @file_name = file_name
end