Hello,
I tried to access a spreadsheet and then delete the spreadsheet-file. This failed because the file seems to be locked
until the file is not closed.
Is there an explicit 'close' for a spreadsheet file in the spreadsheet-gem
#
require 'spreadsheet'
book = Spreadsheet.open 'tmp.xls'
sheet = book.worksheet 0
sheet.each do |row| puts row[0] end
FileUtils.rm("tmp.xls")
c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:1309:in `unlink': Permission denied - tmp
.xls (Errno::EACCES)
from c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:1309:in `block in remove_fil
e'
from c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:1317:in `platform_support'
from c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:1308:in `remove_file'
from c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:776:in `remove_file'
from c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:559:in `block in rm'
from c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:558:in `each'
from c:/Ruby192/lib/ruby/1.9.1/fileutils.rb:558:in `rm'
from rm_test.rb:20:in `<main>' |