Page History

...

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
title	C#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          PageSetup ps = wb.Worksheets[0].PageSetup;

Code Block

	vbnet
	vbnet
title	vb.net


          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ps As PageSetup = wb.Worksheets(0).PageSetup

Properties

Name

Description

Notes

BottomMargin

Excerpt Include

	EW8:PageSetup.BottomMargin
	EW8:PageSetup.BottomMargin
nopanel	true

CenterFooter

Excerpt Include

	EW8:PageSetup.CenterFooter
	EW8:PageSetup.CenterFooter
nopanel	true

CenterHeader

Excerpt Include

	EW8:PageSetup.CenterHeader
	EW8:PageSetup.CenterHeader
nopanel	true

CenterHorizontally

Excerpt Include

	EW8:PageSetup.CenterHorizontally
	EW8:PageSetup.CenterHorizontally
nopanel	true

Unsupported for charts

CenterVertically

Excerpt Include

	EW8:PageSetup.CenterVertically
	EW8:PageSetup.CenterVertically
nopanel	true

Unsupported for charts

FirstPageNumber

Excerpt Include

	EW8:PageSetup.FirstPageNumber
	EW8:PageSetup.FirstPageNumber
nopanel	true

FirstPageNumberAuto

Excerpt Include

	EW8:PageSetup.FirstPageNumberAuto
	EW8:PageSetup.FirstPageNumberAuto
nopanel	true

FitToPagesTall

Excerpt Include

	EW8:PageSetup.FitToPagesTall
	EW8:PageSetup.FitToPagesTall
nopanel	true

Unsupported for charts

FitToPagesWide

Excerpt Include

	EW8:PageSetup.FitToPagesWide
	EW8:PageSetup.FitToPagesWide
nopanel	true

Unsupported for charts

FooterMargin

Excerpt Include

	EW8:PageSetup.FooterMargin
	EW8:PageSetup.FooterMargin
nopanel	true

HeaderMargin

Excerpt Include

	EW8:PageSetup.HeaderMargin
	EW8:PageSetup.HeaderMargin
nopanel	true

LeftFooter

Excerpt Include

	EW8:PageSetup.LeftFooter
	EW8:PageSetup.LeftFooter
nopanel	true

LeftHeader

Excerpt Include

	EW8:PageSetup.LeftHeader
	EW8:PageSetup.LeftHeader
nopanel	true

LeftMargin

Excerpt Include

	EW8:PageSetup.LeftMargin
	EW8:PageSetup.LeftMargin
nopanel	true

Orientation

Excerpt Include

	EW8:PageSetup.Orientation
	EW8:PageSetup.Orientation
nopanel	true

PaperSize

Excerpt Include

	EW8:PageSetup.PaperSize
	EW8:PageSetup.PaperSize
nopanel	true

PrintArea

Excerpt Include

	EW8:PageSetup.PrintArea
	EW8:PageSetup.PrintArea
nopanel	true

Unsupported for charts

PrintAsDraft

Excerpt Include

	EW8:PageSetup.PrintAsDraft
	EW8:PageSetup.PrintAsDraft
nopanel	true

PrintCellErrorsAs

Excerpt Include

	EW8:PageSetup.PrintCellErrorsAs
	EW8:PageSetup.PrintCellErrorsAs
nopanel	true

Unsupported for charts

PrintComments

Excerpt Include

	EW8:PageSetup.PrintComments
	EW8:PageSetup.PrintComments
nopanel	true

Unsupported for charts

PrintCommentsAtEnd

Excerpt Include

	EW8:PageSetup.PrintCommentsAtEnd
	EW8:PageSetup.PrintCommentsAtEnd
nopanel	true

Unsupported for charts

PrintGridlines

Excerpt Include

	EW8:PageSetup.PrintGridlines
	EW8:PageSetup.PrintGridlines
nopanel	true

Unsupported for charts

PrintHeadings

Excerpt Include

	EW8:PageSetup.PrintHeadings
	EW8:PageSetup.PrintHeadings
nopanel	true

Unsupported for charts

PrintInBlackAndWhite

Excerpt Include

	EW8:PageSetup.PrintInBlackAndWhite
	EW8:PageSetup.PrintInBlackAndWhite
nopanel	true

PrintOrder

Excerpt Include

	EW8:PageSetup.PrintOrder
	EW8:PageSetup.PrintOrder
nopanel	true

Unsupported for charts

PrintTitles

Excerpt Include

	EW8:PageSetup.PrintTitles
	EW8:PageSetup.PrintTitles
nopanel	true

Unsupported for charts

RightFooter

Excerpt Include

	EW8:PageSetup.RightFooter
	EW8:PageSetup.RightFooter
nopanel	true

RightHeader

Excerpt Include

	EW8:PageSetup.RightHeader
	EW8:PageSetup.RightHeader
nopanel	true

RightMargin

Excerpt Include

	EW8:PageSetup.RightMargin
	EW8:PageSetup.RightMargin
nopanel	true

TopMargin

Excerpt Include

	EW8:PageSetup.TopMargin
	EW8:PageSetup.TopMargin
nopanel	true

UseZoom

Excerpt Include

	EW8:PageSetup.UseZoom
	EW8:PageSetup.UseZoom
nopanel	true

Unsupported for charts

Zoom

Excerpt Include

	EW8:PageSetup.Zoom
	EW8:PageSetup.Zoom
nopanel	true

Unsupported for charts

Methods

Name

Description

Notes

GetFooter(HeaderFooterSection.Section)

Excerpt Include

	EW8:PageSetup.GetFooter(HeaderFooterSection.Section)
	EW8:PageSetup.GetFooter(HeaderFooterSection.Section)
nopanel	true

GetHeader(HeaderFooterSection.Section)

Excerpt Include

	EW8:PageSetup.GetHeader(HeaderFooterSection.Section)
	EW8:PageSetup.GetHeader(HeaderFooterSection.Section)
nopanel	true

SetPrintTitleColumns(Int32, Int32)

Excerpt Include

	EW8:PageSetup.SetPrintTitleColumns(Int32, Int32)
	EW8:PageSetup.SetPrintTitleColumns(Int32, Int32)
nopanel	true

Unsupported for charts

SetPrintTitleRows(Int32, Int32)

Excerpt Include

	EW8:PageSetup.SetPrintTitleRows(Int32, Int32)
	EW8:PageSetup.SetPrintTitleRows(Int32, Int32)
nopanel	true

Unsupported for charts

Classes

Name

Description

CellErrorsAs

Excerpt Include

	EW8:PageSetup.CellErrorsAs
	EW8:PageSetup.CellErrorsAs
nopanel	true

PageOrientation

Excerpt Include

	EW8:PageSetup.PageOrientation
	EW8:PageSetup.PageOrientation
nopanel	true

PagePaperSize

Excerpt Include

	EW8:PageSetup.PagePaperSize
	EW8:PageSetup.PagePaperSize
nopanel	true

PagePrintOrder

Excerpt Include

	EW8:PageSetup.PagePrintOrder
	EW8:PageSetup.PagePrintOrder
nopanel	true

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version 2

Key