diff options
| -rw-r--r-- | examples/README.md | 1 | ||||
| -rw-r--r-- | examples/images/set_print_area_example_1.png | bin | 0 -> 34218 bytes | |||
| -rw-r--r-- | examples/images/set_print_area_example_2.png | bin | 0 -> 85864 bytes | |||
| -rw-r--r-- | examples/set_print_area_example.md | 28 |
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 Binary files differnew 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 Binary files differnew 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: + + +Print preview dialog: + |
