batch convert xls to csv

#!/usr/bin/env ruby
require 'rubygems'
require 'roo'

pwd       = File.dirname(__FILE__)

Dir.glob("#{pwd}/*.xls") do |file|
  file_path = "#{pwd}/#{file}"  
  file_basename = File.basename(file, ".xls")  
  xls = Excel.new(file_path)
  xls.to_csv("#{pwd}/#{file_basename}.csv")
end

Hi Man thanks for this snippet of code. when I ran it I got the below error

rooxls2csv.rb:10:in block in <main>': uninitialized constant Excel (NameError) from rooxls2csv.rb:7:inglob'
from rooxls2csv.rb:7:in `

'

I fixed it by adding Roo::Excel...... check below.

!/usr/bin/env ruby

require 'rubygems'
require 'roo'

pwd = File.dirname(FILE)

Dir.glob("#{pwd}/*.xls") do |file|
file_path = "#{pwd}/#{file}"
file_basename = File.basename(file, ".xls")
xls =Roo::Excel.new(file_path)
xls.to_csv("#{pwd}/#{file_basename}.csv")
end