Skip to content
ruby gem for Write to a cross-platform Excel binary file.
Ruby HTML Other
Pull request Compare This branch is 434 commits behind master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.



Write to a cross-platform Excel binary file.

Recent Changes


  • Bug fix. Worksheet#write_comment() doesn't work when value arg is numeric.

  • Bug fix. TRUE/FALSE in formula was misundarstood as :NAME.

  • Bug fix. Worksheet#close() mis-handled @colinfo.

  • Bug fix. Worksheet#set_row() grbit mis-calculate by param hidden.

  • convert examples.(formula_result, indent, merge6, outline, outline_collapsed, panes, right_to_left, row_wrap)


  • Bug fix. add_comment doesn't work.

  • convert examples.(chess, colors, comment1, comment2)


  • add recent change in this document.


  • Bug fix. defined name doesn't work.

  • use jeweler to maintain gem.


  • Chart support(Area, Bar, Column, Line, Pie, Scatter, Stock).

  • Document added. See rdoc in your installed gem directory.

  • Change Class name from 'Spreadsheet::WriteExcel' to 'WriteExcel'.

  • many bug fix.


This library is converted from Spreadsheet::WriteExcel module of Perl.

Some examples written in perl was successfully converted to Ruby. But this library written in Ruby has many bugs, I think.

Original description is below:

The Spreadsheet::WriteExcel module can be used to create a cross-
platform Excel binary file. Multiple worksheets can be added to a
workbook and formatting can be applied to cells. Text, numbers,
formulas, hyperlinks and images can be written to the cells.

TThe Excel file produced by this module is compatible with 97,
2000, 2002, 2003 and 2007.

The module will work on the majority of Windows, UNIX and
Macintosh platforms. Generated files are also compatible with the
spreadsheet applications Gnumeric and

This module cannot be used to read an Excel file.


See rdoc's WriteExcel class document. You must save source file in UTF8 and run ruby with -Ku option or set $KCODE='u'.

Example Code:

require 'writeexcel'

# Create a new Excel Workbook
workbook ='ruby.xls')

# Add worksheet(s)
worksheet  = workbook.add_worksheet
worksheet2 = workbook.add_worksheet

# Add and define a format
format = workbook.add_format

# write a formatted and unformatted string.
worksheet.write(1, 1, 'Hi Excel.', format)  # cell B2
worksheet.write(2, 1, 'Hi Excel.')          # cell B3

# write a number and formula using A1 notation
worksheet.write('B4', 3.14159)
worksheet.write('B5', '=SIN(B4/4)')

# write to file

Difference with Perl module


    • accept default format parameter such as new('foo.xls', :font => 'Roman', :size => 12)

  • Unary minus is supported, but it will be stored as '-1*'. ex) '=-1' -> '=-1*1', '=-SIN(PI()/2)' => '=-1*SIN(PI()/2)'

  • Worksheet.write(row, col, token, format)

    • if token.kind_of?(Numeric) then call write_number, if token.kind_of?(String) then not call write_number().

  • Worksheet.keep_leading_zeros()

    • ignore. if write 0001, use string such as write(1,2, '0001')

  • and .…..


You must save source file in UTF8 and run ruby with -Ku option or set $KCODE='u' when use urf8 string data.


  • ruby 1.8


Original was written in Perl by John McNamara (

Convert to ruby by Hideo Nakamura ( Copyright © 2009-2010 Hideo NAKAMURA. See LICENSE for details.


same as Ruby.

Note on Patches/Pull Requests

  • Fork the project.

  • Make your feature addition or bug fix.

  • Add tests for it. This is important so I don't break it in a future version unintentionally.

  • Commit, do not mess with rakefile, version, or history. (if you want to have your own version, that is fine but bump version in a commit by itself I can ignore when I pull)

  • Send me a pull request. Bonus points for topic branches.

Something went wrong with that request. Please try again.