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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
module Axlsx
# A worksheet hyperlink object. Note that this is not the same as a drawing hyperlink object.
class WorksheetHyperlink
# Creates a new hyperlink object.
# @note the preferred way to add hyperlinks to your worksheet is the Worksheet#add_hyperlink method
# @param [Worksheet] worksheet the Worksheet that owns this hyperlink
# @param [Hash] options options to use when creating this hyperlink
# @option [String] display Display string, if different from string in string table. This is a property on the hyperlink object, but does not need to appear in the spreadsheet application UI.
# @option [String] location Location within target. If target is a workbook (or this workbook) this shall refer to a sheet and cell or a defined name. Can also be an HTML anchor if target is HTML file.
# @option [String] tooltip The tip to display when the user positions the mouse cursor over this hyperlink
# @option [Symbol] target This is :external by default. If you set it to anything else, the location is interpreted to be the current workbook.
# @option [String|Cell] ref The location of this hyperlink in the worksheet
def initialize(worksheet, options={})
DataTypeValidator.validate "Hyperlink.worksheet", [Worksheet], worksheet
@worksheet = worksheet
@target = :external
options.each do |o|
self.send("#{o[0]}=", o[1]) if self.respond_to? "#{o[0]}="
end
yield self if block_given?
end
string_attr_accessor :display, :location, :tooltip
#Cell location of hyperlink on worksheet.
# @return [String]
attr_reader :ref
# Sets the target for this hyperlink. Anything other than :external instructs the library to treat the location as an in-workbook reference.
# @param [Symbol] target
def target=(target)
@target = target
end
# Sets the cell location of this hyperlink in the worksheet
# @param [String|Cell] cell_reference The string reference or cell that defines where this hyperlink shows in the worksheet.
def ref=(cell_reference)
cell_reference = cell_reference.r if cell_reference.is_a?(Cell)
Axlsx::validate_string cell_reference
@ref = cell_reference
end
# The relationship required by this hyperlink when the taget is :external
# @return [Relationship]
def relationship
return unless @target == :external
Relationship.new HYPERLINK_R, location, :target_mode => :External
end
# The id of the relationship for this object
# @return [String]
def id
return unless @target == :external
"rId#{(@worksheet.relationships_index_of(self)+1)}"
end
# Seralize the object
# @param [String] str
# @return [String]
def to_xml_string(str='')
str << '<hyperlink '
serialization_values.map { |key, value| str << key.to_s << '="' << value.to_s << '" ' }
str << '/>'
end
# The values to be used in serialization based on the target.
# location should only be specified for non-external targets.
# r:id should only be specified for external targets.
# @return [Hash]
def serialization_values
h = instance_values.reject { |key, value| !%w(display ref tooltip).include?(key) }
if @target == :external
h['r:id'] = id
else
h['location'] = location
end
h
end
end
end
|
