Contents

#!/usr/bin/env ruby
require 'bundler/setup'

if ::Bundler.definition.specs['debugger'].first
  require 'debugger'
elsif ::Bundler.definition.specs['ruby-debug'].first
  require 'ruby-debug'
end

require 'xlsx_writer'

@doc = XlsxWriter::Document.new

@sheet1 = @doc.add_sheet("Sheet1")
@sheet1.add_row(['a', 'a'])
@sheet1.freeze_top_left = 'A2'
@sheet1.add_row(['a', { :value => 'a', :faded => true, :type => :String }])
@sheet1.add_row(['a', 'a'])
# @sheet1.add_row(['foo', 'bar'])
@sheet1.add_autofilter 'A1:B1'

@sheet2 = @doc.add_sheet("Freeze")
@sheet2.add_row(['a', 'a'])
@sheet2.add_row(['false1', false])
@sheet2.freeze_top_left = 'A4'
@sheet2.add_row(['false2', {:value => false, :type => :Boolean}])
@sheet2.add_row(['false3', 'faLse'])
@sheet2.add_row(['true1', true])
@sheet2.add_row(['true2', {:value => true, :type => :Boolean}])
@sheet2.add_row(['true3', 'trUe'])

# @sheet2.add_row(['hello', 'world'])
# @sheet2.add_row(['yo', 'there'])
# @sheet2.add_row(['foo', 'bar'])
@sheet2.add_autofilter 'A1:B1'

FileUtils.mv @doc.path, 'foo.xlsx'
@doc.cleanup

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
xlsx_writer-0.3.1	foo.rb