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
Reference doc : https://cxn03651.github.io/write_xlsx/
The WriteXLSX supports the following features:
write_xlsx uses the same interface as writeexcel gem.
Add this line to your application's Gemfile:
gem 'write_xlsx'
And then execute:
$ bundle
Or install it yourself as:
$ gem install write_xlsx
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
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.