Import CSV Data to Excel

ImportCSVtoExcel.rb

#! ruby -Ks
require "exlap"

filename2 = "template.xls"

path = "./hoge"

a_path = Dir.entries(path)

xl = Exlap.new

i = 0
Dir.foreach(path){|file|
	if(i > 1) then
		filename1 = File.join(path,"\\",file)
		wb1 = xl.book_opentext({'Filename'=>filename1, 
				       'DataType'=>XlDelimited,
				       'Tab'=>true, 'TextQualifier'=>XlTextQualifierNone,
				       'FieldInfo'=>[[1,XlTextFormat]]})
		wb2 = xl.book_open({'Filename' => filename2,'ReadOnly' => true})

		ss1 = wb1.select_sheet(1)
		ss2 = wb2.select_sheet(1)
		addr = ss1.UsedRange.Address 

		ss1.Range(addr).Copy(ss2.Range(addr))

		newfile = File.basename(filename1,".*") + ".xls"

		wb2.save newfile 
		wb1.close
		wb2.close
	end
	i+=1
}