Wednesday, June 17, 2009

Work on excel file in ruby

To play with excel file through ruby, you have to insatll a gem.

> gem install 'parseexcel'

Now you need to require 'parseexcel'
so you code will look like:










as we know excel looks like a book where multiple pages exists.
so we have to create an instances accordingly.

so another snippet says:















like wise we can traverse through every worksheet.

enjoy working with excel.
cheers!

No comments:

Post a Comment