Home

Awesome

write_xlsx

Gem Version Build Status

gem to create a new file in the Excel 2007+ XLSX format, and you can use the same interface as writeexcel gem. write_xlsx is converted from Perl's module Excel::Writer::XLSX

Description

Reference doc : https://cxn03651.github.io/write_xlsx/

The WriteXLSX supports the following features:

write_xlsx uses the same interface as writeexcel gem.

Installation

Add this line to your application's Gemfile:

gem 'write_xlsx'

And then execute:

$ bundle

Or install it yourself as:

$ gem install write_xlsx

Synopsis

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

require 'rubygems'
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 # Add a 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)')

workbook.close

Copyright

Original Perl module was written by John McNamara(jmcnamara@cpan.org).

Converted to ruby by Hideo NAKAMURA(nakamrua.hideo@gmail.com) Copyright (c) 2012-2024 Hideo NAKAMURA.

See LICENSE.txt for further details.

Contributing to write_xlsx