Ruby on Rails

On Sep 2, 2012, at 4:16 PM, renu mehta wrote:

> Hello,
>
> I am trying to use Spreadsheet gem to import some data in the db. I open
> a xls as
>
> member_file=Spreadsheet.open("#{RAILS_ROOT}/public/data/FAMILY-MEMBER.xls")
>
> but after that when I try to open the file using Excel I get an error
> that file is locked by another user for editing. Only way to release the
> lock is to kill the rails server. And there is no method to close the
> file in the gem. How do I solve this problem? 'Roo' also had the same
> issue. Is there any gem which I can use to import/export the data from
> excel which does not have these issues?

You won't have this issue in production, since the XLS file will never be opened by the server, I'm betting. You could simply duplicate the file before you open it, or you could look into the gem source and see if there's a missing your_file.close method somewhere.

Walter

>
> Thanks.
>
> --
> Posted via http://www.ruby-forum.com/.
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.