Excel.Interfaces.WorksheetCollectionLoadOptions interface

表示属于工作簿的 worksheet 对象的集合。Represents a collection of worksheet objects that are part of the workbook.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

属性

$all
autoFilter

对于集合中的每一项: 代表工作表的自动筛选对象。For EACH ITEM in the collection: Represents the AutoFilter object of the worksheet.

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

charts

对于集合中的每一项: 返回工作表的一部分的图表的集合。For EACH ITEM in the collection: Returns collection of charts that are part of the worksheet.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

enableCalculation

对于集合中的每一项: 获取或设置工作表的 enableCalculation 属性。For EACH ITEM in the collection: Gets or sets the enableCalculation property of the worksheet. 如此如果 Excel 根据需要重新计算工作表。True if Excel recalculates the worksheet when necessary. 如果 Excel 不重新计算工作表,则该值为 False。False if Excel doesn't recalculate the sheet.

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

id

对于集合中的每一项: 返回一个值, 该值唯一地标识给定工作簿中的工作表。For EACH ITEM in the collection: Returns a value that uniquely identifies the worksheet in a given workbook. 即使工作表被重命名或移动,标识符的值仍然相同。The value of the identifier remains the same even when the worksheet is renamed or moved. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

name

对于集合中的每一项: 工作表的显示名称。For EACH ITEM in the collection: The display name of the worksheet.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

pageLayout

对于集合中的每一项: 获取工作表的页面布局对象。For EACH ITEM in the collection: Gets the PageLayout object of the worksheet.

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

position

对于集合中的每个项目: 工作表在工作簿中的位置 (从零开始)。For EACH ITEM in the collection: The zero-based position of the worksheet within the workbook.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

protection

对于集合中的每一项: 返回工作表的工作表保护对象。For EACH ITEM in the collection: Returns sheet protection object for a worksheet.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

showGridlines

对于集合中的每一项: 获取或设置工作表的网格线标志。For EACH ITEM in the collection: Gets or sets the worksheet's gridlines flag. 此标志确定是否对用户显示网格线。This flag determines whether gridlines are visible to the user.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showHeadings

对于集合中的每一项: 获取或设置工作表的标题标志。For EACH ITEM in the collection: Gets or sets the worksheet's headings flag. 此标志确定是否对用户显示标题。This flag determines whether headings are visible to the user.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

standardHeight

对于集合中的每一项: 返回工作表中所有行的标准 (默认) 高度 (以磅为单位)。For EACH ITEM in the collection: Returns the standard (default) height of all the rows in the worksheet, in points. 只读。Read-only.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

standardWidth

对于集合中的每一项: 返回或设置工作表中所有列的标准 (默认) 宽度。For EACH ITEM in the collection: Returns or sets the standard (default) width of all the columns in the worksheet. 一个列宽单位等于“常规”样式中一个字符的宽度。One unit of column width is equal to the width of one character in the Normal style. 对于比例字体,则使用字符 0(零)的宽度。For proportional fonts, the width of the character 0 (zero) is used.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

tabColor

对于集合中的每一项: 获取或设置工作表标签颜色。For EACH ITEM in the collection: Gets or sets the worksheet tab color. 检索选项卡颜色时, 如果工作表不可见, 则值将为 null。When retrieving the tab color, if the worksheet is invisible, the value will be null. 如果工作表可见但选项卡颜色设置为自动, 将返回一个空字符串。If the worksheet is visible but the tab color is set to auto, an empty string will be returned. 否则, 在设置颜色时, 属性将设置为颜色, 格式为#"123456", 则使用空字符串设置 "自动" 颜色, 或使用实际颜色。Otherwise, the property will be set to a color, in the form "#123456" When setting the color, use an empty-string to set an "auto" color, or a real color otherwise.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

tables

对于集合中的每一项: 工作表中的表的集合。For EACH ITEM in the collection: Collection of tables that are part of the worksheet.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

visibility

对于集合中的每一项: 工作表的可见性。For EACH ITEM in the collection: The Visibility of the worksheet.

