Problem with writing a file to excel with spreadsheet

I am trying to write excel file by using ruby 1.9 spreadsheet version 0.6.4.1 on windows. Everything is going ok, until I get to the book.writ开发者_开发百科e statement when I write book.write "c:/spreadsheet/excel-file.xls I keep getting the following error No such file or directory - c:/spreadsheet/excel-file.xls when i am runing it from the ruby console i get the error errono::EINVAL invalid argument. when i check in the path i see that a file was created but althought i write to it its empty

Can anyone tell me what should I do?

Thanks

---

Don't use windows!

According to http://pullmonkey.com/2008/02/19/errno-einval-invalid-argument/

STDOUT is nonexistent if you run mongrel as a service under windows, and errono::EINVAL is the result.

---

We had the same problem.

require 'rubygems'
require 'logger'
require 'spreadsheet'
require 'stringio'

workbook = Spreadsheet::Workbook.new
worksheet = workbook.create_worksheet
worksheet[0, 0] = "Hello, World!"

ostream = StringIO.new    

workbook.write (ostream)

ostream.rewind

File.open("aFile.xls","wb") do |f|
  f.write(ostream.read)
end

puts "Done!"

---

We decided that using libraries for excel is brittle. We use CSV with extension ".xls". Why? Because Excel doesn't show that nasty import box. It just opens it like a regular file. Users won't notice the difference.