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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
# frozen_string_literal: true
module Axlsx
# Table
# @note Worksheet#add_table is the recommended way to create tables for your worksheets.
# @see README for examples
class Table
include Axlsx::OptionsParser
# Creates a new Table object
# @param [String] ref The reference to the table data like 'A1:G24'.
# @param [Worksheet] sheet The sheet containing the table data.
# @option options [Cell, String] name
# @option options [TableStyle] style
def initialize(ref, sheet, options = {})
@ref = ref
@sheet = sheet
@style = nil
@sheet.workbook.tables << self
@table_style_info = TableStyleInfo.new(options[:style_info]) if options[:style_info]
@name = "Table#{index + 1}"
parse_options options
yield self if block_given?
end
# The reference to the table data
# @return [String]
attr_reader :ref
# The name of the table.
# @return [String]
attr_reader :name
# The style for the table.
# @return [TableStyle]
attr_reader :style
# The index of this chart in the workbooks charts collection
# @return [Integer]
def index
@sheet.workbook.tables.index(self)
end
# The part name for this table
# @return [String]
def pn
format(TABLE_PN, index + 1)
end
# The relationship id for this table.
# @see Relationship#Id
# @return [String]
def rId
@sheet.relationships.for(self).Id
end
# The name of the Table.
# @param [String, Cell] v
# @return [Title]
def name=(v)
DataTypeValidator.validate :table_name, [String], v
if v.is_a?(String)
@name = v
end
end
# TableStyleInfo for the table.
# initialization can be fed via the :style_info option
def table_style_info
@table_style_info ||= TableStyleInfo.new
end
# Serializes the object
# @param [String] str
# @return [String]
def to_xml_string(str = +'')
str << '<?xml version="1.0" encoding="UTF-8"?>'
str << '<table xmlns="' << XML_NS << '" id="' << (index + 1).to_s << '" name="' << @name << '" displayName="' << @name.gsub(/\s/, '_') << '" '
str << 'ref="' << @ref << '" totalsRowShown="0">'
str << '<autoFilter ref="' << @ref << '"/>'
str << '<tableColumns count="' << header_cells.length.to_s << '">'
header_cells.each_with_index do |cell, index|
str << '<tableColumn id ="' << (index + 1).to_s << '" name="' << cell.clean_value << '"/>'
end
str << '</tableColumns>'
table_style_info.to_xml_string(str)
str << '</table>'
end
# The style for the table.
# TODO
# def style=(v) DataTypeValidator.validate "Table.style", Integer, v, lambda { |arg| arg >= 1 && arg <= 48 }; @style = v; end
private
# get the header cells (hackish)
def header_cells
header = @ref.gsub(/^(\w+?)(\d+)\:(\w+?)\d+$/, '\1\2:\3\2')
@sheet[header]
end
end
end
|
