Class: Axlsx::CellStyle

Inherits:
Object
  • Object
show all
Defined in:
lib/axlsx/stylesheet/cell_style.rb

Overview

Note:

Using Styles#add_style is the recommended way to manage cell styling.

CellStyle defines named styles that reference defined formatting records and can be used in your worksheet.

See Also:

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(options = {}) ⇒ CellStyle

Creats a new CellStyle object

Parameters:

  • options (Hash) (defaults to: {}) —

    a customizable set of options

Options Hash (options):

  • name (String)
  • xfId (Integer)
  • buildinId (Integer)
  • iLevel (Integer)
  • hidden (Boolean)
  • customBuiltIn (Boolean) 


40
41
42
43
44
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 40

def initialize(options={})
  options.each do |o|
    self.send("#{o[0]}=", o[1]) if self.respond_to? o[0]
  end
end

Instance Attribute Details

#builtinId ⇒ Integer

The buildinId to use when this named style is applied

Returns:

  • (Integer)

See Also:



19
20
21
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 19

def builtinId
  @builtinId
end

#customBuiltin ⇒ Boolean

Indicates that the build in style reference has been customized.

Returns:

  • (Boolean) 


31
32
33
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 31

def customBuiltin
  @customBuiltin
end

#hidden ⇒ Boolean

Determines if this named style should show in the list of styles when using excel

Returns:

  • (Boolean) 


27
28
29
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 27

def hidden
  @hidden
end

#iLevel ⇒ Integer

Determines if this formatting is for an outline style, and what level of the outline it is to be applied to.

Returns:

  • (Integer) 


23
24
25
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 23

def iLevel
  @iLevel
end

#name ⇒ String

The name of this cell style

Returns:

  • (String) 


9
10
11
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 9

def name
  @name
end

#xfId ⇒ Integer

The formatting record id this named style utilizes

Returns:

  • (Integer)

See Also:



14
15
16
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 14

def xfId
  @xfId
end

Instance Method Details

#to_xml(xml) ⇒ String

Serializes the cell style

Parameters:

  • xml (Nokogiri::XML::Builder) —

    The document builder instance this objects xml will be added to.

Returns:

  • (String) 


61
62
63
 
# File 'lib/axlsx/stylesheet/cell_style.rb', line 61

def to_xml(xml)
  xml.cellStyle(self.instance_values)
end