diff options
| author | Weston Ganger <[email protected]> | 2022-09-29 20:45:39 -0700 |
|---|---|---|
| committer | Weston Ganger <[email protected]> | 2022-09-29 20:45:39 -0700 |
| commit | fd8366970d9cb3f5fb431ba6c40a2a2ac2737615 (patch) | |
| tree | 4e7fc2f0520d3a5cd4485d101b60a8280e624bb7 /examples/add_border_example.md | |
| parent | bcc88ca556b3b8527ba0ad56424f93ef170b9c31 (diff) | |
| download | caxlsx-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.md | 28 |
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 + + |
