View on GitHub

WriteXLSX

ruby gem for generating XLSX file.

Download this project as a .zip file Download this project as a tar.gz file

CONTENTS

DESCRIPTION

The WriteXLSX rubygem can be used to create an Excel file in the 2007+ XLSX format.

The WriteXLSX and this document is ported from Perl module Excel::Wirter::XLSX. If you have any problem and question, please contact me.

The XLSX format is the Office Open XML (OOXML) format used by Excel 2007 and later.

Multiple worksheets can be added to a workbook and formatting can be applied to cells. Text, numbers, and formulas can be written to the cells. See Examples

This module cannot, as yet, be used to write to an existing Excel XLSX file.

WriteXLSX uses the same interface as the Writeexcel rubygem which produces an Excel file in binary XLS format. WriteXLSX supports all of the features of Writeexcel and in some cases has more functionality. For more details see “Compatibility with Writeexcel”.

The main advantage of the XLSX format over the XLS format is that it allows a larger number of rows and columns in a worksheet. The XLSX file format also produces much smaller files than the XLS file format.

SYNOPSIS

To write a string, a formatted string, a number and a formula to the first worksheet in an Excel workbook called ruby.xlsx:

require 'write_xlsx'

# Create a new Excel workbook
workbook = WriteXLSX.new('ruby.xlsx')

# Add a worksheet
worksheet = workbook.add_worksheet

#  Add and define a format
format = workbook.add_format
format.set_bold
format.set_color('red')
format.set_align('center')

# Write a formatted and unformatted string, row and column notation.
col = row = 0
worksheet.write(row, col, 'Hi Excel!', format)
worksheet.write(1, col, 'Hi Excel!')

# Write a number and a formula using A1 notation
worksheet.write('A3', 1.2345 )
worksheet.write('A4', '=SIN(PI()/4)')