Excel.Interfaces.PageLayoutUpdateData interface

一个用于更新页面布局对象上的数据的接口, 可用于 "页面布局 (An interface for updating data on the PageLayout object, for use in "pageLayout.set({ ... })".

属性

blackAndWhite

获取或设置工作表的黑白打印选项。Gets or sets the worksheet's black and white print option.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

bottomMargin

获取或设置要用于打印的工作表的底部页边距(以磅为单位)。Gets or sets the worksheet's bottom page margin to use for printing in points.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

centerHorizontally

获取或设置工作表的中心水平标记。Gets or sets the worksheet's center horizontally flag. 此标记确定在打印时是否水平居中工作表。This flag determines whether the worksheet will be centered horizontally when it's printed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

centerVertically

获取或设置工作表的中心垂直标记。Gets or sets the worksheet's center vertically flag. 此标记确定在打印时是否垂直居中工作表。This flag determines whether the worksheet will be centered vertically when it's printed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

draftMode

获取或设置工作表的草稿模式选项。Gets or sets the worksheet's draft mode option. 如果为 True,则将打印没有图形的工作表。If true the sheet will be printed without graphics.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

firstPageNumber

获取或设置要打印的工作表的首页页码。Gets or sets the worksheet's first page number to print. Null 值表示“自动”页码编号。Null value represents "auto" page numbering.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

footerMargin

获取或设置在打印时使用的工作表的页脚边距(以磅为单位)。Gets or sets the worksheet's footer margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

headerMargin

获取或设置在打印时使用的工作表的页眉边距(以磅为单位)。Gets or sets the worksheet's header margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

headersFooters

工作表的页眉和页脚配置。Header and footer configuration for the worksheet.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

leftMargin

获取或设置在打印时使用的工作表的左边距(以磅为单位)。Gets or sets the worksheet's left margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

orientation

获取或设置工作表的页面方向。Gets or sets the worksheet's orientation of the page.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

paperSize

获取或设置工作表的页面纸张大小。Gets or sets the worksheet's paper size of the page.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printComments

获取或设置在打印时是否应该显示工作表的批注。Gets or sets whether the worksheet's comments should be displayed when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printErrors

获取或设置工作表的打印错误选项。Gets or sets the worksheet's print errors option.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printGridlines

获取或设置工作表的打印网格线标记。Gets or sets the worksheet's print gridlines flag. 此标记确定是否打印网格线。This flag determines whether gridlines will be printed or not.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printHeadings

获取或设置工作表的打印标题标记。Gets or sets the worksheet's print headings flag. 此标记确定是否打印标题。This flag determines whether headings will be printed or not.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printOrder

获取或设置工作表的页面打印顺序选项。Gets or sets the worksheet's page print order option. 它指定用于处理打印页码的顺序。This specifies the order to use for processing the page number printed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

rightMargin

获取或设置在打印时使用的工作表的右边距(以磅为单位)。Gets or sets the worksheet's right margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

topMargin

获取或设置在打印时使用的工作表的上边距(以磅为单位)。Gets or sets the worksheet's top margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

zoom

获取或设置工作表的打印缩放选项。Gets or sets the worksheet's print zoom options.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

属性详细信息

blackAndWhite

获取或设置工作表的黑白打印选项。Gets or sets the worksheet's black and white print option.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

blackAndWhite?: boolean;

属性值

boolean

bottomMargin

获取或设置要用于打印的工作表的底部页边距(以磅为单位)。Gets or sets the worksheet's bottom page margin to use for printing in points.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

bottomMargin?: number;

属性值

number

centerHorizontally

获取或设置工作表的中心水平标记。Gets or sets the worksheet's center horizontally flag. 此标记确定在打印时是否水平居中工作表。This flag determines whether the worksheet will be centered horizontally when it's printed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

centerHorizontally?: boolean;

属性值

boolean

centerVertically

获取或设置工作表的中心垂直标记。Gets or sets the worksheet's center vertically flag. 此标记确定在打印时是否垂直居中工作表。This flag determines whether the worksheet will be centered vertically when it's printed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

centerVertically?: boolean;

属性值

boolean

draftMode

获取或设置工作表的草稿模式选项。Gets or sets the worksheet's draft mode option. 如果为 True,则将打印没有图形的工作表。If true the sheet will be printed without graphics.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

draftMode?: boolean;

属性值

boolean

firstPageNumber

获取或设置要打印的工作表的首页页码。Gets or sets the worksheet's first page number to print. Null 值表示“自动”页码编号。Null value represents "auto" page numbering.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

firstPageNumber?: number | "";

属性值

number | ""

footerMargin

获取或设置在打印时使用的工作表的页脚边距(以磅为单位)。Gets or sets the worksheet's footer margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

