I’ve no idea, so I do ask from my Ruby community.
I have an array with more elements. Then I need to store these elements
in Excel 2013. Say me the steps and requirements if any.
I’ve no idea, so I do ask from my Ruby community.
I have an array with more elements. Then I need to store these elements
in Excel 2013. Say me the steps and requirements if any.
On Tue, Jan 28, 2014 at 11:33 PM, Selvag R. [email protected]
wrote:
I’ve no idea, so I do ask from my Ruby community.
I have an array with more elements. Then I need to store these elements
in Excel 2013. Say me the steps and requirements if any.–
Posted via http://www.ruby-forum.com/.
Simplest might be writing out the Array as a comma-separated value file
(CSV) and then reading the file into excel.
The ruby CSV library might help:
http://ruby-doc.org/stdlib-2.0.0/libdoc/csv/rdoc/CSV.html
I haven’t tried it with Excel 2013 yet, but I wrote a gem called
“rubyexcel” to interact with Excel 2010: reading 2D arrays or excel
files, modifying the data, and then outputting to Excel or CSV.
It’s here if you want to give it a try.
Gem: https://rubygems.org/gems/rubyexcel
Source & Readme: https://github.com/VirtuosoJoel/RubyExcel
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.
Sponsor our Newsletter | Privacy Policy | Terms of Service | Remote Ruby Jobs