Class: Axlsx::Row

Inherits:

Object

• Object
• Axlsx::Row

show all

Defined in:

lib/axlsx/workbook/worksheet/row.rb

Overview

Instance Attribute Summary (collapse)

• - (SimpleTypedList) cells readonly

  The cells this row holds.

• - (Worksheet) worksheet

  The worksheet this row belongs to.

Instance Method Summary (collapse)

• - (Cell) add_cell(value = "", options = {})

  Adds a singel sell to the row based on the data provided and updates the worksheet’s autofit data.

• - (Integer) index

  The index of this row in the worksheet.

• - (Row) initialize(worksheet, values = [], options = {}) constructor

  Creates a new row.

• - (Object) style=(style)

  sets the style for every cell in this row.

• - (Array) to_ary

  returns the cells in this row as an array This lets us transpose the rows into columns.

• - (String) to_xml(xml)

  Serializes the row.

  If the types option is defined and is a symbol it is applied to all the cells created.
  If the types option is an array, cell types are applied by index for each cell
  If the types option is not set, the cell will automatically determine its type.
  If the style option is defined and is an Integer, it is applied to all cells created.
  If the style option is an array, style is applied by index for each cell.
  If the style option is not defined, the default style (0) is applied to each cell.

29
30
31
32
33
34

# File 'lib/axlsx/workbook/worksheet/row.rb', line 29

def initialize(worksheet, values=[], options={})
  self.worksheet = worksheet
  @cells = SimpleTypedList.new Cell
  @worksheet.rows << self
  array_to_cells(values, options)
end

13
14
15

# File 'lib/axlsx/workbook/worksheet/row.rb', line 13

def cells
  @cells
end

9
10
11

# File 'lib/axlsx/workbook/worksheet/row.rb', line 9

def worksheet
  @worksheet
end

51
52
53
54
55

# File 'lib/axlsx/workbook/worksheet/row.rb', line 51

def add_cell(value="", options={})
  c = Cell.new(self, value, options)
  update_auto_fit_data
  c
end

38
39
40

# File 'lib/axlsx/workbook/worksheet/row.rb', line 38

def index 
  worksheet.rows.index(self)
end

58
59
60
61
62
63

# File 'lib/axlsx/workbook/worksheet/row.rb', line 58

def style=(style)
  cells.each_with_index do | cell, index |
    s = style.is_a?(Array) ? style[index] : style
    cell.style = s
  end
end

68
69
70

# File 'lib/axlsx/workbook/worksheet/row.rb', line 68

def to_ary
  @cells.to_ary
end

45
46
47

# File 'lib/axlsx/workbook/worksheet/row.rb', line 45

def to_xml(xml)
  xml.row(:r => index+1) { @cells.each { |cell| cell.to_xml(xml) } }
end