From 5ae8ef157be8d57db45cd90313e3e54c3f91f063 Mon Sep 17 00:00:00 2001 From: Stefan Date: Sun, 5 Jun 2022 12:40:59 +0200 Subject: Add example for defining print area (#134) --- examples/README.md | 1 + examples/images/set_print_area_example_1.png | Bin 0 -> 34218 bytes examples/images/set_print_area_example_2.png | Bin 0 -> 85864 bytes examples/set_print_area_example.md | 28 +++++++++++++++++++++++++++ 4 files changed, 29 insertions(+) create mode 100644 examples/images/set_print_area_example_1.png create mode 100644 examples/images/set_print_area_example_2.png create mode 100644 examples/set_print_area_example.md 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 Binary files /dev/null and b/examples/images/set_print_area_example_1.png differ 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 Binary files /dev/null and b/examples/images/set_print_area_example_2.png differ 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") -- cgit v1.2.3