examples/repeat.rb in writeexcel-0.1.0 vs examples/repeat.rb in writeexcel-0.3.0
- old
+ new
@@ -1,42 +1,42 @@
- #!/usr/bin/ruby -w
-
-######################################################################
-#
-# Example of writing repeated formulas.
-#
-# reverse('©'), August 2002, John McNamara, jmcnamara@cpan.org
-#
-# original written in Perl by John McNamara
-# converted to Ruby by Hideo Nakamura, cxn03651@msj.biglobe.ne.jp
-#
-
-require 'rubygems'
-require 'writeexcel'
-
-workbook = Spreadsheet::WriteExcel.new("repeat.xls")
-worksheet = workbook.add_worksheet
-
-limit = 1000
-
-# Write a column of numbers
-0.upto(limit) do |row|
- worksheet.write(row, 0, row)
-end
-
-# Store a formula
-formula = worksheet.store_formula('=A1*5+4')
-
-# Write a column of formulas based on the stored formula
-0.upto(limit) do |row|
- worksheet.repeat_formula(row, 1, formula, nil,
- /A1/, 'A'+(row+1).to_s)
-end
-
-# Direct formula writing. As a speed comparison uncomment the
-# following and run the program again
-
-#for row (0..limit) {
-# worksheet.write_formula(row, 2, '=A'.(row+1).'*5+4')
-#}
-
-workbook.close
+ #!/usr/bin/ruby -w
+
+######################################################################
+#
+# Example of writing repeated formulas.
+#
+# reverse('©'), August 2002, John McNamara, jmcnamara@cpan.org
+#
+# original written in Perl by John McNamara
+# converted to Ruby by Hideo Nakamura, cxn03651@msj.biglobe.ne.jp
+#
+
+require 'rubygems'
+require 'writeexcel'
+
+workbook = WriteExcel.new("repeat.xls")
+worksheet = workbook.add_worksheet
+
+limit = 1000
+
+# Write a column of numbers
+0.upto(limit) do |row|
+ worksheet.write(row, 0, row)
+end
+
+# Store a formula
+formula = worksheet.store_formula('=A1*5+4')
+
+# Write a column of formulas based on the stored formula
+0.upto(limit) do |row|
+ worksheet.repeat_formula(row, 1, formula, nil,
+ /A1/, 'A'+(row+1).to_s)
+end
+
+# Direct formula writing. As a speed comparison uncomment the
+# following and run the program again
+
+#for row (0..limit) {
+# worksheet.write_formula(row, 2, '=A'.(row+1).'*5+4')
+#}
+
+workbook.close