GitHub - maximkulkin/spreadsheet: Library to create ODF Spreadsheet files

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
lib		lib
samples		samples
MIT-LICENSE		MIT-LICENSE
README		README

Repository files navigation

Spreadsheet
===========

Library to generate OpenDocument Spreadsheet documents.

Example
=======

  sheet = Spreadsheet::Builder.new
  sheet.spreadsheet do
    sheet.table 'Time report (simple)' do
      sheet.row {
        sheet.cell 'Developing spreadsheet library'
        sheet.cell 80.0
      }
      sheet.row {
        sheet.cell 'Writing spreadsheet library documentation'
        sheet.cell 2.0
      }
    end
  
    sheet.table 'Time report (rich)' do
      sheet.column :width => '4in'
      sheet.column :width => '0.5in'
    
      sheet.header {
        sheet.row {
          sheet.cell 'Time report', :span => 2, :style => 'title'
        }
        sheet.row {
          sheet.cell 'Activity', :align => :left
          sheet.cell 'Hours'
        }
      }
    
      sheet.row {
        sheet.string_cell 'Developing spreadsheet library'
        sheet.numeric_cell 80.0
      }
      sheet.row {
        sheet.string_cell 'Writing spreadsheet library documentation'
        sheet.numeric_cell 2.0
      }
    end
  end

  File.open('time_report.ods', 'wb') { |f| f.write sheet.content! }


Copyright (c) 2009 Maxim Kulkin, released under the MIT license