blob: 883020050541471ad1e666171f45cee7fedda7ea (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
$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'
|
