Sha256: 79b7a7af3264b48a55c0e9b330c1df1caddfce0537ba93c25cd424a929f99b97

Contents?: true

Size: 1.27 KB

Versions: 9

Compression:

Stored size: 1.27 KB

Contents

require_relative '../lib/fast_excel'

workbook = FastExcel.open("example_styles.xlsx", constant_memory: true)

#workbook.default_format.set(
#  font_size: 0, # user's default
#  #font_family: "Arial"
#)

worksheet = workbook.add_worksheet

worksheet.set_columns_width(0, 11, 11)

worksheet.write_value(0, 0, "Bold",        workbook.add_format(bold: true))
worksheet.write_value(0, 1, "Italic",      workbook.add_format(italic: true))
worksheet.write_value(0, 2, "Underline",   workbook.add_format(underline: :underline_single))
worksheet.write_value(0, 3, "Double line", workbook.add_format(underline: :underline_double))
worksheet.write_value(0, 4, "Indent",      workbook.add_format(indent: 1))
worksheet.write_value(0, 5, "Border",      workbook.add_format(border: :border_thin))
worksheet.write_value(0, 6, "Border2",     workbook.add_format(border: :border_medium))
worksheet.write_value(0, 7, "Pattern",     workbook.add_format(pattern: :pattern_light_up, bg_color: :yellow))
worksheet.write_value(0, 8, "Script",      workbook.add_format(font_script: :font_subscript))
worksheet.write_value(0, 9, "Strike",      workbook.add_format(font_strikeout: true))
worksheet.write_value(0, 10, "Shaddow",    workbook.add_format(font_shadow: true))

workbook.close
puts "Saved to file example_styles.xlsx"

Version data entries

9 entries across 9 versions & 2 rubygems

Version Path
fast_excel-0.5.0 examples/example_styles.rb
fast_excel-0.4.1 examples/example_styles.rb
fast_excel-0.4.0 examples/example_styles.rb
fast_excel-0.3.0 examples/example_styles.rb
fast_excel-0.2.6 examples/example_styles.rb
fast_excel-0.2.5 examples/example_styles.rb
fast_excel-0.2.3 examples/example_styles.rb
fast_excel-0.2.2 examples/example_styles.rb
kmadej_fast_excel_fork-0.2.2 examples/example_styles.rb