Page tree

Versions Compared

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.

...

Remarks

To return a PageSetup object, use Worksheet.PageSetup.

Note

Since this object is tightly related to the client's printer setup, for those computers without a printer setup, changes to this object have no effect.

Example
Code Block
csharp
csharp
titleC#

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          PageSetup ps = wb.Worksheets[0].PageSetup;
        
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
        

...

Name

Description

BottomMargin

Excerpt Include
EW8:PageSetup.BottomMarginEW8:
PageSetup.BottomMargin
nopaneltrue

CenterFooter

Excerpt Include
EW8:PageSetup.CenterFooterEW8:
PageSetup.CenterFooter
nopaneltrue

CenterHeader

Excerpt Include
EW8:PageSetup.CenterHeaderEW8:
PageSetup.CenterHeader
nopaneltrue

CenterHorizontally

Excerpt Include
EW8:PageSetup.CenterHorizontallyEW8:
PageSetup.CenterHorizontally
nopaneltrue

CenterVertically

Excerpt Include
EW8:PageSetup.CenterVerticallyEW8:
PageSetup.CenterVertically
nopaneltrue

FirstPageNumber

Excerpt Include
EW8:PageSetup.FirstPageNumberEW8:
PageSetup.FirstPageNumber
nopaneltrue

FirstPageNumberAuto

Excerpt Include
EW8:PageSetup.FirstPageNumberAutoEW8:
PageSetup.FirstPageNumberAuto
nopaneltrue

FitToPagesTall

Excerpt Include
EW8:PageSetup.FitToPagesTallEW8:
PageSetup.FitToPagesTall
nopaneltrue

FitToPagesWide

Excerpt Include
EW8:PageSetup.FitToPagesWideEW8:
PageSetup.FitToPagesWide
nopaneltrue

FooterMargin

Excerpt Include
EW8:PageSetup.FooterMarginEW8:
PageSetup.FooterMargin
nopaneltrue

HeaderMargin

Excerpt Include
EW8:PageSetup.HeaderMarginEW8:
PageSetup.HeaderMargin
nopaneltrue

LeftFooter

Excerpt Include
EW8:PageSetup.LeftFooterEW8:
PageSetup.LeftFooter
nopaneltrue

LeftHeader

Excerpt Include
EW8:PageSetup.LeftHeaderEW8:
PageSetup.LeftHeader
nopaneltrue

LeftMargin

Excerpt Include
EW8:PageSetup.LeftMarginEW8:
PageSetup.LeftMargin
nopaneltrue

Orientation

Excerpt Include
EW8:PageSetup.OrientationEW8:
PageSetup.Orientation
nopaneltrue

PaperSize

Excerpt Include
EW8:PageSetup.PaperSizeEW8:
PageSetup.PaperSize
nopaneltrue

PrintArea

Excerpt Include
EW8:PageSetup.PrintAreaEW8:
PageSetup.PrintArea
nopaneltrue

PrintAsDraft

Excerpt Include
EW8:PageSetup.PrintAsDraftEW8:
PageSetup.PrintAsDraft
nopaneltrue

PrintCellErrorsAs

Excerpt Include
EW8:PageSetup.PrintCellErrorsAsEW8:
PageSetup.PrintCellErrorsAs
nopaneltrue

PrintComments

Excerpt Include
EW8:PageSetup.PrintCommentsEW8:
PageSetup.PrintComments
nopaneltrue

PrintCommentsAtEnd

Excerpt Include
EW8:PageSetup.PrintCommentsAtEndEW8:
PageSetup.PrintCommentsAtEnd
nopaneltrue

PrintGridlines

Excerpt Include
EW8:PageSetup.PrintGridlinesEW8:
PageSetup.PrintGridlines
nopaneltrue

PrintHeadings

Excerpt Include
EW8:PageSetup.PrintHeadingsEW8:
PageSetup.PrintHeadings
nopaneltrue

PrintInBlackAndWhite

Excerpt Include
EW8:PageSetup.PrintInBlackAndWhiteEW8:
PageSetup.PrintInBlackAndWhite
nopaneltrue

PrintOrder

Excerpt Include
EW8:PageSetup.PrintOrderEW8:
PageSetup.PrintOrder
nopaneltrue

PrintTitles

Excerpt Include
EW8:PageSetup.PrintTitlesEW8:
PageSetup.PrintTitles
nopaneltrue

RightFooter

Excerpt Include
EW8:PageSetup.RightFooterEW8:
PageSetup.RightFooter
nopaneltrue

RightHeader

Excerpt Include
EW8:PageSetup.RightHeaderEW8:
PageSetup.RightHeader
nopaneltrue

RightMargin

Excerpt Include
EW8:PageSetup.RightMarginEW8:
PageSetup.RightMargin
nopaneltrue

TopMargin

Excerpt Include
EW8:PageSetup.TopMarginEW8:
PageSetup.TopMargin
nopaneltrue

UseZoom

Excerpt Include
EW8:PageSetup.UseZoomEW8:
PageSetup.UseZoom
nopaneltrue

Zoom

Excerpt Include
EW8:PageSetup.ZoomEW8:
PageSetup.Zoom
nopaneltrue

...

Name

Description

GetFooter(HeaderFooterSection.Section)

Excerpt Include
EW8:PageSetup.GetFooter(HeaderFooterSection.Section)EW8:
PageSetup.GetFooter(HeaderFooterSection.Section)
nopaneltrue

GetHeader(HeaderFooterSection.Section)

Excerpt Include
EW8:PageSetup.GetHeader(HeaderFooterSection.Section)EW8:
PageSetup.GetHeader(HeaderFooterSection.Section)
nopaneltrue

SetPrintTitleColumns(Int32, Int32)

Excerpt Include
EW8:PageSetup.SetPrintTitleColumns(Int32, Int32)EW8:
PageSetup.SetPrintTitleColumns(Int32, Int32)
nopaneltrue

SetPrintTitleRows(Int32, Int32)

Excerpt Include
EW8:PageSetup.SetPrintTitleRows(Int32, Int32)EW8:
PageSetup.SetPrintTitleRows(Int32, Int32)
nopaneltrue

...

Name

Description

CellErrorsAs

Excerpt Include
EW8:PageSetup.CellErrorsAsEW8:
PageSetup.CellErrorsAs
nopaneltrue

PageOrientation

Excerpt Include
EW8:PageSetup.PageOrientationEW8:
PageSetup.PageOrientation
nopaneltrue

PagePaperSize

Excerpt Include
EW8:PageSetup.PagePaperSizeEW8:
PageSetup.PagePaperSize
nopaneltrue

PagePrintOrder

Excerpt Include
EW8:PageSetup.PagePrintOrderEW8:
PageSetup.PagePrintOrder
nopaneltrue