Roo is a gem that lets you access contents of ,

1> Excel Spreadsheets(.xls), 2> Open office spread sheets(.ods), 3>Excel’s new format .xlsx and 4>Google spreadsheets.

Consider the following spreadsheet:


The above spreadsheet can be accessed using the following code:

#Require the roo library in the script

# To parse an excel worksheet, create an instance of Excel workbook

#To define the worksheet in the workbook

To know more about Roo, check out the following sites:


Enhanced by Zemanta