a ruby .ods parser and writer
this is a currently non-functioning parser and writer for OpenDocument Spreadsheet files written in Ruby, in active development.
the initial aim is to be able to create a complete spreadsheet from a dataset that conforms to a certain structure (typically an array of hashes, a la Sequel) in a few steps, in a way that I would want to create a spreadsheet 99% of the time. ideally it should look something like this:
book = Ted::Book.build('sample', '/path/to/folder/') sheet = book.add_sheet( name: 'sheet 1', a: {id: :name, name: 'Name'}, b: {id: :date, name: 'Date', format: :date}, c: {id: :charge, name: "What's that gonna cost ya?", format: :currency} d: {id: :percent, name: 'The Percentages', format: :percent} ) # lots of dataset-generating code dataset.each { |row| sheet.insert(row) } book.save
and you've got your sample.ods file.