Contents

# Open Document Spreadsheet to text conversion

require 'zip/zip'
PlainTextExtractor.new {
  every :ods
  as 'application/vnd.oasis.opendocument.spreadsheet'
  aka "Open Document Format for spreadsheet"
  with {|source|
    Zip::ZipFile.open(source){|zipfile|
      zipfile.read("content.xml").split(/</).grep(/^text:(p|span)/).collect{|l|
        l.sub(/^[^>]+>/,'')
      }.join("\n")
    }
  }
  which_should_for_example_extract 'Cessna F-172P G-BIDF, serial number 2045', :from => 'weight_and_balance.ods'
}

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
picolena-0.1.2	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb
picolena-0.1.3	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb
picolena-0.1.4	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb
picolena-0.1.5	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb
picolena-0.1.6	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb
picolena-0.1.7	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb
picolena-0.2.0	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb
picolena-0.1.8	lib/picolena/templates/lib/plain_text_extractors/opendocument.spreadsheet.rb