inworksheet.each() { |row|
	begin
	linecounter = linecounter + 1
	# if you expect a String, you can pass an encoding and (iconv
	# required) the content of the cell will be converted.

	if (row.is_a?(Array))

		address = row.at(0).to_s('latin1')

		#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
	rescue
		print "There is a problem on line ", linecounter, " that could not be automatically solved.\nPlease check.\n"
	end
}