summaryrefslogtreecommitdiffhomepage
path: root/examples/add_border_example.md
diff options
context:
space:
mode:
authorWeston Ganger <[email protected]>2022-09-29 20:45:39 -0700
committerWeston Ganger <[email protected]>2022-09-29 20:45:39 -0700
commitfd8366970d9cb3f5fb431ba6c40a2a2ac2737615 (patch)
tree4e7fc2f0520d3a5cd4485d101b60a8280e624bb7 /examples/add_border_example.md
parentbcc88ca556b3b8527ba0ad56424f93ef170b9c31 (diff)
downloadcaxlsx-fd8366970d9cb3f5fb431ba6c40a2a2ac2737615.tar.gz
caxlsx-fd8366970d9cb3f5fb431ba6c40a2a2ac2737615.zip
Merge axlsx_styler gem into caxlsx
Diffstat (limited to 'examples/add_border_example.md')
-rw-r--r--examples/add_border_example.md28
1 files changed, 28 insertions, 0 deletions
diff --git a/examples/add_border_example.md b/examples/add_border_example.md
new file mode 100644
index 00000000..934cf183
--- /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.png "Output")