Skip to main content

XlPageSetup.PaperKind Property

Gets or sets a value that specifies the paper size used when a worksheet is being printed.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public DXPaperKind PaperKind { get; set; }

Property Value

Type Description
DXPaperKind

An enumeration value that indicates the paper size.

Available values:

Show 117 items
Name Description
Custom

The paper size is defined by the user.

Letter

Letter paper (8.5 in. by 11 in.).

Legal

Legal paper (8.5 in. by 14 in.).

A4

A4 paper (210 mm by 297 mm).

CSheet

C paper (17 in. by 22 in.).

DSheet

D paper (22 in. by 34 in.).

ESheet

E paper (34 in. by 44 in.).

LetterSmall

Letter small paper (8.5 in. by 11 in.).

Tabloid

Tabloid paper (11 in. by 17 in.).

Ledger

Ledger paper (17 in. by 11 in.).

Statement

Statement paper (5.5 in. by 8.5 in.).

Executive

Executive paper (7.25 in. by 10.5 in.).

A3

A3 paper (297 mm by 420 mm).

A4Small

A4 small paper (210 mm by 297 mm).

A5

A5 paper (148 mm by 210 mm).

B4

B4 paper (250 mm by 353 mm).

B5

B5 paper (176 mm by 250 mm).

Folio

Folio paper (8.5 in. by 13 in.).

Quarto

Quarto paper (215 mm by 275 mm).

Standard10x14

Standard paper (10 in. by 14 in.).

Standard11x17

Standard paper (11 in. by 17 in.).

Note

Note paper (8.5 in. by 11 in.).

Number9Envelope

#9 envelope (3.875 in. by 8.875 in.).

Number10Envelope

#10 envelope (4.125 in. by 9.5 in.).

Number11Envelope

#11 envelope (4.5 in. by 10.375 in.).

Number12Envelope

#12 envelope (4.75 in. by 11 in.).

Number14Envelope

#14 envelope (5 in. by 11.5 in.).

DLEnvelope

DL envelope (110 mm by 220 mm).

C5Envelope

C5 envelope (162 mm by 229 mm).s

C3Envelope

C3 envelope (324 mm by 458 mm).

C4Envelope

C4 envelope (229 mm by 324 mm).

C6Envelope

C65 envelope (114 mm by 229 mm).

C65Envelope

C6 envelope (114 mm by 162 mm).

B4Envelope

B4 envelope (250 mm by 353 mm).

B5Envelope

B5 envelope (176 mm by 250 mm).

B6Envelope

B6 envelope (176 mm by 125 mm).

ItalyEnvelope

Italy envelope (110 mm by 230 mm).

MonarchEnvelope

Monarch envelope (3.875 in. by 7.5 in.).

PersonalEnvelope

6 3/4 envelope (3.625 in. by 6.5 in.).

USStandardFanfold

US standard fanfold (14.875 in. by 11 in.).

GermanStandardFanfold

German standard fanfold (8.5 in. by 12 in.).

GermanLegalFanfold

German legal fanfold (8.5 in. by 13 in.).

IsoB4

ISO B4 (250 mm by 353 mm).

JapanesePostcard

Japanese postcard (100 mm by 148 mm).

Standard9x11

Standard paper (9 in. by 11 in.).

Standard10x11

Standard paper (10 in. by 11 in.).

Standard15x11

Standard paper (15 in. by 11 in.).

InviteEnvelope

Invitation envelope (220 mm by 220 mm).

LetterExtra

Letter extra paper (9.275 in. by 12 in.). This value is specific to the PostScript driver and is used only by Linotronic printers in order to conserve paper.

LegalExtra

Legal extra paper (9.275 in. by 15 in.). This value is specific to the PostScript driver and is used only by Linotronic printers in order to conserve paper.

TabloidExtra

Tabloid extra paper (11.69 in. by 18 in.). This value is specific to the PostScript driver and is used only by Linotronic printers in order to conserve paper.

A4Extra

A4 extra paper (236 mm by 322 mm). This value is specific to the PostScript driver and is used only by Linotronic printers to help save paper.

LetterTransverse

Letter transverse paper (8.275 in. by 11 in.).

A4Transverse

A4 transverse paper (210 mm by 297 mm).

LetterExtraTransverse

Letter extra transverse paper (9.275 in. by 12 in.).

APlus

SuperA/SuperA/A4 paper (227 mm by 356 mm).

BPlus

SuperB/SuperB/A3 paper (305 mm by 487 mm).

LetterPlus

Letter plus paper (8.5 in. by 12.69 in.).

A4Plus

A4 plus paper (210 mm by 330 mm).

A5Transverse

A5 transverse paper (148 mm by 210 mm).

B5Transverse

JIS B5 transverse paper (182 mm by 257 mm).

A3Extra

A3 extra paper (322 mm by 445 mm).

A5Extra

A5 extra paper (174 mm by 235 mm).

B5Extra

ISO B5 extra paper (201 mm by 276 mm).

A2

A2 paper (420 mm by 594 mm).

A3Transverse

A3 transverse paper (297 mm by 420 mm).

A3ExtraTransverse

A3 extra transverse paper (322 mm by 445 mm).

JapaneseDoublePostcard

Japanese double postcard (200 mm by 148 mm). Requires Windows NT 4.0 or later.

A6

A6 paper (105 mm by 148 mm). Requires Windows NT 4.0 or later.

JapaneseEnvelopeKakuNumber2

