Contents

#!/usr/bin/env ruby -w -s
# -*- coding: utf-8 -*-
$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"

#```ruby
require 'axlsx'
p = Axlsx::Package.new
p.workbook.add_worksheet(:name => 'Excel 2010 comments') do |sheet|
  sheet.add_row ['Cell with visible comment']
  sheet.add_row
  sheet.add_row
  sheet.add_row ['Cell with hidden comment']

  sheet.add_comment :ref => 'A1', :author => 'XXX', :text => 'Visibile'
  sheet.add_comment :ref => 'A4', :author => 'XXX', :text => 'Hidden', :visible => false
end
p.serialize('excel_2010_comment_test.xlsx')

Version data entries

15 entries across 15 versions & 6 rubygems

Version	Path
bonio-axlsx-2.2.3	examples/2010_comments.rb
caxlsx-3.0.2	examples/2010_comments.rb
caxlsx-2.0.2	examples/2010_comments.rb
caxlsx-3.0.1	examples/2010_comments.rb
caxlsx-3.0.0	examples/2010_comments.rb
axlsx-alt-3.0.1	examples/2010_comments.rb
axlsx-alt-3.0.0	examples/2010_comments.rb
axlsx-3.0.0.pre	examples/2010_comments.rb
bonio-axlsx-2.2.2	examples/2010_comments.rb
bonio-axlsx-2.2.1	examples/2010_comments.rb
dg-axlsx-2.1.0	examples/2010_comments.rb
axlsx-2.1.0.pre	examples/2010_comments.rb
l_axlsx-2.0.1	examples/2010_comments.rb
axlsx-2.0.1	examples/2010_comments.rb
axlsx-2.0.0	examples/2010_comments.rb