Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Simple writer for Office 2007 Excel files

branch: master

Fetching latest commit…

Octocat-spinner-32-eaf2f5

Cannot retrieve the latest commit at this time

Octocat-spinner-32 .bundle
Octocat-spinner-32 lib
Octocat-spinner-32 test
Octocat-spinner-32 .gitignore
Octocat-spinner-32 Gemfile
Octocat-spinner-32 Gemfile.lock
Octocat-spinner-32 LICENSE
Octocat-spinner-32 README
Octocat-spinner-32 Rakefile
Octocat-spinner-32 init.rb
Octocat-spinner-32 simple_xlsx_writer.gemspec
README
** Description **


  This is a simple no fuss generator for OpenXML aka XLSX files. No
  formatting, styles just raw content with a few basic datatypes
  supported. Produced output is tested to be compatible with

    - Open Office 3.2 series (Linux, Mac, Windows)
    - Neo Office 3.2 series (Mac)
    - Microsoft Office 2007 (Windows)
    - Microsoft Office 2010 (Windows)
    - Microsoft Office 2008 for Mac (versions 12.2.5 or above)
    - Microsoft Excel Viewer (Windows)
  
  Numbers of iWork '09 does not appear to support the inline string
  storage model prefered by this gem. Apple may release a fix for this
  eventually, I have avoided the more common shared string table
  method as it cannot be implemented in linear time.


** Sample **


  serializer = SimpleXlsx::Serializer.new("test.xlsx") do |doc|
    doc.add_sheet("People") do |sheet|
      sheet.add_row(%w{DoB Name Occupation})
      sheet.add_row([Date.parse("July 31, 1912"), 
                     "Milton Friedman", 
                     "Economist / Statistician"])
    end
  end
  
  file_with_data = serializer.zipfile

  serializer.cleanup

** License **


  See attached LICENSE for details.


** Credits **


  Written by Dee Zsombor: http://primalgrasp.com
  Funded by Harvest: http://www.getharvest.com
Something went wrong with that request. Please try again.