Japanese Kaku #2 envelope. Requires Windows NT 4.0 or later.

JapaneseEnvelopeKakuNumber3

Japanese Kaku #3 envelope. Requires Windows NT 4.0 or later.

JapaneseEnvelopeChouNumber3

Japanese Chou #3 envelope. Requires Windows NT 4.0 or later.

JapaneseEnvelopeChouNumber4

Japanese Chou #4 envelope. Requires Windows NT 4.0 or later.

LetterRotated

Letter rotated paper (11 in. by 8.5 in.).

A3Rotated

A3 rotated paper (420 mm by 297 mm).

A4Rotated

A4 rotated paper (297 mm by 210 mm). Requires Windows NT 4.0 or later.

A5Rotated

A5 rotated paper (210 mm by 148 mm).

B4JisRotated

JIS B4 rotated paper (364 mm by 257 mm). Requires Windows NT 4.0 or later.

B5JisRotated

JIS B5 rotated paper (257 mm by 182 mm). Requires Windows NT 4.0 or later.

JapanesePostcardRotated

Japanese rotated postcard (148 mm by 100 mm). Requires Windows NT 4.0 or later.

JapaneseDoublePostcardRotated

Japanese rotated double postcard (148 mm by 200 mm). Requires Windows NT 4.0 or later.

A6Rotated

A6 rotated paper (148 mm by 105 mm). Requires Windows NT 4.0 or later.

JapaneseEnvelopeKakuNumber2Rotated

Japanese rotated Kaku #2 envelope. Requires Windows NT 4.0 or later.

JapaneseEnvelopeKakuNumber3Rotated

Japanese rotated Kaku #3 envelope. Requires Windows NT 4.0 or later.

JapaneseEnvelopeChouNumber3Rotated

Japanese rotated Chou #3 envelope. Requires Windows NT 4.0 or later.

JapaneseEnvelopeChouNumber4Rotated

Japanese rotated Chou #4 envelope. Requires Windows NT 4.0 or later.

B6Jis

JIS B6 paper (128 mm by 182 mm). Requires Windows NT 4.0 or later.

B6JisRotated

JIS B6 rotated paper (182 mm by 128 mm). Requires Windows NT 4.0 or later.

Standard12x11

Standard paper (12 in. by 11 in.). Requires Windows NT 4.0 or later.

JapaneseEnvelopeYouNumber4

Japanese You #4 envelope. Requires Windows NT 4.0 or later.

JapaneseEnvelopeYouNumber4Rotated

Japanese You #4 rotated envelope. Requires Windows NT 4.0 or later.

Prc16K

16K paper (146 mm by 215 mm). Requires Windows NT 4.0 or later.

Prc32K

32K paper (97 mm by 151 mm). Requires Windows NT 4.0 or later.

Prc32KBig

32K big paper (97 mm by 151 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber1

#1 rotated envelope (165 mm by 102 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber2

#2 envelope (102 mm by 176 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber3

#3 envelope (125 mm by 176 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber4

#4 envelope (110 mm by 208 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber5

#5 envelope (110 mm by 220 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber6

#6 envelope (120 mm by 230 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber7

#7 envelope (160 mm by 230 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber8

#8 envelope (120 mm by 309 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber9

#9 envelope (229 mm by 324 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber10

#10 envelope (324 mm by 458 mm). Requires Windows NT 4.0 or later.

Prc16KRotated

16K rotated paper (146 mm by 215 mm). Requires Windows NT 4.0 or later.

Prc32KRotated

32K rotated paper (97 mm by 151 mm). Requires Windows NT 4.0 or later.

Prc32KBigRotated

32K big rotated paper (97 mm by 151 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber1Rotated

#1 rotated envelope (165 mm by 102 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber2Rotated

#2 rotated envelope (176 mm by 102 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber3Rotated

#3 rotated envelope (176 mm by 125 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber4Rotated

#4 rotated envelope (208 mm by 110 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber5Rotated

Envelope #5 rotated envelope (220 mm by 110 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber6Rotated

#6 rotated envelope (230 mm by 120 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber7Rotated

#7 rotated envelope (230 mm by 160 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber8Rotated

#8 rotated envelope (309 mm by 120 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber9Rotated

#9 rotated envelope (324 mm by 229 mm). Requires Windows NT 4.0 or later.

PrcEnvelopeNumber10Rotated

#10 rotated envelope (458 mm by 324 mm). Requires Windows NT 4.0 or later.

Remarks

To specify page options for a worksheet, set the IXlSheet.PageSetup property to an instance of the XlPageSetup class that controls the page orientation, paper size, scaling options, printing DPI and other settings. For more information on how to adjust page formatting options, refer to the How to: Specify Print Settings article.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

// Specify page settings for the worksheet.
sheet.PageSetup = new XlPageSetup();
// Select the paper size.
sheet.PageSetup.PaperKind = System.Drawing.Printing.PaperKind.A4;
// Set the page orientation to Landscape.
sheet.PageSetup.PageOrientation = XlPageOrientation.Landscape;
//  Scale the print area to fit to one page wide.
sheet.PageSetup.FitToPage = true;
sheet.PageSetup.FitToWidth = 1;
sheet.PageSetup.FitToHeight = 0;
//  Print in black and white.
sheet.PageSetup.BlackAndWhite = true;
// Specify the number of copies.
sheet.PageSetup.Copies = 2;

The following code snippets (auto-collected from DevExpress Examples) contain references to the PaperKind property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also