DEV Community

Handling Excel File with Ruby on Rails

Ryo on December 18, 2017

Hello, everyone! Circumstance Of Excel With Ruby on Rails When you guys handle Excel File, there are two operations. Read Excel File ...
Collapse
 
beauxjames profile image
beauXjames

Being rather new to Ruby I have been trying to leverage RubyXL::Parser.parse_buffer. I have been attempting to use the open-uri library within the core however all of the permutations I have attempted result in some sort of failed attempt. I have no problems opening a file locally, as you have shown above. Have you had any luck with loading a file into a buffer and using this method?

Collapse
 
tejaravi89 profile image
tejaravi89

worksheet[y][x].change_contents(someValue) is not working, at the sametime p worksheet[y][x].value works

Collapse
 
ikeryo1182 profile image
Ryo

Oh... thank you!!!
I fixed it.