class Excelgrip::Worksheet

Worksheet Class ==============

Public Instance Methods

[](cell_1) click to toggle source
# File lib/excelgrip.rb, line 177
def [](cell_1)
  begin
    range(cell_1)
  rescue WIN32OLERuntimeError
    raise $!,$!.message, caller
  end
end
cells(v_pos, h_pos) click to toggle source
# File lib/excelgrip.rb, line 168
def cells(v_pos, h_pos)
  begin
    raw_range = @raw_object.Cells(v_pos, h_pos)
  rescue WIN32OLERuntimeError
    raise $!,$!.message, caller
  end
  Range.new(raw_range)
end
delete() click to toggle source
# File lib/excelgrip.rb, line 185
def delete
  @raw_object.delete
  @raw_object = nil
end
name=(sheet_name) click to toggle source
# File lib/excelgrip.rb, line 190
def name=(sheet_name)
  @raw_object.name = sheet_name
end
parent() click to toggle source
# File lib/excelgrip.rb, line 194
def parent
  Workbook.new(@raw_object.parent)
end
range(cell_1, cell_2=nil) click to toggle source
# File lib/excelgrip.rb, line 155
def range(cell_1, cell_2=nil)
  if cell_1.class == String
    begin
      raw_range = @raw_object.range(cell_1)
    rescue WIN32OLERuntimeError
      raise $!,$!.message, caller
    end
  else
    raw_range = @raw_object.range(cell_1.raw, cell_2.raw)
  end
  Range.new(raw_range)
end