[API 集: ExcelApi 1.1 用于读取可见性; 1.2 用于设置。[ API set: ExcelApi 1.1 for reading visibility; 1.2 for setting it. ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

autoFilter

对于集合中的每一项: 代表工作表的自动筛选对象。For EACH ITEM in the collection: Represents the AutoFilter object of the worksheet.

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

autoFilter?: Excel.Interfaces.AutoFilterLoadOptions;

属性值

charts

对于集合中的每一项: 返回工作表的一部分的图表的集合。For EACH ITEM in the collection: Returns collection of charts that are part of the worksheet.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

charts?: Excel.Interfaces.ChartCollectionLoadOptions;

属性值

enableCalculation

对于集合中的每一项: 获取或设置工作表的 enableCalculation 属性。For EACH ITEM in the collection: Gets or sets the enableCalculation property of the worksheet. 如此如果 Excel 根据需要重新计算工作表。True if Excel recalculates the worksheet when necessary. 如果 Excel 不重新计算工作表,则该值为 False。False if Excel doesn't recalculate the sheet.

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

enableCalculation?: boolean;

属性值

boolean

id

对于集合中的每一项: 返回一个值, 该值唯一地标识给定工作簿中的工作表。For EACH ITEM in the collection: Returns a value that uniquely identifies the worksheet in a given workbook. 即使工作表被重命名或移动,标识符的值仍然相同。The value of the identifier remains the same even when the worksheet is renamed or moved. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

id?: boolean;

属性值

boolean

name

对于集合中的每一项: 工作表的显示名称。For EACH ITEM in the collection: The display name of the worksheet.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

name?: boolean;

属性值

boolean

pageLayout

对于集合中的每一项: 获取工作表的页面布局对象。For EACH ITEM in the collection: Gets the PageLayout object of the worksheet.

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

pageLayout?: Excel.Interfaces.PageLayoutLoadOptions;

属性值

position

对于集合中的每个项目: 工作表在工作簿中的位置 (从零开始)。For EACH ITEM in the collection: The zero-based position of the worksheet within the workbook.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

position?: boolean;

属性值

boolean

protection

对于集合中的每一项: 返回工作表的工作表保护对象。For EACH ITEM in the collection: Returns sheet protection object for a worksheet.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

protection?: Excel.Interfaces.WorksheetProtectionLoadOptions;

属性值

showGridlines

对于集合中的每一项: 获取或设置工作表的网格线标志。For EACH ITEM in the collection: Gets or sets the worksheet's gridlines flag. 此标志确定是否对用户显示网格线。This flag determines whether gridlines are visible to the user.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showGridlines?: boolean;

属性值

boolean

showHeadings

对于集合中的每一项: 获取或设置工作表的标题标志。For EACH ITEM in the collection: Gets or sets the worksheet's headings flag. 此标志确定是否对用户显示标题。This flag determines whether headings are visible to the user.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

showHeadings?: boolean;

属性值

boolean

standardHeight

对于集合中的每一项: 返回工作表中所有行的标准 (默认) 高度 (以磅为单位)。For EACH ITEM in the collection: Returns the standard (default) height of all the rows in the worksheet, in points. 只读。Read-only.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

standardHeight?: boolean;

属性值

boolean

standardWidth

对于集合中的每一项: 返回或设置工作表中所有列的标准 (默认) 宽度。For EACH ITEM in the collection: Returns or sets the standard (default) width of all the columns in the worksheet. 一个列宽单位等于“常规”样式中一个字符的宽度。One unit of column width is equal to the width of one character in the Normal style. 对于比例字体,则使用字符 0(零)的宽度。For proportional fonts, the width of the character 0 (zero) is used.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

standardWidth?: boolean;

属性值

boolean

tabColor

对于集合中的每一项: 获取或设置工作表标签颜色。For EACH ITEM in the collection: Gets or sets the worksheet tab color. 检索选项卡颜色时, 如果工作表不可见, 则值将为 null。When retrieving the tab color, if the worksheet is invisible, the value will be null. 如果工作表可见但选项卡颜色设置为自动, 将返回一个空字符串。If the worksheet is visible but the tab color is set to auto, an empty string will be returned. 否则, 在设置颜色时, 属性将设置为颜色, 格式为#"123456", 则使用空字符串设置 "自动" 颜色, 或使用实际颜色。Otherwise, the property will be set to a color, in the form "#123456" When setting the color, use an empty-string to set an "auto" color, or a real color otherwise.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

tabColor?: boolean;

属性值

boolean

tables

对于集合中的每一项: 工作表中的表的集合。For EACH ITEM in the collection: Collection of tables that are part of the worksheet.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

tables?: Excel.Interfaces.TableCollectionLoadOptions;

属性值

visibility

对于集合中的每一项: 工作表的可见性。For EACH ITEM in the collection: The Visibility of the worksheet.

[API 集: ExcelApi 1.1 用于读取可见性; 1.2 用于设置。[ API set: ExcelApi 1.1 for reading visibility; 1.2 for setting it. ]

visibility?: boolean;

属性值

boolean