Add example for defining print area (#134)

4 files changed, 29 insertions, 0 deletions

diff --git a/examples/README.md b/examples/README.md
index 0e2d655a..ea76d376 100644
--- a/examples/README.md
+++ b/examples/README.md
@@ -81,6 +81,7 @@ Customizations:
 ### Print
 
 * [Fit to page print settings](fit_to_page_example.md)
+* [Set print area](set_print_area_example.md)
 * [Headers and footers](header_footer_example.md)
 * [Page breaks](page_break_example.md)
 * [Print settings](print_settings_example.md)
diff --git a/examples/images/set_print_area_example_1.png b/examples/images/set_print_area_example_1.png
new file mode 100644
index 00000000..dbe39670
--- /dev/null
+++ b/examples/images/set_print_area_example_1.png
diff --git a/examples/images/set_print_area_example_2.png b/examples/images/set_print_area_example_2.png
new file mode 100644
index 00000000..a274627c
--- /dev/null
+++ b/examples/images/set_print_area_example_2.png
diff --git a/examples/set_print_area_example.md b/examples/set_print_area_example.md
new file mode 100644
index 00000000..69d0b20e
--- /dev/null
+++ b/examples/set_print_area_example.md
@@ -0,0 +1,28 @@
+## Description
+
+Change the range of cells that will be printed out when the sheet is printed
+
+## Code
+
+```ruby
+require 'axlsx'
+
+p = Axlsx::Package.new
+wb = p.workbook
+
+wb.add_worksheet(name: 'PrintArea') do |sheet|
+  sheet.add_row ['this', 'fits', 'in', 'the', 'print', 'area', 'this does not']
+  sheet.page_setup.fit_to width: 1, height: 1
+  wb.add_defined_name("PrintArea!A1:F1", local_sheet_id: sheet.index, name: '_xlnm.Print_Area')
+end
+
+p.serialize 'set_print_area_example.xlsx'
+```
+
+## Output
+
+How it looks in excel:
+![](images/set_print_area_example_1.png "Excel Preview")
+
+Print preview dialog:
+![](images/set_print_area_example_2.png "Print Preview PDF")