.
| Description |
|---|
| Excerpt |
|---|
The PageSetup class represents the page layout properties of a printed worksheet. |
| Signature | C# | C# | |
|---|---|---|---|
| Wiki Markup | |||
{description}
{excerpt}The [PageSetup|PageSetup] class represents the page layout properties of a printed worksheet.{excerpt}
{signature:C#}
public class PageSetup
| |||
| Signature | |||
{signature}{signature:vb.net | vb.net | }
Public Class PageSetup
| |
| Remarks | |||
To return a PageSetup object, use {signature} {remarks}To return a {{PageSetup}} object, use [Worksheet.PageSetup. | |||
| Example | |||
| Code Block | | csharp | csharp |
| title | C# | ||
| Code Block | vbnet | vbnet | title |
| Properties |
|---|
...
Name
...
Description
...
...
{code} {example} {properties} ||Name||Description|| |[BottomMargin|PageSetup.BottomMargin]|{excerpt-include:PageSetup.BottomMargin |
...
|nopanel=true}| |[CenterFooter|PageSetup.CenterFooter]|{excerpt-include |
...
:PageSetup.CenterFooter |
...
|nopanel=true}| |[CenterHeader|PageSetup.CenterHeader]|{excerpt-include |
...
:PageSetup.CenterHeader |
...
|nopanel=true}| |[CenterHorizontally|PageSetup.CenterHorizontally]|{excerpt-include |
...
:PageSetup.CenterHorizontally |
...
|nopanel=true}| |[CenterVertically|PageSetup.CenterVertically]|{excerpt-include |
...
:PageSetup.CenterVertically |
...
|nopanel=true}| |[FirstPageNumber|PageSetup.FirstPageNumber]|{excerpt-include |
...
:PageSetup.FirstPageNumber |
...
|nopanel=true}| |[FirstPageNumberAuto|PageSetup.FirstPageNumberAuto]|{excerpt-include |
...
:PageSetup.FirstPageNumberAuto |
...
|nopanel=true}| |[FitToPagesTall|PageSetup.FitToPagesTall]|{excerpt-include |
...
:PageSetup.FitToPagesTall |
...
|nopanel=true}| |[FitToPagesWide|PageSetup.FitToPagesWide]|{excerpt-include |
...
:PageSetup.FitToPagesWide |
...
|nopanel=true}| |[FooterMargin|PageSetup.FooterMargin]|{excerpt-include |
...
:PageSetup.FooterMargin |
...
|nopanel=true}| |[HeaderMargin|PageSetup.HeaderMargin]|{excerpt-include |
...
:PageSetup.HeaderMargin |
...
|nopanel=true}| |[LeftFooter|PageSetup.LeftFooter]|{excerpt-include |
...
:PageSetup.LeftFooter |
...
|nopanel=true}| |[LeftHeader|PageSetup.LeftHeader]|{excerpt-include |
...
:PageSetup.LeftHeader |
...
|nopanel=true}| |[LeftMargin|PageSetup.LeftMargin]|{excerpt-include |
...
:PageSetup.LeftMargin |
...
|nopanel=true}| |[Orientation|PageSetup.Orientation]|{excerpt-include |
...
:PageSetup.Orientation |
...
|nopanel=true}| |[PaperSize|PageSetup.PaperSize]|{excerpt-include |
...
:PageSetup.PaperSize |
...
|nopanel=true}| |[PrintArea|PageSetup.PrintArea]|{excerpt-include |
...
:PageSetup.PrintArea |
...
|nopanel=true}| |[PrintAsDraft|PageSetup.PrintAsDraft]|{excerpt-include |
...
:PageSetup.PrintAsDraft |
...
|nopanel=true}| |[PrintCellErrorsAs|PageSetup.PrintCellErrorsAs]|{excerpt-include |
...
:PageSetup.PrintCellErrorsAs |
...
|nopanel=true}| |[PrintComments|PageSetup.PrintComments]|{excerpt-include |
...
:PageSetup.PrintComments |
...
|nopanel=true}| |[PrintCommentsAtEnd|PageSetup.PrintCommentsAtEnd]|{excerpt-include |
...
:PageSetup.PrintCommentsAtEnd |
...
|nopanel=true}| |[PrintGridlines|PageSetup.PrintGridlines]|{excerpt-include |
...
:PageSetup.PrintGridlines |
...
|nopanel=true}| |[PrintHeadings|PageSetup.PrintHeadings]|{excerpt-include |
...
:PageSetup.PrintHeadings |
...
|nopanel=true}| |[PrintInBlackAndWhite|PageSetup.PrintInBlackAndWhite]|{excerpt-include |
...
:PageSetup.PrintInBlackAndWhite |
...
|nopanel=true}| |[PrintOrder|PageSetup.PrintOrder]|{excerpt-include |
...
:PageSetup.PrintOrder |
...
|nopanel=true}| |[PrintTitles|PageSetup.PrintTitles]|{excerpt-include |
...
:PageSetup.PrintTitles |
...
|nopanel=true}| |[RightFooter|PageSetup.RightFooter]|{excerpt-include |
...
:PageSetup.RightFooter |
...
|nopanel=true}| |[RightHeader|PageSetup.RightHeader]|{excerpt-include |
...
:PageSetup.RightHeader |
...
|nopanel=true}| |[RightMargin|PageSetup.RightMargin]|{excerpt-include |
...
:PageSetup.RightMargin |
...
|nopanel=true}| |[TopMargin|PageSetup.TopMargin]|{excerpt-include |
...
:PageSetup.TopMargin |
...
|nopanel=true}| |[UseZoom|PageSetup.UseZoom]|{excerpt-include |
...
:PageSetup.UseZoom |
...
|nopanel=true}| |[Zoom|PageSetup.Zoom]|{excerpt-include |
...
:PageSetup.Zoom |
...
| Methods |
|---|
...
Name
...
Description
|nopanel=true}| {methods} ||Name||Description|| |[GetFooter(HeaderFooterSection.Section) |
...
|PageSetup.GetFooter(HeaderFooterSection.Section) |
...
]|{excerpt-include:PageSetup.GetFooter(HeaderFooterSection.Section) |
...
|nopanel |
...
=true}| |[GetHeader(HeaderFooterSection.Section) |
...
|PageSetup.GetHeader(HeaderFooterSection.Section) |
...
]|{excerpt-include:PageSetup.GetHeader(HeaderFooterSection.Section) |
...
|nopanel |
...
=true}| |[SetPrintTitleColumns(Int32, Int32) |
...
|PageSetup.SetPrintTitleColumns(Int32, Int32) |
...
]|{excerpt-include:PageSetup.SetPrintTitleColumns(Int32, Int32) |
...
|nopanel |
...
=true}| |[SetPrintTitleRows(Int32, Int32) |
...
|PageSetup.SetPrintTitleRows(Int32, Int32) |
...
]|{excerpt-include:PageSetup.SetPrintTitleRows(Int32, Int32) |
...
|nopanel |
...
| Classes |
|---|
...
Name
...
Description
...
...
...
...
...
=true}|
{classes}
||Name||Description||
|[CellErrorsAs|PageSetup.CellErrorsAs]|{excerpt-include:PageSetup.CellErrorsAs|nopanel=true}|
|[PageOrientation|PageSetup.PageOrientation]|{excerpt-include:PageSetup.PageOrientation|nopanel=true}|
|[PagePaperSize|PageSetup.PagePaperSize]|{excerpt-include:PageSetup.PagePaperSize|nopanel=true}|
|[PagePrintOrder|PageSetup.PagePrintOrder]|{excerpt-include:PageSetup.PagePrintOrder|nopanel=true}| |