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_string(str = '') ⇒ String

Serializes the object

Parameters:

  • str (String) (defaults to: '')

Returns:

  • (String) 


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

def to_xml_string(str = '')
  str << '<cellStyle '
  str << instance_values.map { |key, value| '' << key.to_s << '="' << value.to_s << '"' }.join(' ')
  str << '/>'
end