Hello!
Thank you!
Where can I find the WIN32OLE excel documentation?

I did this and it works fine:

require 'win32ole'

# To load the WIN32OLE's built in constants in to the module
module EXCEL_CONST
end

begin
  # Create a WIN32OLE excel object
  excel = WIN32OLE::new('excel.Application')

  # Load all the constants
  WIN32OLE.const_load(excel, EXCEL_CONST)

  # Open the excel workbook
  filename = 'C:\Ruby\Lab\test.csv'
  excel.workbooks.open(filename)

  # Read the used range
  range = excel.activeworkbook.activesheet.usedrange

  # Convert the comma seperated data to the column
  range.TextToColumns(excel.activeworkbook.activesheet.Range("A1"),EXCEL_CONST::XlDelimited, 
EXCEL_CONST::XlDoubleQuote, false, false,false, true)
rescue
  # Raises any exception caught in begin section
  puts $!
ensure
  # Save the workbook and close
  excel.activeworkbook.save
  excel.activeworkbook.close(false)

  # Quit Excel
  excel.quit
end

-- 
Posted via http://www.ruby-forum.com/.