Class: Axlsx::Workbook
- Inherits:
-
Object
- Object
- Axlsx::Workbook
- Defined in:
- lib/axlsx/workbook/workbook.rb
Overview
The Workbook class is an xlsx workbook that manages worksheets, charts, drawings and styles. The following parts of the Office Open XML spreadsheet specification are not implimented in this version.
bookViews calcPr customWorkbookViews definedNames externalReferences extLst fileRecoveryPr fileSharing fileVersion functionGroups oleSize pivotCaches smartTagPr smartTagTypes webPublishing webPublishObjects workbookProtection workbookPr*
*workbookPr is only supported to the extend of date1904
Constant Summary collapse
- @@date1904 =
Indicates if the epoc date for serialization should be 1904. If false, 1900 is used.
false
Instance Attribute Summary collapse
-
#charts ⇒ SimpleTypedList
readonly
A colllection of charts associated with this workbook.
-
#drawings ⇒ SimpleTypedList
readonly
A colllection of drawings associated with this workbook.
-
#images ⇒ SimpleTypedList
readonly
A colllection of images associated with this workbook.
-
#pivot_tables ⇒ SimpleTypedList
readonly
A colllection of pivot tables associated with this workbook.
-
#tables ⇒ SimpleTypedList
readonly
A colllection of tables associated with this workbook.
-
#use_shared_strings ⇒ Boolean
When true, the Package will be generated with a shared string table.
- #worksheets ⇒ SimpleTypedList readonly
Class Method Summary collapse
-
.date1904 ⇒ Boolean
retrieves the date1904 attribute.
-
.date1904=(v) ⇒ Boolean
Sets the date1904 attribute to the provided boolean.
Instance Method Summary collapse
-
#[](cell_def) ⇒ Cell, Array
returns a range of cells in a worksheet retrieve the cells from.
-
#add_defined_name(formula, options) ⇒ DefinedName
Adds a defined name to this workbook.
-
#add_worksheet(options = {}) {|worksheet| ... } ⇒ Worksheet
Adds a worksheet to this workbook.
-
#comments ⇒ Comments
A collection of comments associated with this workbook.
-
#date1904 ⇒ Boolean
Instance level access to the class variable 1904.
-
#date1904=(v) ⇒ Object
see @date1904.
-
#defined_names ⇒ DefinedNames
A collection of defined names for this workbook.
-
#initialize(options = {}) {|_self| ... } ⇒ Workbook
constructor
Creates a new Workbook The recomended way to work with workbooks is via Package#workbook.
-
#insert_worksheet(index = 0, options = {}) {|worksheet| ... } ⇒ Worksheet
inserts a worksheet into this workbook at the position specified.
-
#relationships ⇒ Relationships
The workbook relationships.
-
#shared_strings ⇒ SharedStringTable
generates a shared string object against all cells in all worksheets.
-
#sheet_by_name(name) ⇒ Worksheet
A quick helper to retrive a worksheet by name.
-
#styles {|@styles| ... } ⇒ Styles
The styles associated with this workbook.
-
#to_xml_string(str = '') ⇒ String
Serialize the workbook.
-
#use_autowidth ⇒ Boolean
Indicates if the workbook should use autowidths or not.
-
#use_autowidth=(v = true) ⇒ Object
see @use_autowidth.
Constructor Details
#initialize(options = {}) {|_self| ... } ⇒ Workbook
Creates a new Workbook The recomended way to work with workbooks is via Package#workbook
189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 |
# File 'lib/axlsx/workbook/workbook.rb', line 189 def initialize(={}) @styles = Styles.new @worksheets = SimpleTypedList.new Worksheet @drawings = SimpleTypedList.new Drawing @charts = SimpleTypedList.new Chart @images = SimpleTypedList.new Pic # Are these even used????? Check package serialization parts @tables = SimpleTypedList.new Table @pivot_tables = SimpleTypedList.new PivotTable @comments = SimpleTypedList.new Comments @use_autowidth = true self.date1904= ![:date1904].nil? && [:date1904] yield self if block_given? end |
Instance Attribute Details
#charts ⇒ SimpleTypedList (readonly)
The recommended way to manage charts is Worksheet#add_chart
A colllection of charts associated with this workbook
103 104 105 |
# File 'lib/axlsx/workbook/workbook.rb', line 103 def charts @charts end |
#drawings ⇒ SimpleTypedList (readonly)
The recommended way to manage drawings is Worksheet#add_chart
A colllection of drawings associated with this workbook
117 118 119 |
# File 'lib/axlsx/workbook/workbook.rb', line 117 def drawings @drawings end |
#images ⇒ SimpleTypedList (readonly)
The recommended way to manage images is Worksheet#add_image
A colllection of images associated with this workbook
110 111 112 |
# File 'lib/axlsx/workbook/workbook.rb', line 110 def images @images end |
#pivot_tables ⇒ SimpleTypedList (readonly)
The recommended way to manage drawings is Worksheet#add_table
A colllection of pivot tables associated with this workbook
134 135 136 |
# File 'lib/axlsx/workbook/workbook.rb', line 134 def pivot_tables @pivot_tables end |
#tables ⇒ SimpleTypedList (readonly)
The recommended way to manage drawings is Worksheet#add_table
A colllection of tables associated with this workbook
127 128 129 |
# File 'lib/axlsx/workbook/workbook.rb', line 127 def tables @tables end |
#use_shared_strings ⇒ Boolean
When true, the Package will be generated with a shared string table. This may be required by some OOXML processors that do not adhere to the ECMA specification that dictates string may be inline in the sheet. Using this option will increase the time required to serialize the document as every string in every cell must be analzed and referenced.
82 83 84 |
# File 'lib/axlsx/workbook/workbook.rb', line 82 def use_shared_strings @use_shared_strings end |
#worksheets ⇒ SimpleTypedList (readonly)
The recommended way to manage worksheets is add_worksheet
96 97 98 |
# File 'lib/axlsx/workbook/workbook.rb', line 96 def worksheets @worksheets end |
Class Method Details
.date1904 ⇒ Boolean
retrieves the date1904 attribute
220 |
# File 'lib/axlsx/workbook/workbook.rb', line 220 def self.date1904() @@date1904; end |
.date1904=(v) ⇒ Boolean
Sets the date1904 attribute to the provided boolean
216 |
# File 'lib/axlsx/workbook/workbook.rb', line 216 def self.date1904=(v) Axlsx::validate_boolean v; @@date1904 = v; end |
Instance Method Details
#[](cell_def) ⇒ Cell, Array
returns a range of cells in a worksheet retrieve the cells from. e.g. range('Sheet1!A1:B2') will return an array of four cells [A1, A2, B1, B2] while range('Sheet1!A1') will return a single Cell.
295 296 297 298 299 300 |
# File 'lib/axlsx/workbook/workbook.rb', line 295 def [](cell_def) sheet_name = cell_def.split('!')[0] if cell_def.match('!') worksheet = self.worksheets.select { |s| s.name == sheet_name }.first raise ArgumentError, 'Unknown Sheet' unless sheet_name && worksheet.is_a?(Worksheet) worksheet[cell_def.gsub(/.+!/,"")] end |
#add_defined_name(formula, options) ⇒ DefinedName
Adds a defined name to this workbook
264 265 266 |
# File 'lib/axlsx/workbook/workbook.rb', line 264 def add_defined_name(formula, ) defined_names << DefinedName.new(formula, ) end |
#add_worksheet(options = {}) {|worksheet| ... } ⇒ Worksheet
Adds a worksheet to this workbook
254 255 256 257 258 |
# File 'lib/axlsx/workbook/workbook.rb', line 254 def add_worksheet(={}) worksheet = Worksheet.new(self, ) yield worksheet if block_given? worksheet end |
#comments ⇒ Comments
The recommended way to manage comments is WOrksheet#add_comment
A collection of comments associated with this workbook
150 151 152 |
# File 'lib/axlsx/workbook/workbook.rb', line 150 def comments worksheets.map { |sheet| sheet.comments }.compact end |
#date1904 ⇒ Boolean
Instance level access to the class variable 1904
209 |
# File 'lib/axlsx/workbook/workbook.rb', line 209 def date1904() @@date1904; end |
#date1904=(v) ⇒ Object
see @date1904
212 |
# File 'lib/axlsx/workbook/workbook.rb', line 212 def date1904=(v) Axlsx::validate_boolean v; @@date1904 = v; end |
#defined_names ⇒ DefinedNames
The recommended way to manage defined names is Workbook#add_defined_name
A collection of defined names for this workbook
141 142 143 |
# File 'lib/axlsx/workbook/workbook.rb', line 141 def defined_names @defined_names ||= DefinedNames.new end |
#insert_worksheet(index = 0, options = {}) {|worksheet| ... } ⇒ Worksheet
inserts a worksheet into this workbook at the position specified. It the index specified is out of range, the worksheet will be added to the end of the worksheets collection
240 241 242 243 244 245 246 |
# File 'lib/axlsx/workbook/workbook.rb', line 240 def insert_worksheet(index=0, ={}) worksheet = Worksheet.new(self, ) @worksheets.delete_at(@worksheets.size - 1) @worksheets.insert(index, worksheet) yield worksheet if block_given? worksheet end |
#relationships ⇒ Relationships
The workbook relationships. This is managed automatically by the workbook
270 271 272 273 274 275 276 277 278 279 280 281 282 283 |
# File 'lib/axlsx/workbook/workbook.rb', line 270 def relationships r = Relationships.new @worksheets.each do |sheet| r << Relationship.new(WORKSHEET_R, WORKSHEET_PN % (r.size+1)) end pivot_tables.each_with_index do |pivot_table, index| r << Relationship.new(PIVOT_TABLE_CACHE_DEFINITION_R, PIVOT_TABLE_CACHE_DEFINITION_PN % (index+1)) end r << Relationship.new(STYLES_R, STYLES_PN) if use_shared_strings r << Relationship.new(SHARED_STRINGS_R, SHARED_STRINGS_PN) end r end |
#shared_strings ⇒ SharedStringTable
generates a shared string object against all cells in all worksheets.
287 288 289 |
# File 'lib/axlsx/workbook/workbook.rb', line 287 def shared_strings SharedStringsTable.new(worksheets.collect { |ws| ws.cells }) end |
#sheet_by_name(name) ⇒ Worksheet
A quick helper to retrive a worksheet by name
172 173 174 175 |
# File 'lib/axlsx/workbook/workbook.rb', line 172 def sheet_by_name(name) index = @worksheets.index { |sheet| sheet.name == name } @worksheets[index] if index end |
#styles {|@styles| ... } ⇒ Styles
The recommended way to manage styles is Styles#add_style
The styles associated with this workbook
159 160 161 162 |
# File 'lib/axlsx/workbook/workbook.rb', line 159 def styles yield @styles if block_given? @styles end |
#to_xml_string(str = '') ⇒ String
Serialize the workbook
305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 |
# File 'lib/axlsx/workbook/workbook.rb', line 305 def to_xml_string(str='') add_worksheet unless worksheets.size > 0 str << '<?xml version="1.0" encoding="UTF-8"?>' str << '<workbook xmlns="' << XML_NS << '" xmlns:r="' << XML_NS_R << '">' str << '<workbookPr date1904="' << @@date1904.to_s << '"/>' str << '<sheets>' @worksheets.each_with_index do |sheet, index| str << '<sheet name="' << sheet.name << '" sheetId="' << (index+1).to_s << '" r:id="' << sheet.rId << '"/>' if defined_name = sheet.auto_filter.defined_name add_defined_name defined_name, :name => '_xlnm._FilterDatabase', :local_sheet_id => index, :hidden => 1 end end str << '</sheets>' defined_names.to_xml_string(str) unless pivot_tables.empty? str << '<pivotCaches>' pivot_tables.each_with_index do |pivot_table, index| rId = "rId#{@worksheets.size + index + 1 }" str << '<pivotCache cacheId="' << pivot_table.cache_definition.cache_id.to_s << '" r:id="' << rId << '"/>' end str << '</pivotCaches>' end str << '</workbook>' end |
#use_autowidth ⇒ Boolean
This gem no longer depends on RMagick for autowidth calculation. Thus the performance benefits of turning this off are marginal unless you are creating a very large sheet.
Indicates if the workbook should use autowidths or not.
227 |
# File 'lib/axlsx/workbook/workbook.rb', line 227 def use_autowidth() @use_autowidth; end |
#use_autowidth=(v = true) ⇒ Object
see @use_autowidth
230 |
# File 'lib/axlsx/workbook/workbook.rb', line 230 def use_autowidth=(v=true) Axlsx::validate_boolean v; @use_autowidth = v; end |