Contents

$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"
require 'axlsx'
xls = Axlsx::Package.new
wb = xls.workbook
wb.add_worksheet do |ws|
  img = File.expand_path('../image1.jpeg', __FILE__)
  ws.add_image(:image_src => img) do |image|
    image.start_at 2, 2
    image.end_at 5, 5
  end
end
wb.add_worksheet do |ws|
  img = File.expand_path('../image1.jpeg', __FILE__)
  ws.add_image(:image_src => img, :start_at => "B2") do |image|
    image.width = 70
    image.height = 50
  end
end
wb.add_worksheet do |ws|
  img = File.expand_path('../image1.jpeg', __FILE__)
  ws.add_image(:image_src => img, :start_at => [1,1]) do |image|
    image.end_at "E7"
  end
end



xls.serialize 'anchor.xlsx'

Version data entries

15 entries across 15 versions & 6 rubygems

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