Class: Axlsx::SharedStringsTable
- Inherits:
-
Object
- Object
- Axlsx::SharedStringsTable
- Defined in:
- lib/axlsx/workbook/shared_strings_table.rb
Overview
Serialization performance is affected by using this serialization method so if you do not need interoperability
The Shared String Table class is responsible for managing and serializing common strings in a workbook. While the ECMA-376 spec allows for both inline and shared strings it seems that at least some applications like iWorks Numbers and Google Docs require that the shared string table is populated in order to interoperate properly. As a developer, you should never need to directly work against this class. Simply set ‘use_shared_strings’ on the package or workbook to generate a package that uses the shared strings table instead of inline strings. it is recomended that you use the default inline string method of serialization.
Instance Attribute Summary collapse
-
#count ⇒ Integer
readonly
The total number of strings in the workbook including duplicates Empty cells are treated as blank strings.
-
#unique_cells ⇒ Object
readonly
An array of unique cells.
Instance Method Summary collapse
-
#initialize(cells) ⇒ SharedStringsTable
constructor
Creates a new Shared Strings Table agains an array of cells.
-
#to_xml_string ⇒ String
Serializes the object.
-
#unique_count ⇒ Integer
The total number of unique strings in the workbook.
Constructor Details
#initialize(cells) ⇒ SharedStringsTable
Creates a new Shared Strings Table agains an array of cells
31 32 33 34 35 36 37 |
# File 'lib/axlsx/workbook/shared_strings_table.rb', line 31 def initialize(cells) cells = cells.flatten.reject { |c| c.type != :string || c.value.nil? || c.value.start_with?('=') } @count = cells.size @unique_cells = [] @shared_xml_string = "" resolve(cells) end |
Instance Attribute Details
#count ⇒ Integer (readonly)
The total number of strings in the workbook including duplicates Empty cells are treated as blank strings
16 17 18 |
# File 'lib/axlsx/workbook/shared_strings_table.rb', line 16 def count @count end |
#unique_cells ⇒ Object (readonly)
An array of unique cells. Multiple attributes of the cell are used in comparison each of these unique cells is parsed into the shared string table.
27 28 29 |
# File 'lib/axlsx/workbook/shared_strings_table.rb', line 27 def unique_cells @unique_cells end |
Instance Method Details
#to_xml_string ⇒ String
Serializes the object
42 43 44 |
# File 'lib/axlsx/workbook/shared_strings_table.rb', line 42 def to_xml_string '<?xml version="1.0" encoding="UTF-8"?><sst xmlns="' << XML_NS << '" count="' << @count.to_s << '" uniqueCount="' << unique_count.to_s << '">' << @shared_xml_string << '</sst>' end |
#unique_count ⇒ Integer
The total number of unique strings in the workbook.
20 21 22 |
# File 'lib/axlsx/workbook/shared_strings_table.rb', line 20 def unique_count @unique_cells.size end |