examples/roo_soap_client.rb in roo-1.13.2 vs examples/roo_soap_client.rb in roo-2.0.0beta1
- old
+ new
@@ -1,53 +1,50 @@
require 'soap/rpc/driver'
- def ferien_fuer_region(proxy, region, year=nil)
- proxy.first_row.upto(proxy.last_row) { |row|
- if proxy.cell(row, 2) == region
- jahr = proxy.cell(row,1).to_i
- if year == nil || jahr == year
- bis_datum = proxy.cell(row,5)
- if DateTime.now > bis_datum
- print '('
- end
- print jahr.to_s+" "
- print proxy.cell(row,2)+" "
- print proxy.cell(row,3)+" "
- print proxy.cell(row,4).to_s+" "
- print bis_datum.to_s+" "
- print (proxy.cell(row,6) || '')+" "
- if DateTime.now > bis_datum
- print ')'
- end
- puts
+def ferien_fuer_region(proxy, region, year = nil)
+ proxy.first_row.upto(proxy.last_row) do |row|
+ if proxy.cell(row, 2) == region
+ jahr = proxy.cell(row, 1).to_i
+ if year.nil? || jahr == year
+ bis_datum = proxy.cell(row, 5)
+ if DateTime.now > bis_datum
+ print '('
end
- end
- }
+ print jahr.to_s + ' '
+ print proxy.cell(row, 2) + ' '
+ print proxy.cell(row, 3) + ' '
+ print proxy.cell(row, 4).to_s + ' '
+ print bis_datum.to_s + ' '
+ print (proxy.cell(row, 6) || '') + ' '
+ if DateTime.now > bis_datum
+ print ')'
+ end
+ puts
+ end
+ end
end
+end
-proxy = SOAP::RPC::Driver.new("http://localhost:12321","spreadsheetserver")
-proxy.add_method('cell','row','col')
+proxy = SOAP::RPC::Driver.new('http://localhost:12321', 'spreadsheetserver')
+proxy.add_method('cell', 'row', 'col')
proxy.add_method('officeversion')
proxy.add_method('last_row')
proxy.add_method('last_column')
proxy.add_method('first_row')
proxy.add_method('first_column')
proxy.add_method('sheets')
-proxy.add_method('set_default_sheet','s')
+proxy.add_method('set_default_sheet', 's')
proxy.add_method('ferien_fuer_region', 'region')
sheets = proxy.sheets
proxy.set_default_sheet(sheets.first)
puts "first row: #{proxy.first_row}"
puts "first column: #{proxy.first_column}"
puts "last row: #{proxy.last_row}"
puts "last column: #{proxy.last_column}"
-puts "cell: #{proxy.cell('C',8)}"
-puts "cell: #{proxy.cell('F',12)}"
+puts "cell: #{proxy.cell('C', 8)}"
+puts "cell: #{proxy.cell('F', 12)}"
puts "officeversion: #{proxy.officeversion}"
-puts "Berlin:"
+puts 'Berlin:'
-ferien_fuer_region(proxy, "Berlin")
-
-
-
+ferien_fuer_region(proxy, 'Berlin')