closing excel file when done with it.

[pmneve]

Am using an excel spreadsheet as a data repository for variable values
in a rails application that executes various scripts that need
differing values for a given variable name.

If I try to edit the spreadsheet Excel tells me the file is in use and
can only be opened read-only. I have to completely stop the rails
application in order to get edit access to the spreadsheet.

Any way to get around this?

Am opening the spreadsheet thus:

datasheet = Excel.new(filename)

then parsing out the variables needed.

Can I use something like datasheet.close?

pat