examples/print_settings_example.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

## Description

You could change the page settings for printing.

## Code

```ruby
require 'axlsx'

p = Axlsx::Package.new
wb = p.workbook

margins = {
  left: 3,
  right: 3,
  top: 1.2,
  bottom: 1.2,
  header: 0.7,
  footer: 0.7
}

setup = {
  fit_to_width: 1,
  orientation: :landscape,
  paper_width: '297mm',
  paper_height: '210mm'
}

options = {
  grid_lines: true,
  headings: true,
  horizontal_centered: true
}

wb.add_worksheet(name: 'Print settings',
                 page_margins: margins,
                 page_setup: setup,
                 print_options: options) do |sheet|
  sheet.add_row ['this sheet uses customized print settings']
end

p.serialize 'print_settings_example.xlsx'
```

## Output

![Output](images/print_settings_example.png "Output")