Parent

Included Modules

Spreadsheet::Column

The Column class. Encapsulates column-formatting and width, and provides a means to iterate over all cells in a column.

Useful Attributes:

width

The width in characters (in respect to the '0' character of the Worksheet's default Font). Float values are permitted, for Excel the available Precision is at 1/256 characters.

default_format

The default Format for cells in this column (applied if there is no explicit Cell Format and no default Row format for the Cell).

hidden

The Column is hidden.

collapsed

The Column is collapsed.

outline_level

Outline level of the column.

Attributes

default_format[R]
idx[R]
width[RW]
worksheet[RW]

Public Class Methods

new(idx, format, opts={}) click to toggle source
# File lib/spreadsheet/column.rb, line 41
def initialize idx, format, opts={}
  @worksheet = nil
  @idx = idx
  opts[:width] ||= 10
  opts.each do |key, value|
    self.send "#{key}=", value
  end
  self.default_format = format
end
updater(*keys) click to toggle source
# File lib/spreadsheet/column.rb, line 21
def updater *keys
  keys.each do |key|
    unless instance_methods.include? "unupdated_#{key}="
      alias_method :"unupdated_#{key}=", :"#{key}="
      define_method "#{key}=" do |value|
        send "unupdated_#{key}=", value
        @worksheet.column_updated @idx, self if @worksheet
        value
      end
    end
  end
end

Public Instance Methods

default_format=(format) click to toggle source

Set the default Format for Cells in this Column.

# File lib/spreadsheet/column.rb, line 52
def default_format= format
  @worksheet.add_format format if @worksheet
  @default_format = format
  @worksheet.column_updated @idx, self if @worksheet
  format
end
each() click to toggle source

Iterate over all cells in this column.

# File lib/spreadsheet/column.rb, line 60
def each
  @worksheet.each do |row|
    yield row[idx]
  end
end

[Validate]

Generated with the Darkfish Rdoc Generator 2.