# C1.WPF.Excel.XLPrintSettings

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="C1_WPF_Excel_XLPrintSettings" data-uid="C1.WPF.Excel.XLPrintSettings" class="text-break">XLPrintSettings Class
</h1>
  <div class="markdown level0 summary"><p>Provides options and settings for printing <a class="xref" href="C1.WPF.Excel.XLSheet.html">XLSheet</a> objects.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">XLPrintSettings</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="C1.WPF.Excel.ICloneable.html">ICloneable</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.WPF.Excel.html">C1.WPF.Excel</a></h6>
  <h6><strong>Assembly</strong>: C1.WPF.Excel.4.6.2.dll</h6>
  <h5 id="C1_WPF_Excel_XLPrintSettings_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class XLPrintSettings : ICloneable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class XLPrintSettings
    Implements ICloneable</code></pre>
  </div>
  <h5 id="C1_WPF_Excel_XLPrintSettings_remarks"><strong>Remarks</strong></h5>
  <div class="markdown level0 remarks"><pre><code>&lt;p&gt;The settings are applied to each sheet and are accessible through the
</code></pre>
<p>sheet's <a class="xref" href="C1.WPF.Excel.XLSheet.PrintSettings.html#C1_WPF_Excel_XLSheet_PrintSettings">PrintSettings</a> property.</p>
<p>Note that <a class="xref" href="C1.WPF.Excel.C1XLBook.html">C1XLBook</a> does not provide any printing
services. The settings are used when printing the sheet from Excel.</p>
</div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings__ctor" data-uid="C1.WPF.Excel.XLPrintSettings.#ctor">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.-ctor.html#C1_WPF_Excel_XLPrintSettings__ctor">XLPrintSettings()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new instance of the <a class="xref" href="C1.WPF.Excel.XLPrintSettings.html">XLPrintSettings</a> class.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_AlignWithMargins" data-uid="C1.WPF.Excel.XLPrintSettings.AlignWithMargins">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.AlignWithMargins.html#C1_WPF_Excel_XLPrintSettings_AlignWithMargins">AlignWithMargins</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the align header/footer with page margins used for printed output.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_AutoScale" data-uid="C1.WPF.Excel.XLPrintSettings.AutoScale">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.AutoScale.html#C1_WPF_Excel_XLPrintSettings_AutoScale">AutoScale</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the scaling mode used for printed output.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_BlackAndWhite" data-uid="C1.WPF.Excel.XLPrintSettings.BlackAndWhite">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.BlackAndWhite.html#C1_WPF_Excel_XLPrintSettings_BlackAndWhite">BlackAndWhite</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether to print the sheet in monochrome mode.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_CenterHorizontal" data-uid="C1.WPF.Excel.XLPrintSettings.CenterHorizontal">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.CenterHorizontal.html#C1_WPF_Excel_XLPrintSettings_CenterHorizontal">CenterHorizontal</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the sheet should be centered horizontally on the page when printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_CenterVertical" data-uid="C1.WPF.Excel.XLPrintSettings.CenterVertical">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.CenterVertical.html#C1_WPF_Excel_XLPrintSettings_CenterVertical">CenterVertical</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the sheet should be centered vertically on the page when printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_Copies" data-uid="C1.WPF.Excel.XLPrintSettings.Copies">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.Copies.html#C1_WPF_Excel_XLPrintSettings_Copies">Copies</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the number of copies to print.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_DraftQuality" data-uid="C1.WPF.Excel.XLPrintSettings.DraftQuality">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.DraftQuality.html#C1_WPF_Excel_XLPrintSettings_DraftQuality">DraftQuality</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether to print the sheet in draft quality mode.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_FitPagesAcross" data-uid="C1.WPF.Excel.XLPrintSettings.FitPagesAcross">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.FitPagesAcross.html#C1_WPF_Excel_XLPrintSettings_FitPagesAcross">FitPagesAcross</a>
        </td>
        <td class="markdown level1 summary"><p>Fit the sheet to this number of pages across (0 means use as many as needed).</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_FitPagesDown" data-uid="C1.WPF.Excel.XLPrintSettings.FitPagesDown">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.FitPagesDown.html#C1_WPF_Excel_XLPrintSettings_FitPagesDown">FitPagesDown</a>
        </td>
        <td class="markdown level1 summary"><p>Fit the sheet to this number of pages down (0 means use as many as needed).</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_Footer" data-uid="C1.WPF.Excel.XLPrintSettings.Footer">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.Footer.html#C1_WPF_Excel_XLPrintSettings_Footer">Footer</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the string to be displayed as a page footer when the sheet is printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_FooterEven" data-uid="C1.WPF.Excel.XLPrintSettings.FooterEven">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.FooterEven.html#C1_WPF_Excel_XLPrintSettings_FooterEven">FooterEven</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the string to be displayed as a even page footer when the sheet is printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_FooterFirst" data-uid="C1.WPF.Excel.XLPrintSettings.FooterFirst">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.FooterFirst.html#C1_WPF_Excel_XLPrintSettings_FooterFirst">FooterFirst</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the string to be displayed as a first page footer when the sheet is printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_FooterPictureCenter" data-uid="C1.WPF.Excel.XLPrintSettings.FooterPictureCenter">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.FooterPictureCenter.html#C1_WPF_Excel_XLPrintSettings_FooterPictureCenter">FooterPictureCenter</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <span class="xref">C1.WPF.Bitmap.C1Bitmap</span> or <a class="xref" href="C1.WPF.Excel.XLPictureShape.html">XLPictureShape</a> for the center part of the footer.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_FooterPictureLeft" data-uid="C1.WPF.Excel.XLPrintSettings.FooterPictureLeft">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.FooterPictureLeft.html#C1_WPF_Excel_XLPrintSettings_FooterPictureLeft">FooterPictureLeft</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <span class="xref">C1.WPF.Bitmap.C1Bitmap</span> or <a class="xref" href="C1.WPF.Excel.XLPictureShape.html">XLPictureShape</a> for the left part of the footer.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_FooterPictureRight" data-uid="C1.WPF.Excel.XLPrintSettings.FooterPictureRight">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.FooterPictureRight.html#C1_WPF_Excel_XLPrintSettings_FooterPictureRight">FooterPictureRight</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <span class="xref">C1.WPF.Bitmap.C1Bitmap</span> or <a class="xref" href="C1.WPF.Excel.XLPictureShape.html">XLPictureShape</a> for the right part of the footer.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_Header" data-uid="C1.WPF.Excel.XLPrintSettings.Header">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.Header.html#C1_WPF_Excel_XLPrintSettings_Header">Header</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the string to be displayed as a page header when the sheet is printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_HeaderEven" data-uid="C1.WPF.Excel.XLPrintSettings.HeaderEven">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.HeaderEven.html#C1_WPF_Excel_XLPrintSettings_HeaderEven">HeaderEven</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the string to be displayed as a even page header when the sheet is printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_HeaderFirst" data-uid="C1.WPF.Excel.XLPrintSettings.HeaderFirst">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.HeaderFirst.html#C1_WPF_Excel_XLPrintSettings_HeaderFirst">HeaderFirst</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the string to be displayed as a first page header when the sheet is printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_HeaderPictureCenter" data-uid="C1.WPF.Excel.XLPrintSettings.HeaderPictureCenter">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.HeaderPictureCenter.html#C1_WPF_Excel_XLPrintSettings_HeaderPictureCenter">HeaderPictureCenter</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <span class="xref">C1.WPF.Bitmap.C1Bitmap</span> or <a class="xref" href="C1.WPF.Excel.XLPictureShape.html">XLPictureShape</a> for the center part of the header.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_HeaderPictureLeft" data-uid="C1.WPF.Excel.XLPrintSettings.HeaderPictureLeft">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.HeaderPictureLeft.html#C1_WPF_Excel_XLPrintSettings_HeaderPictureLeft">HeaderPictureLeft</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <span class="xref">C1.WPF.Bitmap.C1Bitmap</span> or <a class="xref" href="C1.WPF.Excel.XLPictureShape.html">XLPictureShape</a> for the left part of the header.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_HeaderPictureRight" data-uid="C1.WPF.Excel.XLPrintSettings.HeaderPictureRight">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.HeaderPictureRight.html#C1_WPF_Excel_XLPrintSettings_HeaderPictureRight">HeaderPictureRight</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the <span class="xref">C1.WPF.Bitmap.C1Bitmap</span> or <a class="xref" href="C1.WPF.Excel.XLPictureShape.html">XLPictureShape</a> for the right part of the header.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_Landscape" data-uid="C1.WPF.Excel.XLPrintSettings.Landscape">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.Landscape.html#C1_WPF_Excel_XLPrintSettings_Landscape">Landscape</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether to print the sheet in landscape mode.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_MarginBottom" data-uid="C1.WPF.Excel.XLPrintSettings.MarginBottom">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.MarginBottom.html#C1_WPF_Excel_XLPrintSettings_MarginBottom">MarginBottom</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the bottom margin, in inches. Set to a negative value to use the default margin.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_MarginFooter" data-uid="C1.WPF.Excel.XLPrintSettings.MarginFooter">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.MarginFooter.html#C1_WPF_Excel_XLPrintSettings_MarginFooter">MarginFooter</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the footer margin, in inches. Set to a negative value to use the default margin.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_MarginHeader" data-uid="C1.WPF.Excel.XLPrintSettings.MarginHeader">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.MarginHeader.html#C1_WPF_Excel_XLPrintSettings_MarginHeader">MarginHeader</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the header margin, in inches. Set to a negative value to use the default margin.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_MarginLeft" data-uid="C1.WPF.Excel.XLPrintSettings.MarginLeft">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.MarginLeft.html#C1_WPF_Excel_XLPrintSettings_MarginLeft">MarginLeft</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the left margin, in inches. Set to a negative value to use the default margin.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_MarginRight" data-uid="C1.WPF.Excel.XLPrintSettings.MarginRight">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.MarginRight.html#C1_WPF_Excel_XLPrintSettings_MarginRight">MarginRight</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the right margin, in inches. Set to a negative value to use the default margin.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_MarginTop" data-uid="C1.WPF.Excel.XLPrintSettings.MarginTop">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.MarginTop.html#C1_WPF_Excel_XLPrintSettings_MarginTop">MarginTop</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the top margin, in inches. Set to a negative value to use the default margin.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_PaperKind" data-uid="C1.WPF.Excel.XLPrintSettings.PaperKind">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.PaperKind.html#C1_WPF_Excel_XLPrintSettings_PaperKind">PaperKind</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the paper size to use when printing the sheet.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_PrintGridlines" data-uid="C1.WPF.Excel.XLPrintSettings.PrintGridlines">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.PrintGridlines.html#C1_WPF_Excel_XLPrintSettings_PrintGridlines">PrintGridlines</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the gridlines will be printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_PrintHeaders" data-uid="C1.WPF.Excel.XLPrintSettings.PrintHeaders">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.PrintHeaders.html#C1_WPF_Excel_XLPrintSettings_PrintHeaders">PrintHeaders</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether row and column headers (the areas with row numbers and column letters) will be printed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_PrintPagesInRows" data-uid="C1.WPF.Excel.XLPrintSettings.PrintPagesInRows">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.PrintPagesInRows.html#C1_WPF_Excel_XLPrintSettings_PrintPagesInRows">PrintPagesInRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether to print the pages in rows (across first) or in columns (down first).</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_ScaleWithDocument" data-uid="C1.WPF.Excel.XLPrintSettings.ScaleWithDocument">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.ScaleWithDocument.html#C1_WPF_Excel_XLPrintSettings_ScaleWithDocument">ScaleWithDocument</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the scales header/footer with document used for printed output.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_ScalingFactor" data-uid="C1.WPF.Excel.XLPrintSettings.ScalingFactor">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.ScalingFactor.html#C1_WPF_Excel_XLPrintSettings_ScalingFactor">ScalingFactor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the scaling factor (in percent) to use when printing the sheet.</p>
</td>
      </tr>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_StartPage" data-uid="C1.WPF.Excel.XLPrintSettings.StartPage">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.StartPage.html#C1_WPF_Excel_XLPrintSettings_StartPage">StartPage</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the initial page number to use when printing the sheet.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_WPF_Excel_XLPrintSettings_Clone" data-uid="C1.WPF.Excel.XLPrintSettings.Clone">
          <a class="xref" href="C1.WPF.Excel.XLPrintSettings.Clone.html#C1_WPF_Excel_XLPrintSettings_Clone">Clone()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new <a class="xref" href="C1.WPF.Excel.XLPrintSettings.html">XLPrintSettings</a> object that is a copy of the current instance.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>