class RubyXL::Parser

def self.parse(file_path, opts = {})
  self.new(opts).parse(file_path)
end

def data_only
  @data_only = true
  self
end

def initialize(opts = {})
  @data_only = opts.is_a?(TrueClass) || opts[:data_only]
  @skip_filename_check = opts[:skip_filename_check]
end

def parse(xl_file_path, opts = {})
  raise 'Not .xlsx or .xlsm excel file' unless @skip_filename_check ||
                                          %w{.xlsx .xlsm}.include?(File.extname(xl_file_path))
  dir_path = File.join(File.dirname(xl_file_path), Dir::Tmpname.make_tmpname(['rubyXL', '.tmp'], nil))
  ::Zip::File.open(xl_file_path) { |zip_file|
    zip_file.each { |f|
      fpath = File.join(dir_path, f.name)
      FileUtils.mkdir_p(File.dirname(fpath))
      zip_file.extract(f, fpath) unless File.exist?(fpath)
    }
  }
  workbook_file = Nokogiri::XML.parse(File.open(File.join(dir_path, 'xl', 'workbook.xml'), 'r'))
  wb = RubyXL::Workbook.parse(workbook_file)
  wb.filepath = xl_file_path
  wb.relationship_container = RubyXL::WorkbookRelationships.parse_file(dir_path)
  unless @data_only
    wb.media.load_dir(dir_path)
    wb.external_links.load_dir(dir_path)
    wb.external_links_rels.load_dir(dir_path)
    wb.drawings.load_dir(dir_path)
    wb.drawings_rels.load_dir(dir_path)
    wb.charts.load_dir(dir_path)
    wb.chart_rels.load_dir(dir_path)
    wb.printer_settings.load_dir(dir_path)
    wb.worksheet_rels.load_dir(dir_path)
    wb.chartsheet_rels.load_dir(dir_path)
    wb.macros.load_file(dir_path, 'vbaProject.bin')
    wb.theme.load_file(dir_path, 'theme1.xml')
    core_file = Nokogiri::XML.parse(File.open(File.join(dir_path, 'docProps', 'core.xml'), 'r'))
    wb.creator = core_file.css('dc|creator').children.to_s
    wb.modifier = core_file.css('cp|last_modified_by').children.to_s
    wb.created_at = core_file.css('dcterms|created').children.to_s
    wb.modified_at = core_file.css('dcterms|modified').children.to_s
    wb.document_properties = RubyXL::DocumentProperties.parse_file(dir_path)
    wb.calculation_chain = RubyXL::CalculationChain.parse_file(dir_path)
  end
  wb.shared_strings_container = RubyXL::SharedStringsTable.parse_file(dir_path)
  wb.stylesheet = RubyXL::Stylesheet.parse_file(dir_path)
  #fills out count information for each font, fill, and border
  wb.cell_xfs.each { |style|
    id = style.font_id
    wb.fonts[id].count += 1 #unless id.nil?
    id = style.fill_id
    wb.fills[id].count += 1 #unless id.nil?
    id = style.border_id
    wb.borders[id].count += 1 #unless id.nil?
  }
  wb.sheets.each_with_index { |sheet, i|
    sheet_rel = wb.relationship_container.find_by_rid(sheet.r_id)
    sheet_file_path = sheet_rel.target
    case File::basename(sheet_rel.type)
    when 'worksheet' then
      sheet_obj = RubyXL::Worksheet.parse(File.open(File.join(dir_path, 'xl', sheet_file_path)))
      sheet_obj.sheet_data.rows.each { |r|
        next if r.nil?
        r.worksheet = sheet
        r.cells.each { |c| c.worksheet = sheet_obj unless c.nil? }
      }
    when 'chartsheet' then
      sheet_obj = RubyXL::Chartsheet.parse(File.open(File.join(dir_path, 'xl', sheet_file_path)))
    end
    sheet_obj.workbook = wb
    sheet_obj.sheet_name = sheet.name
    sheet_obj.sheet_id = sheet.sheet_id
    wb.worksheets[i] = sheet_obj
  }
  FileUtils.remove_entry_secure(dir_path)
  return wb
end