Nothing important here, just washing some data...

swedishgrid.rb

require 'rubygems'
require 'iconv'
require 'roo'
require 'swedishgrid'

separator = "\t"

grid = SwedishGrid.new(:sweref99tm)

oo = Excel.new("Sverige - riskklass 1 o 2.xls")

oo.default_sheet = oo.sheets.first

columns = %w[Lopnr  Objektnamn	Id	MifoId	N-SWEREF-99	E-SWEREF-99	Lan	Kommun	Fastighet	Primar-Bransch	Branschklass	Branschkommentar	Status	Preciserad-Status	Restriktioner-finns-for-markanvandningen	Akut-objekt	Miljoriskomrade	Riskklass	Riskklass-var-siffra	Riskklass-var-text	Underlag/Metodik	Organisation/Myndighet	Motivering	Kommunicerad-efter-Identifiering	Kommunicerad-efter-Inventering	Ansvarig-finns	Tillsynsmyndighet]


columns.each do | column |
  print column, separator
end

print 'latitude', separator, 'longitude'
puts ""

2.upto(oo.last_row) do |line|
  lat = oo.cell(line,'E')
  long = oo.cell(line,'F')
  dec = grid.grid_to_geodetic(lat, long)

  1.upto(columns.size) do | column |
    val = oo.cell(line, column) || "N/A"
    val = val.delete("\n").delete("\t") if val.is_a? String
    print val, separator if val
  end
  print dec[0], separator, dec[1]
  puts ""
end