class RewriteWorksheetNames

Public Class Methods

rewrite(worksheet_names,relationships,output) click to toggle source
# File src/rewrite/rewrite_worksheet_names.rb, line 3
def self.rewrite(worksheet_names,relationships,output)
  self.new.rewrite(worksheet_names,relationships,output)
end

Public Instance Methods

rewrite(worksheet_names,relationships,output) click to toggle source

Expects worksheet names in the form: nametrelationship_idn Expects relationships in the form: relationship_idtfilenamen Outputs worksheet names in the form: nametfilenamen Only includes actual worksheets (ignores chartsheets and the like)

# File src/rewrite/rewrite_worksheet_names.rb, line 14
def rewrite(worksheet_names,relationships,output)
  relationships = Hash[relationships.readlines.map { |line| line.split("\t")}]
  worksheet_names.each_line do |line|
    rid, name = line.split("\t")
    filename = relationships[rid].strip
    next unless filename =~ /^worksheets/i
    output.puts "#{name.strip}\t#{filename}"
  end
end