Merge pull request #168 from westonganger/merge_axlsx_styler

Merge axlsx_styler gem into caxlsx

4 files changed, 59 insertions, 0 deletions

diff --git a/examples/add_border_example.md b/examples/add_border_example.md
new file mode 100644
index 00000000..d64b940d
--- /dev/null
+++ b/examples/add_border_example.md
@@ -0,0 +1,28 @@
+## Description
+
+Shows how to use `add_border` to add a border to four edges of the selected cell range.
+
+## Code
+
+```ruby
+p = Axlsx::Package.new
+wb = p.workbook
+
+wb.add_worksheet do |sheet|
+  sheet.add_row
+  sheet.add_row ["", "Product", "Category",  "Price"]
+  sheet.add_row ["", "Butter", "Dairy",      4.99]
+  sheet.add_row ["", "Bread", "Baked Goods", 3.45]
+  sheet.add_row ["", "Broccoli", "Produce",  2.99]
+
+  sheet.add_border "B2:D5"
+  sheet.add_border "B3:D3", { edges: [:top], style: :thick }
+  sheet.add_border ["C3:C4", "D3:D4"]
+end
+
+p.serialize "add_border.xlsx"
+```
+
+## Output
+
+![Output](images/add_border_example.png "Output")
diff --git a/examples/append_styles_example.md b/examples/append_styles_example.md
new file mode 100644
index 00000000..d8cb4696
--- /dev/null
+++ b/examples/append_styles_example.md
@@ -0,0 +1,31 @@
+## Description
+
+Shows how to append styles after rows have been created using `worksheet.add_style`
+
+## Code
+
+```ruby
+p = Axlsx::Package.new
+wb = p.workbook
+
+wb.add_worksheet do |sheet|
+  sheet.add_row
+  sheet.add_row ["", "Product", "Category",  "Price"]
+  sheet.add_row ["", "Butter", "Dairy",      4.99]
+  sheet.add_row ["", "Bread", "Baked Goods", 3.45]
+  sheet.add_row ["", "Broccoli", "Produce",  2.99]
+
+  sheet.add_style "B2:D2", b: true
+  sheet.add_style "B2:B5", b: true
+  sheet.add_style "B2:D2", bg_color: "95AFBA"
+  sheet.add_style "B3:D5", bg_color: "E2F89C"
+  sheet.add_style "D3:D5", alignment: { horizontal: :left }
+  sheet.add_style ["C3:C4", "D3:D4"], fg_color: "00FF00"
+end
+
+p.serialize "append_styles.xlsx"
+```
+
+## Output
+
+![Output](images/append_styles_example.png "Output")
diff --git a/examples/images/add_border_example.png b/examples/images/add_border_example.png
new file mode 100644
index 00000000..f18ac144
--- /dev/null
+++ b/examples/images/add_border_example.png
diff --git a/examples/images/append_styles_example.png b/examples/images/append_styles_example.png
new file mode 100644
index 00000000..5b8b2d55
--- /dev/null
+++ b/examples/images/append_styles_example.png