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