summaryrefslogtreecommitdiffhomepage
path: root/examples/number_format_example.md
diff options
context:
space:
mode:
authorZsolt Kozaroczy <[email protected]>2020-09-11 00:36:29 +0200
committerGitHub <[email protected]>2020-09-11 00:36:29 +0200
commit282eec44ef01746ee25931fa6cd287ad083fd40b (patch)
tree14504bf429ca264812679ca971c1592853d3f762 /examples/number_format_example.md
parent317e8244e4d17c394c1e181f86df3974623fb865 (diff)
downloadcaxlsx-282eec44ef01746ee25931fa6cd287ad083fd40b.tar.gz
caxlsx-282eec44ef01746ee25931fa6cd287ad083fd40b.zip
Restructure examples folder (#47)
Split examples into separate markdown files, each containing a description, sample code, and a screenshot of the resulting xlsx document. The script `generate.rb` is provided to actually generate the example documents by executing the sample code contained in the markdown files.
Diffstat (limited to 'examples/number_format_example.md')
-rw-r--r--examples/number_format_example.md30
1 files changed, 30 insertions, 0 deletions
diff --git a/examples/number_format_example.md b/examples/number_format_example.md
new file mode 100644
index 00000000..fe053880
--- /dev/null
+++ b/examples/number_format_example.md
@@ -0,0 +1,30 @@
+## Description
+
+
+
+## Code
+
+```ruby
+require 'axlsx'
+
+p = Axlsx::Package.new
+wb = p.workbook
+
+s = wb.styles
+comma = s.add_style num_fmt: 3
+currency = s.add_style num_fmt: 5
+red_negative = s.add_style num_fmt: 8
+super_funk = s.add_style format_code: '[Green]#'
+venezuela_currency = s.add_style format_code: '#.##0\,00'
+
+wb.add_worksheet(name: 'Formats and Currency') do |sheet|
+ sheet.add_row ['Comma', 'Currency', 'Red Negative', 'Super funk', 'Venezuela']
+ sheet.add_row [123456789, 1500, -122.34, 594829, 2.5], style: [comma, currency, red_negative, super_funk, venezuela_currency]
+end
+
+p.serialize 'number_format_example.xlsx'
+```
+
+## Output
+
+![Output](images/number_format_example.png "Output")