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:
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: rubyexcel | RubyGems.org | your community gem host
Source & Readme: GitHub - VirtuosoJoel/RubyExcel: Spreadsheet storage class in Ruby with Excel-style API