OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 7

changes.mady.by.user Anonymous

Saved on

compared with

New Version Current

changes.mady.by.user Anonymous

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

The PageSetup class represents the page layout properties of a printed worksheet.

Signature
C#
C#
 public class PageSetup
{signature}{signature:
}
Signature
vb.net
vb.net
Public Class PageSetup
{signature}
{remarks}To return a {{PageSetup}} object, use [
Remarks

To return a PageSetup object, use Worksheet.PageSetup

|Worksheet.PageSetup]. {remarks} {example}{code:csharp|title=C#}

.

Example
Code Block
csharp
csharp
titleC#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          PageSetup ps = wb.Worksheets[0].PageSetup;
{code} {code:vbnet|title=
 Code Block
vbnet
vbnet
titlevb.net
}


          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ps As PageSetup = wb.Worksheets(0).PageSetup
        
{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|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=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}|
 Properties
Name
Description
BottomMargin
 Excerpt Include
PageSetup.BottomMargin
PageSetup.BottomMargin
nopaneltrue
CenterFooter
 Excerpt Include
PageSetup.CenterFooter
PageSetup.CenterFooter
nopaneltrue
CenterHeader
 Excerpt Include
PageSetup.CenterHeader
PageSetup.CenterHeader
nopaneltrue
CenterHorizontally
 Excerpt Include
PageSetup.CenterHorizontally
PageSetup.CenterHorizontally
nopaneltrue
CenterVertically
 Excerpt Include
PageSetup.CenterVertically
PageSetup.CenterVertically
nopaneltrue
FirstPageNumber
 Excerpt Include
PageSetup.FirstPageNumber
PageSetup.FirstPageNumber
nopaneltrue
FirstPageNumberAuto
 Excerpt Include
PageSetup.FirstPageNumberAuto
PageSetup.FirstPageNumberAuto
nopaneltrue
FitToPagesTall
 Excerpt Include
PageSetup.FitToPagesTall
PageSetup.FitToPagesTall
nopaneltrue
FitToPagesWide
 Excerpt Include
PageSetup.FitToPagesWide
PageSetup.FitToPagesWide
nopaneltrue
FooterMargin
 Excerpt Include
PageSetup.FooterMargin
PageSetup.FooterMargin
nopaneltrue
HeaderMargin
 Excerpt Include
PageSetup.HeaderMargin
PageSetup.HeaderMargin
nopaneltrue
LeftFooter
 Excerpt Include
PageSetup.LeftFooter
PageSetup.LeftFooter
nopaneltrue
LeftHeader
 Excerpt Include
PageSetup.LeftHeader
PageSetup.LeftHeader
nopaneltrue
LeftMargin
 Excerpt Include
PageSetup.LeftMargin
PageSetup.LeftMargin
nopaneltrue
Orientation
 Excerpt Include
PageSetup.Orientation
PageSetup.Orientation
nopaneltrue
PaperSize
 Excerpt Include
PageSetup.PaperSize
PageSetup.PaperSize
nopaneltrue
PrintArea
 Excerpt Include
PageSetup.PrintArea
PageSetup.PrintArea
nopaneltrue
PrintAsDraft
 Excerpt Include
PageSetup.PrintAsDraft
PageSetup.PrintAsDraft
nopaneltrue
PrintCellErrorsAs
 Excerpt Include
PageSetup.PrintCellErrorsAs
PageSetup.PrintCellErrorsAs
nopaneltrue
PrintComments
 Excerpt Include
PageSetup.PrintComments
PageSetup.PrintComments
nopaneltrue
PrintCommentsAtEnd
 Excerpt Include
PageSetup.PrintCommentsAtEnd
PageSetup.PrintCommentsAtEnd
nopaneltrue
PrintGridlines
 Excerpt Include
PageSetup.PrintGridlines
PageSetup.PrintGridlines
nopaneltrue
PrintHeadings
 Excerpt Include
PageSetup.PrintHeadings
PageSetup.PrintHeadings
nopaneltrue
PrintInBlackAndWhite
 Excerpt Include
PageSetup.PrintInBlackAndWhite
PageSetup.PrintInBlackAndWhite
nopaneltrue
PrintOrder
 Excerpt Include
PageSetup.PrintOrder
PageSetup.PrintOrder
nopaneltrue
PrintTitles
 Excerpt Include
PageSetup.PrintTitles
PageSetup.PrintTitles
nopaneltrue
RightFooter
 Excerpt Include
PageSetup.RightFooter
PageSetup.RightFooter
nopaneltrue
RightHeader
 Excerpt Include
PageSetup.RightHeader
PageSetup.RightHeader
nopaneltrue
RightMargin
 Excerpt Include
PageSetup.RightMargin
PageSetup.RightMargin
nopaneltrue
TopMargin
 Excerpt Include
PageSetup.TopMargin
PageSetup.TopMargin
nopaneltrue
UseZoom
 Excerpt Include
PageSetup.UseZoom
PageSetup.UseZoom
nopaneltrue
Zoom
 Excerpt Include
PageSetup.Zoom
PageSetup.Zoom
nopaneltrue
 Methods
Name
Description
GetFooter(HeaderFooterSection.Section)
 Excerpt Include
PageSetup.GetFooter(HeaderFooterSection.Section)
PageSetup.GetFooter(HeaderFooterSection.Section)
nopaneltrue
GetHeader(HeaderFooterSection.Section)
 Excerpt Include
PageSetup.GetHeader(HeaderFooterSection.Section)
PageSetup.GetHeader(HeaderFooterSection.Section)
nopaneltrue
SetPrintTitleColumns(Int32, Int32)
 Excerpt Include
PageSetup.SetPrintTitleColumns(Int32, Int32)
PageSetup.SetPrintTitleColumns(Int32, Int32)
nopaneltrue
SetPrintTitleRows(Int32, Int32)
 Excerpt Include
PageSetup.SetPrintTitleRows(Int32, Int32)
PageSetup.SetPrintTitleRows(Int32, Int32)
nopaneltrue
 Classes
Name
Description
CellErrorsAs
 Excerpt Include
PageSetup.CellErrorsAs
PageSetup.CellErrorsAs
nopaneltrue
PageOrientation
 Excerpt Include
PageSetup.PageOrientation
PageSetup.PageOrientation
nopaneltrue
PagePaperSize
 Excerpt Include
PageSetup.PagePaperSize
PageSetup.PagePaperSize
nopaneltrue
PagePrintOrder
 Excerpt Include
PageSetup.PagePrintOrder
PageSetup.PagePrintOrder
nopaneltrue