inworksheet.each() { |row|
	begin
	linecounter = linecounter + 1

		address = row.at(0).to_s('latin1') if (row.is_a?(Array))
	rescue
		errors = true
		print "\nThere is a problem on line ", linecounter, " that could not be automatically solved. Please check in the source file.\n"
		next
	end

	unless (address == nil)
		#correct emailaddresses:
		address = address.strip
		address = address.gsub(/\s/, "")

		email = address[/[a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.([a-zA-Z]{2,4})/]

		if (email != nil)
			namepart = email.split(/@/)
			domain = namepart[1]
			if (namepart[0] != nil)
				names = namepart[0].split(/[._-]/)
				names.compact
				names.delete_if {|x| x =="."}
				names.delete_if {|x| x =="_"}
				names.delete_if {|x| x =="-"}
				names = names.collect! {|name|
					name.capitalize
				}
				names.each{|name|
					outworksheet.write(linecounter, names.index(name)+2, name)
				}
			end

			if (domain != nil)
				country = Countrycodes[domain.split(".").last.upcase]
				outworksheet.write(linecounter, 1, country, format)
			end

			outworksheet.write(successcounter, 0, email, format)

			successcounter = successcounter + 1
		elsif (address == "")
			emptycounter = emptycounter + 1
		else
			failedcounter = failedcounter + 1
			puts address
		end
		totalcounter = totalcounter + 1
	end
}