<commit_before># README for Roo

This is the semi-official roo repository. I've been unable to contact the maintainer so this
repository should allow us to continue in the interim. If you'd like to contribute I'm happy 
to pull your changes in and will be making periodic releases from here until we can get
the gems on RubyForge. 


## Installation

    # Run the following if you haven't done so before:
    gem sources -a http://gems.github.com
    # Install the gem:
    sudo gem install roo

## Usage:

    require 'rubygems'
    require 'roo'

    s = Openoffice.new("myspreadsheet.ods")      # creates an Openoffice Spreadsheet instance
    s = Excel.new("myspreadsheet.xls")           # creates an Excel Spreadsheet instance
    s = Google.new("myspreadsheetkey_at_google") # creates an Google Spreadsheet instance
    s = Excelx.new("myspreadsheet.xlsx")         # creates an Excel Spreadsheet instance for Excel .xlsx files

    s.default_sheet = s.sheets.first  # first sheet in the spreadsheet file will be used

    # s.sheet is an array which holds the names of the sheets within
    # a spreadsheet.
    # you can also write
    # s.default_sheet = s.sheets[3] or
    # s.default_sheet = 'Sheet 3'<commit_msg>update with github gem<commit_after># README for Roo

This is the semi-official roo repository. I've been unable to contact the maintainer so this
repository should allow us to continue in the interim. If you'd like to contribute I'm happy 
to pull your changes in and will be making periodic releases from here until we can get
the gems on RubyForge. 


## Installation

    # Run the following if you haven't done so before:
    gem sources -a http://gems.github.com
    # Install the gem:
    sudo gem install hmcgowan-roo

## Usage:

    require 'rubygems'
    require 'hmcgowan-roo'

    s = Openoffice.new("myspreadsheet.ods")      # creates an Openoffice Spreadsheet instance
    s = Excel.new("myspreadsheet.xls")           # creates an Excel Spreadsheet instance
    s = Google.new("myspreadsheetkey_at_google") # creates an Google Spreadsheet instance
    s = Excelx.new("myspreadsheet.xlsx")         # creates an Excel Spreadsheet instance for Excel .xlsx files

    s.default_sheet = s.sheets.first  # first sheet in the spreadsheet file will be used

    # s.sheet is an array which holds the names of the sheets within
    # a spreadsheet.
    # you can also write
    # s.default_sheet = s.sheets[3] or
    # s.default_sheet = 'Sheet 3'
{'fraction_non_alphanumeric': 0.06868686868686869, 'fraction_numerical': 0.0016161616161616162, 'mean_word_length': 3.1824324324324325, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5473744', 'n_tokens_mistral': 755, 'n_tokens_neox': 689, 'n_words': 300}