Class: Excelgrip::Worksheet
Overview
Worksheet Class ==============
Instance Method Summary
collapse
Methods inherited from GripWrapper
#initialize, #inspect, #raw
Dynamic Method Handling
This class handles dynamic methods through the method_missing method
in the class Excelgrip::GripWrapper
Instance Method Details
#[](cell_1) ⇒ Object
177
178
179
180
181
182
183
|
# 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) ⇒ Object
168
169
170
171
172
173
174
175
|
# 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 ⇒ Object
185
186
187
188
|
# File 'lib/excelgrip.rb', line 185
def delete
@raw_object.delete
@raw_object = nil
end
|
#name=(sheet_name) ⇒ Object
190
191
192
|
# File 'lib/excelgrip.rb', line 190
def name=(sheet_name)
@raw_object.name = sheet_name
end
|
#parent ⇒ Object
194
195
196
|
# File 'lib/excelgrip.rb', line 194
def parent
Workbook.new(@raw_object.parent)
end
|
#range(cell_1, cell_2 = nil) ⇒ Object
155
156
157
158
159
160
161
162
163
164
165
166
|
# 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
|