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