examples/demo.rb in write_xlsx-1.10.0 vs examples/demo.rb in write_xlsx-1.10.1
- old
+ new
@@ -6,41 +6,41 @@
workbook = WriteXLSX.new('demo.xlsx')
worksheet = workbook.add_worksheet('Demo')
worksheet2 = workbook.add_worksheet('Another sheet')
worksheet3 = workbook.add_worksheet('And another')
-bold = workbook.add_format(:bold => 1)
+bold = workbook.add_format(bold: 1)
#######################################################################
#
# Write a general heading
#
worksheet.set_column('A:A', 36, bold)
worksheet.set_column('B:B', 20)
worksheet.set_row(0, 40)
heading = workbook.add_format(
- :bold => 1,
- :color => 'blue',
- :size => 16,
- :merge => 1,
- :align => 'vcenter'
+ bold: 1,
+ color: 'blue',
+ size: 16,
+ merge: 1,
+ align: 'vcenter'
)
headings = ['Features of WriteXLSX', '']
worksheet.write_row('A1', headings, heading)
#######################################################################
#
# Some text examples
#
text_format = workbook.add_format(
- :bold => 1,
- :italic => 1,
- :color => 'red',
- :size => 18,
- :font => 'Lucida Calligraphy'
+ bold: 1,
+ italic: 1,
+ color: 'red',
+ size: 18,
+ font: 'Lucida Calligraphy'
)
worksheet.write('A2', "Text")
worksheet.write('B2', "Hello Excel")
worksheet.write('A3', "Formatted text")
@@ -50,12 +50,12 @@
#######################################################################
#
# Some numeric examples
#
-num1_format = workbook.add_format(:num_format => '$#,##0.00')
-num2_format = workbook.add_format(:num_format => ' d mmmm yyy')
+num1_format = workbook.add_format(num_format: '$#,##0.00')
+num2_format = workbook.add_format(num_format: ' d mmmm yyy')
worksheet.write('A5', "Numbers")
worksheet.write('B5', 1234.56)
worksheet.write('A6', "Formatted numbers")
worksheet.write('B6', 1234.56, num1_format)
@@ -82,10 +82,10 @@
# Images
#
worksheet.write('A10', "Images")
worksheet.insert_image(
'B10', 'republic.png',
- :x_offset => 16, :y_offset => 8
+ x_offset: 16, y_offset: 8
)
#######################################################################
#
# Misc