footerMargin?: number;

属性值

number

headerMargin

获取或设置在打印时使用的工作表的页眉边距(以磅为单位)。Gets or sets the worksheet's header margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

headerMargin?: number;

属性值

number

headersFooters

工作表的页眉和页脚配置。Header and footer configuration for the worksheet.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

headersFooters?: Excel.Interfaces.HeaderFooterGroupUpdateData;

属性值

leftMargin

获取或设置在打印时使用的工作表的左边距(以磅为单位)。Gets or sets the worksheet's left margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

leftMargin?: number;

属性值

number

orientation

获取或设置工作表的页面方向。Gets or sets the worksheet's orientation of the page.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

orientation?: Excel.PageOrientation | "Portrait" | "Landscape";

属性值

Excel.PageOrientation | "Portrait" | "Landscape"

paperSize

获取或设置工作表的页面纸张大小。Gets or sets the worksheet's paper size of the page.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

paperSize?: Excel.PaperType | "Letter" | "LetterSmall" | "Tabloid" | "Ledger" | "Legal" | "Statement" | "Executive" | "A3" | "A4" | "A4Small" | "A5" | "B4" | "B5" | "Folio" | "Quatro" | "Paper10x14" | "Paper11x17" | "Note" | "Envelope9" | "Envelope10" | "Envelope11" | "Envelope12" | "Envelope14" | "Csheet" | "Dsheet" | "Esheet" | "EnvelopeDL" | "EnvelopeC5" | "EnvelopeC3" | "EnvelopeC4" | "EnvelopeC6" | "EnvelopeC65" | "EnvelopeB4" | "EnvelopeB5" | "EnvelopeB6" | "EnvelopeItaly" | "EnvelopeMonarch" | "EnvelopePersonal" | "FanfoldUS" | "FanfoldStdGerman" | "FanfoldLegalGerman";

属性值

Excel.PaperType | "Letter" | "LetterSmall" | "Tabloid" | "Ledger" | "Legal" | "Statement" | "Executive" | "A3" | "A4" | "A4Small" | "A5" | "B4" | "B5" | "Folio" | "Quatro" | "Paper10x14" | "Paper11x17" | "Note" | "Envelope9" | "Envelope10" | "Envelope11" | "Envelope12" | "Envelope14" | "Csheet" | "Dsheet" | "Esheet" | "EnvelopeDL" | "EnvelopeC5" | "EnvelopeC3" | "EnvelopeC4" | "EnvelopeC6" | "EnvelopeC65" | "EnvelopeB4" | "EnvelopeB5" | "EnvelopeB6" | "EnvelopeItaly" | "EnvelopeMonarch" | "EnvelopePersonal" | "FanfoldUS" | "FanfoldStdGerman" | "FanfoldLegalGerman"

printComments

获取或设置在打印时是否应该显示工作表的批注。Gets or sets whether the worksheet's comments should be displayed when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printComments?: Excel.PrintComments | "NoComments" | "EndSheet" | "InPlace";

属性值

Excel.PrintComments | "NoComments" | "EndSheet" | "InPlace"

printErrors

获取或设置工作表的打印错误选项。Gets or sets the worksheet's print errors option.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printErrors?: Excel.PrintErrorType | "AsDisplayed" | "Blank" | "Dash" | "NotAvailable";

属性值

Excel.PrintErrorType | "AsDisplayed" | "Blank" | "Dash" | "NotAvailable"

printGridlines

获取或设置工作表的打印网格线标记。Gets or sets the worksheet's print gridlines flag. 此标记确定是否打印网格线。This flag determines whether gridlines will be printed or not.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printGridlines?: boolean;

属性值

boolean

printHeadings

获取或设置工作表的打印标题标记。Gets or sets the worksheet's print headings flag. 此标记确定是否打印标题。This flag determines whether headings will be printed or not.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printHeadings?: boolean;

属性值

boolean

printOrder

获取或设置工作表的页面打印顺序选项。Gets or sets the worksheet's page print order option. 它指定用于处理打印页码的顺序。This specifies the order to use for processing the page number printed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

printOrder?: Excel.PrintOrder | "DownThenOver" | "OverThenDown";

属性值

Excel.PrintOrder | "DownThenOver" | "OverThenDown"

rightMargin

获取或设置在打印时使用的工作表的右边距(以磅为单位)。Gets or sets the worksheet's right margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

rightMargin?: number;

属性值

number

topMargin

获取或设置在打印时使用的工作表的上边距(以磅为单位)。Gets or sets the worksheet's top margin, in points, for use when printing.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

topMargin?: number;

属性值

number

zoom

获取或设置工作表的打印缩放选项。Gets or sets the worksheet's print zoom options.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

zoom?: Excel.PageLayoutZoomOptions;

属性值