excel package

Excel.Application

表示用于管理工作簿的 Excel 应用程序。Represents the Excel application that manages the workbook.

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

Excel.AutoFilter

代表自动筛选对象。Represents the AutoFilter object. "自动筛选" 将 Excel 列中的值转换为基于单元格内容的特定筛选器。AutoFilter turns the values in Excel column into specific filters based on the cell contents.

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

Excel.Binding

表示工作簿中定义的 Office.js 绑定。Represents an Office.js binding that is defined in the workbook.

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

Excel.BindingCollection

表示属于工作簿的所有绑定对象的集合。Represents the collection of all the binding objects that are part of the workbook.

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

Excel.CellValueConditionalFormat

表示单元格值条件格式。Represents a cell value conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Chart

表示工作簿中的 chart 对象。Represents a chart object in a workbook.

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

Excel.ChartAreaFormat

封装整个图表区域的格式属性。Encapsulates the format properties for the overall chart area.

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

Excel.ChartAxes

表示图表坐标轴。Represents the chart axes.

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

Excel.ChartAxis

代表图表中的单个坐标轴。Represents a single axis in a chart.

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

Excel.ChartAxisFormat

封装图表坐标轴的格式属性。Encapsulates the format properties for the chart axis.

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

Excel.ChartAxisTitle

表示图表坐标轴的标题。Represents the title of a chart axis.

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

Excel.ChartAxisTitleFormat

表示图表坐标轴标题格式。Represents the chart axis title formatting.

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

Excel.ChartBinOptions

封装直方图图表和排列图表的 bin 选项。Encapsulates the bin options for histogram charts and pareto charts.

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

Excel.ChartBorder

代表 chart 元素的边框格式。Represents the border formatting of a chart element.

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

Excel.ChartBoxwhiskerOptions

表示 "box" 和 "图" 图的属性。Represents the properties of a box and whisker chart.

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

Excel.ChartCollection

工作表中的所有 chart 对象的集合。A collection of all the chart objects on a worksheet.

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

Excel.ChartDataLabel

表示图表点的数据标签。Represents the data label of a chart point.

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

Excel.ChartDataLabelFormat

封装图表数据表的格式属性。Encapsulates the format properties for the chart data labels.

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

Excel.ChartDataLabels

表示图表点上的所有数据标签的集合。Represents a collection of all the data labels on a chart point.

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

Excel.ChartErrorBars

此对象表示图表的误差线的属性。This object represents the attributes for a chart's error bars.

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

Excel.ChartErrorBarsFormat

封装图表误差线的格式属性。Encapsulates the format properties for chart error bars.

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

Excel.ChartFill

表示图表元素的格式填充。Represents the fill formatting for a chart element.

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

Excel.ChartFont

此对象表示 chart 对象的字体属性(字体名称、字体大小、颜色等)。This object represents the font attributes (font name, font size, color, etc.) for a chart object.

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

Excel.ChartFormatString

表示与图表相关的对象中包含文本的子字符串, 如 ChartTitle 对象、ChartAxisTitle 对象等。Represents the substring in chart related objects that contains text, like ChartTitle object, ChartAxisTitle object, etc.

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

Excel.ChartGridlines

代表图表坐标轴的主要或次要网格线。Represents major or minor gridlines on a chart axis.

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

Excel.ChartGridlinesFormat

封装图表网格线的格式属性。Encapsulates the format properties for chart gridlines.

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

Excel.ChartLegend

表示图表中的图例。Represents the legend in a chart.

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

Excel.ChartLegendEntry

表示 legendEntryCollection 中的 legendEntry。Represents the legendEntry in legendEntryCollection.

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

Excel.ChartLegendEntryCollection

表示 legendEntries 的集合。Represents a collection of legendEntries.

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

Excel.ChartLegendFormat

封装图表图例的格式属性。Encapsulates the format properties of a chart legend.

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

Excel.ChartLineFormat

封装线条元素的格式设置选项。Encapsulates the formatting options for line elements.

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

Excel.ChartMapOptions

封装区域映射图的属性。Encapsulates the properties for a region map chart.

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

Excel.ChartPivotOptions

封装数据透视图的选项。Encapsulates the options for the pivot chart.

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

Excel.ChartPlotArea

此对象表示 chart plotArea 对象的属性。This object represents the attributes for a chart plotArea object.

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

Excel.ChartPlotAreaFormat

表示图表 plotArea 的格式属性。Represents the format properties for chart plotArea.

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

Excel.ChartPoint

表示图表中某个系列的点。Represents a point of a series in a chart.

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

Excel.ChartPointFormat

表示图表点的格式化对象。Represents formatting object for chart points.

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

Excel.ChartPointsCollection

图表中某个系列的所有图表点的集合。A collection of all the chart points within a series inside a chart.

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

Excel.ChartSeries

代表图表上的系列。Represents a series in a chart.

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

Excel.ChartSeriesCollection

表示图表系列的集合。Represents a collection of chart series.

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

Excel.ChartSeriesFormat

封装图表系列的格式属性Encapsulates the format properties for the chart series

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

Excel.ChartTitle

表示图表的图表标题对象。Represents a chart title object of a chart.

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

Excel.ChartTitleFormat

提供对图表标题的 Office 艺术格式的访问权限。Provides access to the office art formatting for chart title.

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

Excel.ChartTrendline

此对象表示图表趋势线对象的属性。This object represents the attributes for a chart trendline object.

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

Excel.ChartTrendlineCollection

表示图表趋势线的集合。Represents a collection of Chart Trendlines.

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

Excel.ChartTrendlineFormat

代表图表趋势线的格式属性。Represents the format properties for chart trendline.

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

Excel.ChartTrendlineLabel

此对象表示图表趋势线标签对象的属性。This object represents the attributes for a chart trendline lable object.

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

Excel.ChartTrendlineLabelFormat

封装图表趋势线标签的格式属性。Encapsulates the format properties for the chart trendline label.

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

Excel.ColorScaleConditionalFormat

表示条件格式的 IconSet 条件。Represents an IconSet criteria for conditional formatting.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Comment

表示工作簿中的单元格注释对象。Represents a cell comment object in the workbook.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.CommentCollection

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

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.CommentReply

代表工作簿中的单元格批注答复对象。Represents a cell comment reply object in the workbook.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.CommentReplyCollection

代表作为注释一部分的注释答复对象的集合。Represents a collection of comment reply objects that are part of the comment.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.ConditionalDataBarNegativeFormat

代表数据栏的负侧的条件格式 DataBar 格式。Represents a conditional format DataBar Format for the negative side of the data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalDataBarPositiveFormat

代表数据栏的正一侧的条件格式 DataBar 格式。Represents a conditional format DataBar Format for the positive side of the data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormat

一个封装条件格式的范围、格式、规则和其他属性的对象。An object encapsulating a conditional format's range, format, rule, and other properties.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatCollection

代表与区域重叠的所有条件格式的集合。Represents a collection of all the conditional formats that are overlap the range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatRule

表示适用于所有传统规则/格式配对的规则。Represents a rule, for all traditional rule/format pairings.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeBorder

代表对象的边框。Represents the border of an object.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeBorderCollection

表示构成区域边框的 border 对象。Represents the border objects that make up range border.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeFill

代表条件 range 对象的背景。Represents the background of a conditional range object.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeFont

此对象表示对象的字体属性 (字体样式、颜色等)。This object represents the font attributes (font style, color, etc.) for an object.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeFormat

将条件格式区域的字体、填充、边框和其他属性封装在一起的格式对象。A format object encapsulating the conditional formats range's font, fill, borders, and other properties.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.CustomConditionalFormat

代表自定义条件格式类型。Represents a custom conditional format type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.CustomProperty

表示自定义属性。Represents a custom property.

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

Excel.CustomPropertyCollection

包含 customProperty 对象的集合。Contains the collection of customProperty objects.

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

Excel.CustomXmlPart

表示工作簿中的自定义 XML 部件对象。Represents a custom XML part object in a workbook.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.CustomXmlPartCollection

自定义 XML 部件的集合。A collection of custom XML parts.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.CustomXmlPartScopedCollection

一个由限定的自定义 XML 部件组成的集合。A scoped collection of custom XML parts. 作用域的集合是某些操作 (例如, 按命名空间进行筛选) 的结果。A scoped collection is the result of some operation, e.g. filtering by namespace. 作用域内的集合不能进一步设定范围。A scoped collection cannot be scoped any further.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.DataBarConditionalFormat

表示 Excel 条件数据栏类型。Represents an Excel Conditional Data Bar Type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.DataConnectionCollection

表示属于工作簿或工作表的所有数据连接的集合。Represents a collection of all the Data Connections that are part of the workbook or worksheet.

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

Excel.DataPivotHierarchy

表示 Excel DataPivotHierarchy。Represents the Excel DataPivotHierarchy.

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

Excel.DataPivotHierarchyCollection

代表与数据透视表相关联的 DataPivotHierarchy 项目的集合。Represents a collection of DataPivotHierarchy items associated with the PivotTable.

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

Excel.DataValidation

表示应用于当前范围的数据验证。Represents the data validation applied to the current range.

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

Excel.DocumentProperties

代表工作簿属性。Represents workbook properties.

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

Excel.Filter

管理表格列的筛选。Manages the filtering of a table's column.

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

Excel.FilterPivotHierarchy

表示 Excel FilterPivotHierarchy。Represents the Excel FilterPivotHierarchy.

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

Excel.FilterPivotHierarchyCollection

代表与数据透视表相关联的 FilterPivotHierarchy 项目的集合。Represents a collection of FilterPivotHierarchy items associated with the PivotTable.

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

Excel.FormatProtection

表示对范围对象的格式保护。Represents the format protection of a range object.

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

Excel.FunctionResult

包含函数求值操作的结果的对象An object containing the result of a function-evaluation operation

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

Excel.Functions

一个用于评估 Excel 函数的对象。An object for evaluating Excel functions.

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

Excel.GeometricShape

代表工作表中的几何形状。Represents a geometric shape inside a worksheet. 在 Excel 中, 几何形状可以是矩形、箭头总汇、公式符号、流程图项、星形、横幅、标注或任何其他基本形状。A geometric shape can be a rectangle, block arrow, equation symbol, flowchart item, star, banner, callout, or any other basic shape in Excel.

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

Excel.GroupShapeCollection

代表形状组中的形状集合。Represents the shape collection inside a shape group.

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

Excel.HeaderFooter

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

Excel.HeaderFooterGroup

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

Excel.IconSetConditionalFormat

表示条件格式的 IconSet 条件。Represents an IconSet criteria for conditional formatting.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Image

代表工作表中的图像。Represents an image in the worksheet. 若要获取相应的 Shape 对象, 请使用 Image。 Shape。To get the corresponding Shape object, use Image.shape.

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

Excel.IterativeCalculation

表示迭代计算设置。Represents the Iterative Calculation settings.

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

Excel.Line

代表工作表中的一条线。Represents a line inside a worksheet. 若要获取相应的 Shape 对象, 请使用Line.shapeTo get the corresponding Shape object, use Line.shape.

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

Excel.NamedItem

表示单元格区域或值的定义名称。Represents a defined name for a range of cells or value. 名称可以是命名为对象的基元 (如下面的类型中所示)、range 对象或对区域的引用。Names can be primitive named objects (as seen in the type below), range object, or a reference to a range. 此对象可用于获取与名称相关的 range 对象。This object can be used to obtain range object associated with names.

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

Excel.NamedItemArrayValues

表示一个包含已命名项目的值和类型的对象。Represents an object containing values and types of a named item.

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

Excel.NamedItemCollection

属于工作簿或工作表的所有 NamedItem 对象的集合, 具体取决于它的访问方式。A collection of all the NamedItem objects that are part of the workbook or worksheet, depending on how it was reached.

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

Excel.PageBreak

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

Excel.PageBreakCollection

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

Excel.PageLayout

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

Excel.PivotField

代表 PivotHierarchy 中的单个数据透视字段。Represents a single pivot field within a PivotHierarchy.

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

Excel.PivotFieldCollection

PivotHierarchy 中的透视字段对象的集合。A collection of PivotField objects within a PivotHierarchy.

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

Excel.PivotHierarchy

代表数据透视表中的单个数据透视层次结构。Represents a single pivot hierarchy within a PivotTable.

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

Excel.PivotHierarchyCollection

表示属于工作簿或工作表的所有 PivotTable 对象的集合。Represents a collection of all the PivotTables that are part of the workbook or worksheet.

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

Excel.PivotItem

表示 Excel PivotItem。Represents the Excel PivotItem.

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

Excel.PivotItemCollection

代表与父透视字段相关的所有 PivotItem 对象的集合。Represents a collection of all the PivotItem objects related to their parent PivotField.

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

Excel.PivotLayout

表示数据透视表的可视化布局。Represents the visual layout of the PivotTable.

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

Excel.PivotTable

表示 Excel 数据透视表。Represents an Excel PivotTable.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.PivotTableCollection

表示属于工作簿或工作表的所有 PivotTable 对象的集合。Represents a collection of all the PivotTables that are part of the workbook or worksheet.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.PivotTableStyle

表示通过数据透视表区域定义样式元素的数据透视表样式。Represents a PivotTable Style, which defines style elements by PivotTable region.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.PivotTableStyleCollection

代表数据透视表样式的集合。Represents a collection of PivotTable styles.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.PresetCriteriaConditionalFormat

代表 "预置条件" 条件格式, 如 "高于平均值"、"唯一值"、"空白"、"非空"、"错误" 和 "noerror"。Represents the the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Range

区域表示一个或多个相邻的单元格,例如单元格、行、列、单元格块等。Range represents a set of one or more contiguous cells such as a cell, a row, a column, block of cells, etc.

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

Excel.RangeAreas

RangeAreas 表示同一工作表中的一个或多个矩形区域的集合。RangeAreas represents a collection of one or more rectangular ranges in the same worksheet.

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

Excel.RangeBorder

代表对象的边框。Represents the border of an object.

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

Excel.RangeBorderCollection

表示构成区域边框的 Border 对象。Represents the border objects that make up the range border.

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

Excel.RangeCollection

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

Excel.RangeFill

表示 range 对象的背景。Represents the background of a range object.

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

Excel.RangeFont

此对象表示对象的字体属性(字体名称、字体大小、颜色等)。This object represents the font attributes (font name, font size, color, etc.) for an object.

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

Excel.RangeFormat

一个格式对象,其中封装了区域的字体、填充、边框、对齐方式和其他属性。A format object encapsulating the range's font, fill, borders, alignment, and other properties.

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

Excel.RangeSort

管理对 Range 对象的排序操作。Manages sorting operations on Range objects.

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

Excel.RangeView

RangeView 表示父范围的一组可见单元格。RangeView represents a set of visible cells of the parent range.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.RangeViewCollection

表示一组 RangeView 对象。Represents a collection of RangeView objects.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.RemoveDuplicatesResult

代表区域中的 removeDuplicates 方法的结果Represents the results from the removeDuplicates method on range

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

Excel.RequestContext

RequestContext 对象可加快对 Excel 应用程序的请求。The RequestContext object facilitates requests to the Excel application. 由于 Office 加载项和 Excel 应用程序在两个不同的进程中运行, 因此请求上下文是从外接程序获取对 Excel 对象模型的访问权限所必需的。Since the Office add-in and the Excel application run in two different processes, the request context is required to get access to the Excel object model from the add-in.

Excel.RowColumnPivotHierarchy

表示 Excel RowColumnPivotHierarchy。Represents the Excel RowColumnPivotHierarchy.

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

Excel.RowColumnPivotHierarchyCollection

代表与数据透视表相关联的 RowColumnPivotHierarchy 项目的集合。Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable.

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

Excel.Runtime

表示 Excel 运行时类。Represents the Excel Runtime class.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.Session

为远程工作簿提供连接会话。Provides connection session for a remote workbook.

Excel.Setting

Setting 表示保存在文档中的设置的键值对 (每个加载项每个文件)。Setting represents a key-value pair of a setting persisted to the document (per file per add-in). 这些自定义键值对可用于存储内容或任务窗格外接程序所需的状态或生命周期信息。These custom key-value pair can be used to store state or lifecycle information needed by the content or task-pane add-in. 请注意, 设置在文档中保持不变, 因此不是存储任何敏感或受保护的信息 (如用户信息和密码) 的地方。Note that settings are persisted in the document and hence it is not a place to store any sensitive or protected information such as user information and password.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

Excel.SettingCollection

表示作为工作簿一部分的键值对设置对象的集合。Represents a collection of key-value pair setting objects that are part of the workbook. 作用域限制为每个文件和加载项 (任务窗格或内容) 组合。The scope is limited to per file and add-in (task-pane or content) combination.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

Excel.Shape

代表工作表中的一个通用 shape 对象。Represents a generic shape object in the worksheet. 一个形状可以是一个几何形状、一条线、一组形状, 等等。A shape could be a geometric shape, a line, a group of shapes, etc.

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

Excel.ShapeCollection

代表工作表中所有形状的集合。Represents a collection of all the shapes in the worksheet.

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

Excel.ShapeFill

代表 shape 对象的填充格式。Represents the fill formatting of a shape object.

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

Excel.ShapeFont

代表形状的 TextRange 对象的字体属性, 如字体名称、字体大小和颜色。Represents the font attributes, such as font name, font size, and color, for a shape's TextRange object.

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

Excel.ShapeGroup

代表工作表中的形状组。Represents a shape group inside a worksheet. 若要获取相应的 Shape 对象, 请使用ShapeGroup.shapeTo get the corresponding Shape object, use ShapeGroup.shape.

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

Excel.ShapeLineFormat

代表 shape 对象的线条格式。Represents the line formatting for the shape object. 对于图像和几何形状, 线条格式表示形状的边框。For images and geometric shapes, line formatting represents the border of the shape.

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

Excel.Slicer

表示工作簿中的切片器对象。Represents a slicer object in the workbook.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.SlicerCollection

代表工作簿或工作表上所有切片器对象的集合。Represents a collection of all the slicer objects on the workbook or a worksheet.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.SlicerItem

表示切片器中的切片器项目。Represents a slicer item in a slicer.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.SlicerItemCollection

表示切片器上所有切片器项目对象的集合。Represents a collection of all the slicer item objects on the slicer.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.SlicerStyle

表示一个切片器样式, 该样式按切片器区域定义样式元素。Represents a Slicer Style, which defines style elements by region of the slicer.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.SlicerStyleCollection

表示 SlicerStyle 对象的集合。Represents a collection of SlicerStyle objects.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Style

一个封装样式的格式和其他属性的对象。An object encapsulating a style's format and other properties.

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

Excel.StyleCollection

代表所有样式的集合。Represents a collection of all the styles.

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

Excel.Table

表示一个 Excel 表。Represents an Excel table.

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

Excel.TableCollection

表示属于工作簿或工作表(具有取决于限定到的范围)的所有表的集合。Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.

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

Excel.TableColumn

代表表格中的一列。Represents a column in a table.

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

Excel.TableColumnCollection

表示属于表的所有列的集合。Represents a collection of all the columns that are part of the table.

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

Excel.TableRow

表示表中的行。Represents a row in a table.

请注意, 与在添加新行/列之前的区域或列不同, TableRow 对象表示表行的物理位置, 而不是数据。Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. 也就是说, 如果对数据进行排序或添加新行, 则表行将继续指向为其创建该索引的索引。That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

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

Excel.TableRowCollection

表示属于表的所有行的集合。Represents a collection of all the rows that are part of the table.

请注意, 与在添加新行/列之前的区域或列不同, TableRow 对象表示表行的物理位置, 而不是数据。Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. 也就是说, 如果对数据进行排序或添加新行, 则表行将继续指向为其创建该索引的索引。That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

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

Excel.TableScopedCollection

表示已确定范围的表的集合。Represents a scoped collection of tables. 对于每个表, 其左上角都被认为是其定位点位置, 表按从上到下, 然后从左到右进行排序。For each table its top-left corner is considered its anchor location and the tables are sorted top to bottom and then left to right.

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

Excel.TableSort

管理对 Table 对象的排序操作。Manages sorting operations on Table objects.

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

Excel.TableStyle

表示一个 TableStyle, 它按表的区域定义样式元素。Represents a TableStyle, which defines the style elements by region of the Table.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.TableStyleCollection

表示 TableStyles 的集合。Represents a collection of TableStyles.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.TextConditionalFormat

代表特定的文本条件格式。Represents a specific text conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.TextFrame

代表 shape 对象的文本框架。Represents the text frame of a shape object.

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

Excel.TextRange

包含附加到形状上的文本,以及用于操作文本的属性和方法。Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text.

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

Excel.TimelineStyle

表示在时间轴中按区域定义样式元素的日程表样式。Represents a Timeline style, which defines style elements by region in the Timeline.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.TimelineStyleCollection

表示 TimelineStyles 的集合。Represents a collection of TimelineStyles.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.TopBottomConditionalFormat

表示顶部/底部条件格式。Represents a Top/Bottom conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Workbook

工作簿是顶级对象,它包含相关 workbook 对象,例如工作表、表、范围等。Workbook is the top level object which contains related workbook objects such as worksheets, tables, ranges, etc.

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

Excel.WorkbookCreated

WorkbookCreated 对象是 CreateWorkbook 创建的顶级对象。The WorkbookCreated object is the top level object created by Application.CreateWorkbook. WorkbookCreated 对象是特殊的工作簿对象。A WorkbookCreated object is a special Workbook object.

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

Excel.WorkbookProtection

表示对工作簿对象的保护。Represents the protection of a workbook object.

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

Excel.Worksheet

Excel 工作表是由单元格组成的网格。An Excel worksheet is a grid of cells. 它可以包含数据、表、图表等。It can contain data, tables, charts, etc.

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

Excel.WorksheetCollection

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

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

Excel.WorksheetFreezePanes

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

Excel.WorksheetProtection

表示对工作表对象的保护。Represents the protection of a sheet object.

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

接口

Excel.BasicDataValidation

表示基本类型数据验证条件。Represents the Basic Type data validation criteria.

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

Excel.BindingDataChangedEventArgs

提供有关引发了 DataChanged 事件的绑定的信息。Provides information about the binding that raised the DataChanged event.

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

Excel.BindingSelectionChangedEventArgs

提供有关引发了 SelectionChanged 事件的绑定的信息。Provides information about the binding that raised the SelectionChanged event.

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

Excel.CellBorder

代表由返回的单个边框的属性getCellPropertiesRepresents the properties of a single border returned by getCellProperties, getRowProperties, 和getColumnProperties或的 border 属性输入参数setCellProperties, and getColumnProperties or the border property input parameter of setCellProperties, setRowProperties, 并setColumnProperties, and setColumnProperties.

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

Excel.CellBorderCollection

表示的format.borders属性getCellPropertiesRepresents the format.borders properties of getCellProperties, getRowProperties, 和getColumnProperties或的format.borders输入参数setCellProperties, and getColumnProperties or the format.borders input parameter of setCellProperties, setRowProperties, 并setColumnProperties, and setColumnProperties.

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

Excel.CellProperties

表示 getCellProperties 的返回属性。Represents the returned properties of getCellProperties.

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

Excel.CellPropertiesBorderLoadOptions

指定要在format.borders对象上加载的属性。Specifies which properties to load on the format.borders object.

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

Excel.CellPropertiesFill

表示的format.fill属性getCellPropertiesRepresents the format.fill properties of getCellProperties, getRowProperties, 和getColumnProperties或的format.fill输入参数setCellProperties, and getColumnProperties or the format.fill input parameter of setCellProperties, setRowProperties, 并setColumnProperties, and setColumnProperties.

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

Excel.CellPropertiesFillLoadOptions

指定要在format.fill对象上加载的属性。Specifies which properties to load on the format.fill object.

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

Excel.CellPropertiesFont

表示的format.font属性getCellPropertiesRepresents the format.font properties of getCellProperties, getRowProperties, 和getColumnProperties或的format.font输入参数setCellProperties, and getColumnProperties or the format.font input parameter of setCellProperties, setRowProperties, 并setColumnProperties, and setColumnProperties.

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

Excel.CellPropertiesFontLoadOptions

指定要在format.font对象上加载的属性。Specifies which properties to load on the format.font object.

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

Excel.CellPropertiesFormat

表示 getCellProperties 的返回格式属性或 setCellProperties 的格式输入参数。Represents the returned format properties of getCellProperties or format input parameter of setCellProperties.

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

Excel.CellPropertiesFormatLoadOptions

表示要在 format 对象上加载的属性。Represents which properties to load on the format object.

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

Excel.CellPropertiesLoadOptions

表示在用作 "getCellProperties" 方法的一部分时要加载的单元格属性。Represents which cell properties to load, when used as part of a "range.getCellProperties" method.

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

Excel.CellPropertiesProtection

表示的format.protection属性getCellPropertiesRepresents the format.protection properties of getCellProperties, getRowProperties, 和getColumnProperties或的format.protection输入参数setCellProperties, and getColumnProperties or the format.protection input parameter of setCellProperties, setRowProperties, 并setColumnProperties, and setColumnProperties.

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

Excel.ChangedEventDetail

提供有关 WorksheetChangedEvent/TableChangedEvent 的详细信息Provide information about the detail of WorksheetChangedEvent/TableChangedEvent

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

Excel.ChartActivatedEventArgs

提供有关引发了激活事件的图表的信息。Provides information about the chart that raised the Activated event.

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

Excel.ChartAddedEventArgs

提供有关引发添加的事件的图表的信息。Provides information about the chart that raised the Added event.

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

Excel.ChartDeactivatedEventArgs

提供有关引发已停用事件的图表的信息。Provides information about the chart that raised the Deactivated event.

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

Excel.ChartDeletedEventArgs

提供有关引发了已删除事件的图表的信息。Provides information about the chart that raised the Deleted event.

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

Excel.ColumnProperties

表示 getColumnProperties 的返回属性。Represents the returned properties of getColumnProperties.

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

Excel.ColumnPropertiesLoadOptions

表示在用作 "getColumnProperties" 方法的一部分时要加载的列属性。Represents which column properties to load, when used as part of a "range.getColumnProperties" method.

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

Excel.ConditionalCellValueRule

表示单元格值条件格式规则。Represents a cell value conditional format rule.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalColorScaleCriteria

表示色阶的条件。Represents the criteria of the color scale.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalColorScaleCriterion

表示包含类型、值和颜色的色阶条件。Represents a Color Scale Criterion which contains a type, value, and a color.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalDataBarRule

代表数据栏的规则类型。Represents a rule-type for a Data Bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalIconCriterion

表示一个图标条件, 其中包含类型、值、运算符和可选的自定义图标 (如果不使用 iconset)。Represents an Icon Criterion which contains a type, value, an Operator, and an optional custom icon, if not using an iconset.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalPresetCriteriaRule

代表 "预置条件" 条件格式规则Represents the Preset Criteria Conditional Format Rule

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalTextComparisonRule

表示单元格值条件格式规则Represents a Cell Value Conditional Format Rule

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalTopBottomRule

表示顶部/底部条件格式的规则。Represents the rule of the top/bottom conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.CustomDataValidation

代表自定义数据验证条件。Represents the Custom data validation criteria.

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

Excel.CustomFunctionEventArgs

[API 集: customfunctions.js 1.1][ API set: CustomFunctions 1.1 ]

Excel.DataValidationErrorAlert

表示数据验证的错误警报属性。Represents the error alert properties for the data validation.

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

Excel.DataValidationPrompt

表示数据验证的用户提示属性。Represents the user prompt properties for the data validation.

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

Excel.DataValidationRule

数据有效性规则包含不同类型的数据验证。Data validation rule contains different types of data validation. 一次只能根据 DataValidationType 使用其中一种方法。You can only use one of them at a time according the Excel.DataValidationType.

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

Excel.DateTimeDataValidation

表示日期数据验证条件。Represents the Date data validation criteria.

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

Excel.FilterCriteria

表示应用于列的筛选条件。Represents the filtering criteria applied to a column.

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

Excel.FilterDatetime

表示在筛选值时如何筛选日期。Represents how to filter a date when filtering on values.

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

Excel.Icon

表示单元格图标。Represents a cell icon.

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

Excel.Interfaces.ApplicationData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "application.toJSON()".

Excel.Interfaces.ApplicationLoadOptions

表示用于管理工作簿的 Excel 应用程序。Represents the Excel application that manages the workbook.

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

Excel.Interfaces.ApplicationUpdateData

用于更新 Application 对象上的数据的接口, 可用于 "application。 set (An interface for updating data on the Application object, for use in "application.set({ ... })".

Excel.Interfaces.AutoFilterData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "autoFilter.toJSON()".

Excel.Interfaces.AutoFilterLoadOptions

代表自动筛选对象。Represents the AutoFilter object. "自动筛选" 将 Excel 列中的值转换为基于单元格内容的特定筛选器。AutoFilter turns the values in Excel column into specific filters based on the cell contents.

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

Excel.Interfaces.BindingCollectionData

描述通过调用 "bindingCollection ()" 返回的数据的接口。An interface describing the data returned by calling "bindingCollection.toJSON()".

Excel.Interfaces.BindingCollectionLoadOptions

表示属于工作簿的所有绑定对象的集合。Represents the collection of all the binding objects that are part of the workbook.

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

Excel.Interfaces.BindingCollectionUpdateData

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

Excel.Interfaces.BindingData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "binding.toJSON()".

Excel.Interfaces.BindingLoadOptions

表示工作簿中定义的 Office.js 绑定。Represents an Office.js binding that is defined in the workbook.

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

Excel.Interfaces.CellValueConditionalFormatData

描述通过调用 "cellValueConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "cellValueConditionalFormat.toJSON()".

Excel.Interfaces.CellValueConditionalFormatLoadOptions

表示单元格值条件格式。Represents a cell value conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.CellValueConditionalFormatUpdateData

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

Excel.Interfaces.ChartAreaFormatData

描述通过调用 "chartAreaFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartAreaFormat.toJSON()".

Excel.Interfaces.ChartAreaFormatLoadOptions

封装整个图表区域的格式属性。Encapsulates the format properties for the overall chart area.

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

Excel.Interfaces.ChartAreaFormatUpdateData

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

Excel.Interfaces.ChartAxesData

描述通过调用 "chartAxes ()" 返回的数据的接口。An interface describing the data returned by calling "chartAxes.toJSON()".

Excel.Interfaces.ChartAxesLoadOptions

表示图表坐标轴。Represents the chart axes.

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

Excel.Interfaces.ChartAxesUpdateData

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

Excel.Interfaces.ChartAxisData

描述通过调用 "chartAxis ()" 返回的数据的接口。An interface describing the data returned by calling "chartAxis.toJSON()".

Excel.Interfaces.ChartAxisFormatData

描述通过调用 "chartAxisFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartAxisFormat.toJSON()".

Excel.Interfaces.ChartAxisFormatLoadOptions

封装图表坐标轴的格式属性。Encapsulates the format properties for the chart axis.

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

Excel.Interfaces.ChartAxisFormatUpdateData

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

Excel.Interfaces.ChartAxisLoadOptions

代表图表中的单个坐标轴。Represents a single axis in a chart.

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

Excel.Interfaces.ChartAxisTitleData

描述通过调用 "chartAxisTitle ()" 返回的数据的接口。An interface describing the data returned by calling "chartAxisTitle.toJSON()".

Excel.Interfaces.ChartAxisTitleFormatData

描述通过调用 "chartAxisTitleFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartAxisTitleFormat.toJSON()".

Excel.Interfaces.ChartAxisTitleFormatLoadOptions

表示图表坐标轴标题格式。Represents the chart axis title formatting.

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

Excel.Interfaces.ChartAxisTitleFormatUpdateData

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

Excel.Interfaces.ChartAxisTitleLoadOptions

表示图表坐标轴的标题。Represents the title of a chart axis.

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

Excel.Interfaces.ChartAxisTitleUpdateData

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

Excel.Interfaces.ChartAxisUpdateData

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

Excel.Interfaces.ChartBinOptionsData

描述通过调用 "chartBinOptions ()" 返回的数据的接口。An interface describing the data returned by calling "chartBinOptions.toJSON()".

Excel.Interfaces.ChartBinOptionsLoadOptions

封装直方图图表和排列图表的 bin 选项。Encapsulates the bin options for histogram charts and pareto charts.

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

Excel.Interfaces.ChartBinOptionsUpdateData

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

Excel.Interfaces.ChartBorderData

描述通过调用 "chartBorder ()" 返回的数据的接口。An interface describing the data returned by calling "chartBorder.toJSON()".

Excel.Interfaces.ChartBorderLoadOptions

代表 chart 元素的边框格式。Represents the border formatting of a chart element.

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

Excel.Interfaces.ChartBorderUpdateData

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

Excel.Interfaces.ChartBoxwhiskerOptionsData

描述通过调用 "chartBoxwhiskerOptions ()" 返回的数据的接口。An interface describing the data returned by calling "chartBoxwhiskerOptions.toJSON()".

Excel.Interfaces.ChartBoxwhiskerOptionsLoadOptions

表示 "box" 和 "图" 图的属性。Represents the properties of a box and whisker chart.

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

Excel.Interfaces.ChartBoxwhiskerOptionsUpdateData

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

Excel.Interfaces.ChartCollectionData

描述通过调用 "chartCollection ()" 返回的数据的接口。An interface describing the data returned by calling "chartCollection.toJSON()".

Excel.Interfaces.ChartCollectionLoadOptions

工作表中的所有 chart 对象的集合。A collection of all the chart objects on a worksheet.

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

Excel.Interfaces.ChartCollectionUpdateData

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

Excel.Interfaces.ChartData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "chart.toJSON()".

Excel.Interfaces.ChartDataLabelData

描述通过调用 "chartDataLabel ()" 返回的数据的接口。An interface describing the data returned by calling "chartDataLabel.toJSON()".

Excel.Interfaces.ChartDataLabelFormatData

描述通过调用 "chartDataLabelFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartDataLabelFormat.toJSON()".

Excel.Interfaces.ChartDataLabelFormatLoadOptions

封装图表数据表的格式属性。Encapsulates the format properties for the chart data labels.

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

Excel.Interfaces.ChartDataLabelFormatUpdateData

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

Excel.Interfaces.ChartDataLabelLoadOptions

表示图表点的数据标签。Represents the data label of a chart point.

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

Excel.Interfaces.ChartDataLabelsData

描述通过调用 "chartDataLabels ()" 返回的数据的接口。An interface describing the data returned by calling "chartDataLabels.toJSON()".

Excel.Interfaces.ChartDataLabelsLoadOptions

表示图表点上的所有数据标签的集合。Represents a collection of all the data labels on a chart point.

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

Excel.Interfaces.ChartDataLabelsUpdateData

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

Excel.Interfaces.ChartDataLabelUpdateData

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

Excel.Interfaces.ChartErrorBarsData

描述通过调用 "chartErrorBars ()" 返回的数据的接口。An interface describing the data returned by calling "chartErrorBars.toJSON()".

Excel.Interfaces.ChartErrorBarsFormatData

描述通过调用 "chartErrorBarsFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartErrorBarsFormat.toJSON()".

Excel.Interfaces.ChartErrorBarsFormatLoadOptions

封装图表误差线的格式属性。Encapsulates the format properties for chart error bars.

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

Excel.Interfaces.ChartErrorBarsFormatUpdateData

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

Excel.Interfaces.ChartErrorBarsLoadOptions

此对象表示图表的误差线的属性。This object represents the attributes for a chart's error bars.

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

Excel.Interfaces.ChartErrorBarsUpdateData

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

Excel.Interfaces.ChartFontData

描述通过调用 "chartFont ()" 返回的数据的接口。An interface describing the data returned by calling "chartFont.toJSON()".

Excel.Interfaces.ChartFontLoadOptions

此对象表示 chart 对象的字体属性(字体名称、字体大小、颜色等)。This object represents the font attributes (font name, font size, color, etc.) for a chart object.

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

Excel.Interfaces.ChartFontUpdateData

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

Excel.Interfaces.ChartFormatStringData

描述通过调用 "chartFormatString ()" 返回的数据的接口。An interface describing the data returned by calling "chartFormatString.toJSON()".

Excel.Interfaces.ChartFormatStringLoadOptions

表示与图表相关的对象中包含文本的子字符串, 如 ChartTitle 对象、ChartAxisTitle 对象等。Represents the substring in chart related objects that contains text, like ChartTitle object, ChartAxisTitle object, etc.

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

Excel.Interfaces.ChartFormatStringUpdateData

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

Excel.Interfaces.ChartGridlinesData

描述通过调用 "chartGridlines ()" 返回的数据的接口。An interface describing the data returned by calling "chartGridlines.toJSON()".

Excel.Interfaces.ChartGridlinesFormatData

描述通过调用 "chartGridlinesFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartGridlinesFormat.toJSON()".

Excel.Interfaces.ChartGridlinesFormatLoadOptions

封装图表网格线的格式属性。Encapsulates the format properties for chart gridlines.

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

Excel.Interfaces.ChartGridlinesFormatUpdateData

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

Excel.Interfaces.ChartGridlinesLoadOptions

代表图表坐标轴的主要或次要网格线。Represents major or minor gridlines on a chart axis.

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

Excel.Interfaces.ChartGridlinesUpdateData

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

Excel.Interfaces.ChartLegendData

描述通过调用 "chartLegend ()" 返回的数据的接口。An interface describing the data returned by calling "chartLegend.toJSON()".

Excel.Interfaces.ChartLegendEntryCollectionData

描述通过调用 "chartLegendEntryCollection ()" 返回的数据的接口。An interface describing the data returned by calling "chartLegendEntryCollection.toJSON()".

Excel.Interfaces.ChartLegendEntryCollectionLoadOptions

表示 legendEntries 的集合。Represents a collection of legendEntries.

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

Excel.Interfaces.ChartLegendEntryCollectionUpdateData

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

Excel.Interfaces.ChartLegendEntryData

描述通过调用 "chartLegendEntry ()" 返回的数据的接口。An interface describing the data returned by calling "chartLegendEntry.toJSON()".

Excel.Interfaces.ChartLegendEntryLoadOptions

表示 legendEntryCollection 中的 legendEntry。Represents the legendEntry in legendEntryCollection.

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

Excel.Interfaces.ChartLegendEntryUpdateData

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

Excel.Interfaces.ChartLegendFormatData

描述通过调用 "chartLegendFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartLegendFormat.toJSON()".

Excel.Interfaces.ChartLegendFormatLoadOptions

封装图表图例的格式属性。Encapsulates the format properties of a chart legend.

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

Excel.Interfaces.ChartLegendFormatUpdateData

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

Excel.Interfaces.ChartLegendLoadOptions

表示图表中的图例。Represents the legend in a chart.

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

Excel.Interfaces.ChartLegendUpdateData

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

Excel.Interfaces.ChartLineFormatData

描述通过调用 "chartLineFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartLineFormat.toJSON()".

Excel.Interfaces.ChartLineFormatLoadOptions

封装线条元素的格式设置选项。Encapsulates the formatting options for line elements.

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

Excel.Interfaces.ChartLineFormatUpdateData

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

Excel.Interfaces.ChartLoadOptions

表示工作簿中的 chart 对象。Represents a chart object in a workbook.

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

Excel.Interfaces.ChartMapOptionsData

描述通过调用 "chartMapOptions ()" 返回的数据的接口。An interface describing the data returned by calling "chartMapOptions.toJSON()".

Excel.Interfaces.ChartMapOptionsLoadOptions

封装区域映射图的属性。Encapsulates the properties for a region map chart.

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

Excel.Interfaces.ChartMapOptionsUpdateData

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

Excel.Interfaces.ChartPivotOptionsData

描述通过调用 "chartPivotOptions ()" 返回的数据的接口。An interface describing the data returned by calling "chartPivotOptions.toJSON()".

Excel.Interfaces.ChartPivotOptionsLoadOptions

封装数据透视图的选项。Encapsulates the options for the pivot chart.

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

Excel.Interfaces.ChartPivotOptionsUpdateData

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

Excel.Interfaces.ChartPlotAreaData

描述通过调用 "chartPlotArea ()" 返回的数据的接口。An interface describing the data returned by calling "chartPlotArea.toJSON()".

Excel.Interfaces.ChartPlotAreaFormatData

描述通过调用 "chartPlotAreaFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartPlotAreaFormat.toJSON()".

Excel.Interfaces.ChartPlotAreaFormatLoadOptions

表示图表 plotArea 的格式属性。Represents the format properties for chart plotArea.

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

Excel.Interfaces.ChartPlotAreaFormatUpdateData

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

Excel.Interfaces.ChartPlotAreaLoadOptions

此对象表示 chart plotArea 对象的属性。This object represents the attributes for a chart plotArea object.

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

Excel.Interfaces.ChartPlotAreaUpdateData

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

Excel.Interfaces.ChartPointData

描述通过调用 "chartPoint ()" 返回的数据的接口。An interface describing the data returned by calling "chartPoint.toJSON()".

Excel.Interfaces.ChartPointFormatData

描述通过调用 "chartPointFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartPointFormat.toJSON()".

Excel.Interfaces.ChartPointFormatLoadOptions

表示图表点的格式化对象。Represents formatting object for chart points.

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

Excel.Interfaces.ChartPointFormatUpdateData

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

Excel.Interfaces.ChartPointLoadOptions

表示图表中某个系列的点。Represents a point of a series in a chart.

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

Excel.Interfaces.ChartPointsCollectionData

描述通过调用 "chartPointsCollection ()" 返回的数据的接口。An interface describing the data returned by calling "chartPointsCollection.toJSON()".

Excel.Interfaces.ChartPointsCollectionLoadOptions

图表中某个系列的所有图表点的集合。A collection of all the chart points within a series inside a chart.

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

Excel.Interfaces.ChartPointsCollectionUpdateData

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

Excel.Interfaces.ChartPointUpdateData

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

Excel.Interfaces.ChartSeriesCollectionData

描述通过调用 "chartSeriesCollection ()" 返回的数据的接口。An interface describing the data returned by calling "chartSeriesCollection.toJSON()".

Excel.Interfaces.ChartSeriesCollectionLoadOptions

表示图表系列的集合。Represents a collection of chart series.

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

Excel.Interfaces.ChartSeriesCollectionUpdateData

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

Excel.Interfaces.ChartSeriesData

描述通过调用 "chartSeries ()" 返回的数据的接口。An interface describing the data returned by calling "chartSeries.toJSON()".

Excel.Interfaces.ChartSeriesFormatData

描述通过调用 "chartSeriesFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartSeriesFormat.toJSON()".

Excel.Interfaces.ChartSeriesFormatLoadOptions

封装图表系列的格式属性Encapsulates the format properties for the chart series

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

Excel.Interfaces.ChartSeriesFormatUpdateData

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

Excel.Interfaces.ChartSeriesLoadOptions

代表图表上的系列。Represents a series in a chart.

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

Excel.Interfaces.ChartSeriesUpdateData

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

Excel.Interfaces.ChartTitleData

描述通过调用 "chartTitle ()" 返回的数据的接口。An interface describing the data returned by calling "chartTitle.toJSON()".

Excel.Interfaces.ChartTitleFormatData

描述通过调用 "chartTitleFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartTitleFormat.toJSON()".

Excel.Interfaces.ChartTitleFormatLoadOptions

提供对图表标题的 Office 艺术格式的访问权限。Provides access to the office art formatting for chart title.

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

Excel.Interfaces.ChartTitleFormatUpdateData

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

Excel.Interfaces.ChartTitleLoadOptions

表示图表的图表标题对象。Represents a chart title object of a chart.

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

Excel.Interfaces.ChartTitleUpdateData

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

Excel.Interfaces.ChartTrendlineCollectionData

描述通过调用 "chartTrendlineCollection ()" 返回的数据的接口。An interface describing the data returned by calling "chartTrendlineCollection.toJSON()".

Excel.Interfaces.ChartTrendlineCollectionLoadOptions

表示图表趋势线的集合。Represents a collection of Chart Trendlines.

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

Excel.Interfaces.ChartTrendlineCollectionUpdateData

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

Excel.Interfaces.ChartTrendlineData

描述通过调用 "chartTrendline ()" 返回的数据的接口。An interface describing the data returned by calling "chartTrendline.toJSON()".

Excel.Interfaces.ChartTrendlineFormatData

描述通过调用 "chartTrendlineFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartTrendlineFormat.toJSON()".

Excel.Interfaces.ChartTrendlineFormatLoadOptions

代表图表趋势线的格式属性。Represents the format properties for chart trendline.

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

Excel.Interfaces.ChartTrendlineFormatUpdateData

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

Excel.Interfaces.ChartTrendlineLabelData

描述通过调用 "chartTrendlineLabel ()" 返回的数据的接口。An interface describing the data returned by calling "chartTrendlineLabel.toJSON()".

Excel.Interfaces.ChartTrendlineLabelFormatData

描述通过调用 "chartTrendlineLabelFormat ()" 返回的数据的接口。An interface describing the data returned by calling "chartTrendlineLabelFormat.toJSON()".

Excel.Interfaces.ChartTrendlineLabelFormatLoadOptions

封装图表趋势线标签的格式属性。Encapsulates the format properties for the chart trendline label.

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

Excel.Interfaces.ChartTrendlineLabelFormatUpdateData

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

Excel.Interfaces.ChartTrendlineLabelLoadOptions

此对象表示图表趋势线标签对象的属性。This object represents the attributes for a chart trendline lable object.

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

Excel.Interfaces.ChartTrendlineLabelUpdateData

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

Excel.Interfaces.ChartTrendlineLoadOptions

此对象表示图表趋势线对象的属性。This object represents the attributes for a chart trendline object.

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

Excel.Interfaces.ChartTrendlineUpdateData

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

Excel.Interfaces.ChartUpdateData

一个用于更新 Chart 对象上的数据的接口, 可用于 "chart。 set (An interface for updating data on the Chart object, for use in "chart.set({ ... })".

Excel.Interfaces.CollectionLoadOptions

提供仅加载集合成员的一个子集的属性的方法。Provides ways to load properties of only a subset of members of a collection.

Excel.Interfaces.ColorScaleConditionalFormatData

描述通过调用 "colorScaleConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "colorScaleConditionalFormat.toJSON()".

Excel.Interfaces.ColorScaleConditionalFormatLoadOptions

表示条件格式的 IconSet 条件。Represents an IconSet criteria for conditional formatting.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ColorScaleConditionalFormatUpdateData

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

Excel.Interfaces.CommentCollectionData

描述通过调用 "commentCollection ()" 返回的数据的接口。An interface describing the data returned by calling "commentCollection.toJSON()".

Excel.Interfaces.CommentCollectionLoadOptions

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

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.CommentCollectionUpdateData

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

Excel.Interfaces.CommentData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "comment.toJSON()".

Excel.Interfaces.CommentLoadOptions

表示工作簿中的单元格注释对象。Represents a cell comment object in the workbook.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.CommentReplyCollectionData

描述通过调用 "commentReplyCollection ()" 返回的数据的接口。An interface describing the data returned by calling "commentReplyCollection.toJSON()".

Excel.Interfaces.CommentReplyCollectionLoadOptions

代表作为注释一部分的注释答复对象的集合。Represents a collection of comment reply objects that are part of the comment.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.CommentReplyCollectionUpdateData

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

Excel.Interfaces.CommentReplyData

描述通过调用 "commentReply ()" 返回的数据的接口。An interface describing the data returned by calling "commentReply.toJSON()".

Excel.Interfaces.CommentReplyLoadOptions

代表工作簿中的单元格批注答复对象。Represents a cell comment reply object in the workbook.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.CommentReplyUpdateData

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

Excel.Interfaces.CommentUpdateData

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

Excel.Interfaces.ConditionalDataBarNegativeFormatData

描述通过调用 "conditionalDataBarNegativeFormat ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalDataBarNegativeFormat.toJSON()".

Excel.Interfaces.ConditionalDataBarNegativeFormatLoadOptions

代表数据栏的负侧的条件格式 DataBar 格式。Represents a conditional format DataBar Format for the negative side of the data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalDataBarNegativeFormatUpdateData

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

Excel.Interfaces.ConditionalDataBarPositiveFormatData

描述通过调用 "conditionalDataBarPositiveFormat ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalDataBarPositiveFormat.toJSON()".

Excel.Interfaces.ConditionalDataBarPositiveFormatLoadOptions

代表数据栏的正一侧的条件格式 DataBar 格式。Represents a conditional format DataBar Format for the positive side of the data bar.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalDataBarPositiveFormatUpdateData

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

Excel.Interfaces.ConditionalFormatCollectionData

描述通过调用 "conditionalFormatCollection ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalFormatCollection.toJSON()".

Excel.Interfaces.ConditionalFormatCollectionLoadOptions

代表与区域重叠的所有条件格式的集合。Represents a collection of all the conditional formats that are overlap the range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalFormatCollectionUpdateData

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

Excel.Interfaces.ConditionalFormatData

描述通过调用 "conditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalFormat.toJSON()".

Excel.Interfaces.ConditionalFormatLoadOptions

一个封装条件格式的范围、格式、规则和其他属性的对象。An object encapsulating a conditional format's range, format, rule, and other properties.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalFormatRuleData

描述通过调用 "conditionalFormatRule ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalFormatRule.toJSON()".

Excel.Interfaces.ConditionalFormatRuleLoadOptions

表示适用于所有传统规则/格式配对的规则。Represents a rule, for all traditional rule/format pairings.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalFormatRuleUpdateData

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

Excel.Interfaces.ConditionalFormatUpdateData

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

Excel.Interfaces.ConditionalRangeBorderCollectionData

描述通过调用 "conditionalRangeBorderCollection ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalRangeBorderCollection.toJSON()".

Excel.Interfaces.ConditionalRangeBorderCollectionLoadOptions

表示构成区域边框的 border 对象。Represents the border objects that make up range border.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalRangeBorderCollectionUpdateData

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

Excel.Interfaces.ConditionalRangeBorderData

描述通过调用 "conditionalRangeBorder ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalRangeBorder.toJSON()".

Excel.Interfaces.ConditionalRangeBorderLoadOptions

代表对象的边框。Represents the border of an object.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalRangeBorderUpdateData

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

Excel.Interfaces.ConditionalRangeFillData

描述通过调用 "conditionalRangeFill ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalRangeFill.toJSON()".

Excel.Interfaces.ConditionalRangeFillLoadOptions

代表条件 range 对象的背景。Represents the background of a conditional range object.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalRangeFillUpdateData

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

Excel.Interfaces.ConditionalRangeFontData

描述通过调用 "conditionalRangeFont ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalRangeFont.toJSON()".

Excel.Interfaces.ConditionalRangeFontLoadOptions

此对象表示对象的字体属性 (字体样式、颜色等)。This object represents the font attributes (font style, color, etc.) for an object.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalRangeFontUpdateData

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

Excel.Interfaces.ConditionalRangeFormatData

描述通过调用 "conditionalRangeFormat ()" 返回的数据的接口。An interface describing the data returned by calling "conditionalRangeFormat.toJSON()".

Excel.Interfaces.ConditionalRangeFormatLoadOptions

将条件格式区域的字体、填充、边框和其他属性封装在一起的格式对象。A format object encapsulating the conditional formats range's font, fill, borders, and other properties.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.ConditionalRangeFormatUpdateData

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

Excel.Interfaces.CustomConditionalFormatData

描述通过调用 "customConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "customConditionalFormat.toJSON()".

Excel.Interfaces.CustomConditionalFormatLoadOptions

代表自定义条件格式类型。Represents a custom conditional format type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.CustomConditionalFormatUpdateData

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

Excel.Interfaces.CustomPropertyCollectionData

描述通过调用 "customPropertyCollection ()" 返回的数据的接口。An interface describing the data returned by calling "customPropertyCollection.toJSON()".

Excel.Interfaces.CustomPropertyCollectionLoadOptions

包含 customProperty 对象的集合。Contains the collection of customProperty objects.

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

Excel.Interfaces.CustomPropertyCollectionUpdateData

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

Excel.Interfaces.CustomPropertyData

描述通过调用 "customProperty ()" 返回的数据的接口。An interface describing the data returned by calling "customProperty.toJSON()".

Excel.Interfaces.CustomPropertyLoadOptions

表示自定义属性。Represents a custom property.

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

Excel.Interfaces.CustomPropertyUpdateData

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

Excel.Interfaces.CustomXmlPartCollectionData

描述通过调用 "customXmlPartCollection ()" 返回的数据的接口。An interface describing the data returned by calling "customXmlPartCollection.toJSON()".

Excel.Interfaces.CustomXmlPartCollectionLoadOptions

自定义 XML 部件的集合。A collection of custom XML parts.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.Interfaces.CustomXmlPartCollectionUpdateData

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

Excel.Interfaces.CustomXmlPartData

描述通过调用 "customXmlPart ()" 返回的数据的接口。An interface describing the data returned by calling "customXmlPart.toJSON()".

Excel.Interfaces.CustomXmlPartLoadOptions

表示工作簿中的自定义 XML 部件对象。Represents a custom XML part object in a workbook.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.Interfaces.CustomXmlPartScopedCollectionData

描述通过调用 "customXmlPartScopedCollection ()" 返回的数据的接口。An interface describing the data returned by calling "customXmlPartScopedCollection.toJSON()".

Excel.Interfaces.CustomXmlPartScopedCollectionLoadOptions

一个由限定的自定义 XML 部件组成的集合。A scoped collection of custom XML parts. 作用域的集合是某些操作 (例如, 按命名空间进行筛选) 的结果。A scoped collection is the result of some operation, e.g. filtering by namespace. 作用域内的集合不能进一步设定范围。A scoped collection cannot be scoped any further.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.Interfaces.CustomXmlPartScopedCollectionUpdateData

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

Excel.Interfaces.DataBarConditionalFormatData

描述通过调用 "dataBarConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "dataBarConditionalFormat.toJSON()".

Excel.Interfaces.DataBarConditionalFormatLoadOptions

表示 Excel 条件数据栏类型。Represents an Excel Conditional Data Bar Type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.DataBarConditionalFormatUpdateData

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

Excel.Interfaces.DataPivotHierarchyCollectionData

描述通过调用 "dataPivotHierarchyCollection ()" 返回的数据的接口。An interface describing the data returned by calling "dataPivotHierarchyCollection.toJSON()".

Excel.Interfaces.DataPivotHierarchyCollectionLoadOptions

代表与数据透视表相关联的 DataPivotHierarchy 项目的集合。Represents a collection of DataPivotHierarchy items associated with the PivotTable.

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

Excel.Interfaces.DataPivotHierarchyCollectionUpdateData

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

Excel.Interfaces.DataPivotHierarchyData

描述通过调用 "dataPivotHierarchy ()" 返回的数据的接口。An interface describing the data returned by calling "dataPivotHierarchy.toJSON()".

Excel.Interfaces.DataPivotHierarchyLoadOptions

表示 Excel DataPivotHierarchy。Represents the Excel DataPivotHierarchy.

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

Excel.Interfaces.DataPivotHierarchyUpdateData

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

Excel.Interfaces.DataValidationData

描述通过调用 "dataValidation ()" 返回的数据的接口。An interface describing the data returned by calling "dataValidation.toJSON()".

Excel.Interfaces.DataValidationLoadOptions

表示应用于当前范围的数据验证。Represents the data validation applied to the current range.

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

Excel.Interfaces.DataValidationUpdateData

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

Excel.Interfaces.DocumentPropertiesData

描述通过调用 "documentProperties ()" 返回的数据的接口。An interface describing the data returned by calling "documentProperties.toJSON()".

Excel.Interfaces.DocumentPropertiesLoadOptions

代表工作簿属性。Represents workbook properties.

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

Excel.Interfaces.DocumentPropertiesUpdateData

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

Excel.Interfaces.FilterData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "filter.toJSON()".

Excel.Interfaces.FilterLoadOptions

管理表格列的筛选。Manages the filtering of a table's column.

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

Excel.Interfaces.FilterPivotHierarchyCollectionData

描述通过调用 "filterPivotHierarchyCollection ()" 返回的数据的接口。An interface describing the data returned by calling "filterPivotHierarchyCollection.toJSON()".

Excel.Interfaces.FilterPivotHierarchyCollectionLoadOptions

代表与数据透视表相关联的 FilterPivotHierarchy 项目的集合。Represents a collection of FilterPivotHierarchy items associated with the PivotTable.

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

Excel.Interfaces.FilterPivotHierarchyCollectionUpdateData

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

Excel.Interfaces.FilterPivotHierarchyData

描述通过调用 "filterPivotHierarchy ()" 返回的数据的接口。An interface describing the data returned by calling "filterPivotHierarchy.toJSON()".

Excel.Interfaces.FilterPivotHierarchyLoadOptions

表示 Excel FilterPivotHierarchy。Represents the Excel FilterPivotHierarchy.

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

Excel.Interfaces.FilterPivotHierarchyUpdateData

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

Excel.Interfaces.FormatProtectionData

描述通过调用 "formatProtection ()" 返回的数据的接口。An interface describing the data returned by calling "formatProtection.toJSON()".

Excel.Interfaces.FormatProtectionLoadOptions

表示对范围对象的格式保护。Represents the format protection of a range object.

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

Excel.Interfaces.FormatProtectionUpdateData

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

Excel.Interfaces.FunctionResultData

描述通过调用 "functionResult ()" 返回的数据的接口。An interface describing the data returned by calling "functionResult.toJSON()".

Excel.Interfaces.FunctionResultLoadOptions

包含函数求值操作的结果的对象An object containing the result of a function-evaluation operation

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

Excel.Interfaces.GeometricShapeData

描述通过调用 "geometricShape ()" 返回的数据的接口。An interface describing the data returned by calling "geometricShape.toJSON()".

Excel.Interfaces.GeometricShapeLoadOptions

代表工作表中的几何形状。Represents a geometric shape inside a worksheet. 在 Excel 中, 几何形状可以是矩形、箭头总汇、公式符号、流程图项、星形、横幅、标注或任何其他基本形状。A geometric shape can be a rectangle, block arrow, equation symbol, flowchart item, star, banner, callout, or any other basic shape in Excel.

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

Excel.Interfaces.GroupShapeCollectionData

描述通过调用 "groupShapeCollection ()" 返回的数据的接口。An interface describing the data returned by calling "groupShapeCollection.toJSON()".

Excel.Interfaces.GroupShapeCollectionLoadOptions

代表形状组中的形状集合。Represents the shape collection inside a shape group.

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

Excel.Interfaces.GroupShapeCollectionUpdateData

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

Excel.Interfaces.HeaderFooterData

描述通过调用 "headerFooter ()" 返回的数据的接口。An interface describing the data returned by calling "headerFooter.toJSON()".

Excel.Interfaces.HeaderFooterGroupData

描述通过调用 "headerFooterGroup ()" 返回的数据的接口。An interface describing the data returned by calling "headerFooterGroup.toJSON()".

Excel.Interfaces.HeaderFooterGroupLoadOptions

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

Excel.Interfaces.HeaderFooterGroupUpdateData

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

Excel.Interfaces.HeaderFooterLoadOptions

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

Excel.Interfaces.HeaderFooterUpdateData

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

Excel.Interfaces.IconSetConditionalFormatData

描述通过调用 "iconSetConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "iconSetConditionalFormat.toJSON()".

Excel.Interfaces.IconSetConditionalFormatLoadOptions

表示条件格式的 IconSet 条件。Represents an IconSet criteria for conditional formatting.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.IconSetConditionalFormatUpdateData

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

Excel.Interfaces.ImageData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "image.toJSON()".

Excel.Interfaces.ImageLoadOptions

代表工作表中的图像。Represents an image in the worksheet. 若要获取相应的 Shape 对象, 请使用 Image。 Shape。To get the corresponding Shape object, use Image.shape.

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

Excel.Interfaces.IterativeCalculationData

描述通过调用 "iterativeCalculation ()" 返回的数据的接口。An interface describing the data returned by calling "iterativeCalculation.toJSON()".

Excel.Interfaces.IterativeCalculationLoadOptions

表示迭代计算设置。Represents the Iterative Calculation settings.

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

Excel.Interfaces.IterativeCalculationUpdateData

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

Excel.Interfaces.LineData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "line.toJSON()".

Excel.Interfaces.LineLoadOptions

代表工作表中的一条线。Represents a line inside a worksheet. 若要获取相应的 Shape 对象, 请使用Line.shapeTo get the corresponding Shape object, use Line.shape.

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

Excel.Interfaces.LineUpdateData

一个用于更新 Line 对象上的数据的接口, 可用于 "line。 set (An interface for updating data on the Line object, for use in "line.set({ ... })".

Excel.Interfaces.NamedItemArrayValuesData

描述通过调用 "namedItemArrayValues ()" 返回的数据的接口。An interface describing the data returned by calling "namedItemArrayValues.toJSON()".

Excel.Interfaces.NamedItemArrayValuesLoadOptions

表示一个包含已命名项目的值和类型的对象。Represents an object containing values and types of a named item.

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

Excel.Interfaces.NamedItemCollectionData

描述通过调用 "namedItemCollection ()" 返回的数据的接口。An interface describing the data returned by calling "namedItemCollection.toJSON()".

Excel.Interfaces.NamedItemCollectionLoadOptions

属于工作簿或工作表的所有 NamedItem 对象的集合, 具体取决于它的访问方式。A collection of all the NamedItem objects that are part of the workbook or worksheet, depending on how it was reached.

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

Excel.Interfaces.NamedItemCollectionUpdateData

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

Excel.Interfaces.NamedItemData

描述通过调用 "namedItem ()" 返回的数据的接口。An interface describing the data returned by calling "namedItem.toJSON()".

Excel.Interfaces.NamedItemLoadOptions

表示单元格区域或值的定义名称。Represents a defined name for a range of cells or value. 名称可以是命名为对象的基元 (如下面的类型中所示)、range 对象或对区域的引用。Names can be primitive named objects (as seen in the type below), range object, or a reference to a range. 此对象可用于获取与名称相关的 range 对象。This object can be used to obtain range object associated with names.

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

Excel.Interfaces.NamedItemUpdateData

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

Excel.Interfaces.PageBreakCollectionData

描述通过调用 "pageBreakCollection ()" 返回的数据的接口。An interface describing the data returned by calling "pageBreakCollection.toJSON()".

Excel.Interfaces.PageBreakCollectionLoadOptions

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

Excel.Interfaces.PageBreakCollectionUpdateData

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

Excel.Interfaces.PageBreakData

描述通过调用 "pageBreak ()" 返回的数据的接口。An interface describing the data returned by calling "pageBreak.toJSON()".

Excel.Interfaces.PageBreakLoadOptions

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

Excel.Interfaces.PageLayoutData

描述通过调用 "页面布局 ()" 返回的数据的接口。An interface describing the data returned by calling "pageLayout.toJSON()".

Excel.Interfaces.PageLayoutLoadOptions

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

Excel.Interfaces.PageLayoutUpdateData

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

Excel.Interfaces.PivotFieldCollectionData

描述通过调用 "pivotFieldCollection ()" 返回的数据的接口。An interface describing the data returned by calling "pivotFieldCollection.toJSON()".

Excel.Interfaces.PivotFieldCollectionLoadOptions

表示属于工作簿或工作表的所有 PivotTable 对象的集合。Represents a collection of all the PivotTables that are part of the workbook or worksheet.

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

Excel.Interfaces.PivotFieldCollectionUpdateData

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

Excel.Interfaces.PivotFieldData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "pivotField.toJSON()".

Excel.Interfaces.PivotFieldLoadOptions

表示 Excel 透视字段。Represents the Excel PivotField.

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

Excel.Interfaces.PivotFieldUpdateData

用于更新透视字段对象上的数据的接口, 可用于 "透视字段"。 set (An interface for updating data on the PivotField object, for use in "pivotField.set({ ... })".

Excel.Interfaces.PivotHierarchyCollectionData

描述通过调用 "pivotHierarchyCollection ()" 返回的数据的接口。An interface describing the data returned by calling "pivotHierarchyCollection.toJSON()".

Excel.Interfaces.PivotHierarchyCollectionLoadOptions

表示属于工作簿或工作表的所有 PivotTable 对象的集合。Represents a collection of all the PivotTables that are part of the workbook or worksheet.

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

Excel.Interfaces.PivotHierarchyCollectionUpdateData

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

Excel.Interfaces.PivotHierarchyData

描述通过调用 "pivotHierarchy ()" 返回的数据的接口。An interface describing the data returned by calling "pivotHierarchy.toJSON()".

Excel.Interfaces.PivotHierarchyLoadOptions

表示 Excel PivotHierarchy。Represents the Excel PivotHierarchy.

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

Excel.Interfaces.PivotHierarchyUpdateData

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

Excel.Interfaces.PivotItemCollectionData

描述通过调用 "pivotItemCollection ()" 返回的数据的接口。An interface describing the data returned by calling "pivotItemCollection.toJSON()".

Excel.Interfaces.PivotItemCollectionLoadOptions

表示与父透视字段相关的所有透视项的集合。Represents a collection of all the Pivot Items related to their parent PivotField.

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

Excel.Interfaces.PivotItemCollectionUpdateData

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

Excel.Interfaces.PivotItemData

描述通过调用 "pivotItem ()" 返回的数据的接口。An interface describing the data returned by calling "pivotItem.toJSON()".

Excel.Interfaces.PivotItemLoadOptions

表示 Excel PivotItem。Represents the Excel PivotItem.

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

Excel.Interfaces.PivotItemUpdateData

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

Excel.Interfaces.PivotLayoutData

描述通过调用 "pivotLayout ()" 返回的数据的接口。An interface describing the data returned by calling "pivotLayout.toJSON()".

Excel.Interfaces.PivotLayoutLoadOptions

表示数据透视表的可视化布局。Represents the visual layout of the PivotTable.

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

Excel.Interfaces.PivotLayoutUpdateData

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

Excel.Interfaces.PivotTableCollectionData

描述通过调用 "pivotTableCollection ()" 返回的数据的接口。An interface describing the data returned by calling "pivotTableCollection.toJSON()".

Excel.Interfaces.PivotTableCollectionLoadOptions

表示属于工作簿或工作表的所有 PivotTable 对象的集合。Represents a collection of all the PivotTables that are part of the workbook or worksheet.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.Interfaces.PivotTableCollectionUpdateData

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

Excel.Interfaces.PivotTableData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "pivotTable.toJSON()".

Excel.Interfaces.PivotTableLoadOptions

表示 Excel 数据透视表。Represents an Excel PivotTable.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.Interfaces.PivotTableStyleCollectionData

描述通过调用 "pivotTableStyleCollection ()" 返回的数据的接口。An interface describing the data returned by calling "pivotTableStyleCollection.toJSON()".

Excel.Interfaces.PivotTableStyleCollectionLoadOptions

代表数据透视表样式的集合。Represents a collection of PivotTable styles.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.PivotTableStyleCollectionUpdateData

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

Excel.Interfaces.PivotTableStyleData

描述通过调用 "pivotTableStyle ()" 返回的数据的接口。An interface describing the data returned by calling "pivotTableStyle.toJSON()".

Excel.Interfaces.PivotTableStyleLoadOptions

表示通过数据透视表区域定义样式元素的数据透视表样式。Represents a PivotTable Style, which defines style elements by PivotTable region.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.PivotTableStyleUpdateData

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

Excel.Interfaces.PivotTableUpdateData

用于更新数据透视表对象上的数据的接口, 可用于 "数据透视表"。 set (An interface for updating data on the PivotTable object, for use in "pivotTable.set({ ... })".

Excel.Interfaces.PresetCriteriaConditionalFormatData

描述通过调用 "presetCriteriaConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "presetCriteriaConditionalFormat.toJSON()".

Excel.Interfaces.PresetCriteriaConditionalFormatLoadOptions

代表 "预置条件" 条件格式, 如 "高于平均值"、"唯一值"、"空白"、"非空"、"错误" 和 "noerror"。Represents the the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.PresetCriteriaConditionalFormatUpdateData

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

Excel.Interfaces.RangeAreasData

描述通过调用 "rangeAreas ()" 返回的数据的接口。An interface describing the data returned by calling "rangeAreas.toJSON()".

Excel.Interfaces.RangeAreasLoadOptions

RangeAreas 表示同一工作表中的一个或多个矩形区域的集合。RangeAreas represents a collection of one or more rectangular ranges in the same worksheet.

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

Excel.Interfaces.RangeAreasUpdateData

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

Excel.Interfaces.RangeBorderCollectionData

描述通过调用 "rangeBorderCollection ()" 返回的数据的接口。An interface describing the data returned by calling "rangeBorderCollection.toJSON()".

Excel.Interfaces.RangeBorderCollectionLoadOptions

表示构成区域边框的 Border 对象。Represents the border objects that make up the range border.

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

Excel.Interfaces.RangeBorderCollectionUpdateData

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

Excel.Interfaces.RangeBorderData

描述通过调用 "rangeBorder ()" 返回的数据的接口。An interface describing the data returned by calling "rangeBorder.toJSON()".

Excel.Interfaces.RangeBorderLoadOptions

代表对象的边框。Represents the border of an object.

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

Excel.Interfaces.RangeBorderUpdateData

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

Excel.Interfaces.RangeCollectionData

描述通过调用 "rangeCollection ()" 返回的数据的接口。An interface describing the data returned by calling "rangeCollection.toJSON()".

Excel.Interfaces.RangeCollectionLoadOptions

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

Excel.Interfaces.RangeCollectionUpdateData

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

Excel.Interfaces.RangeData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "range.toJSON()".

Excel.Interfaces.RangeFillData

描述通过调用 "rangeFill ()" 返回的数据的接口。An interface describing the data returned by calling "rangeFill.toJSON()".

Excel.Interfaces.RangeFillLoadOptions

表示 range 对象的背景。Represents the background of a range object.

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

Excel.Interfaces.RangeFillUpdateData

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

Excel.Interfaces.RangeFontData

描述通过调用 "rangeFont ()" 返回的数据的接口。An interface describing the data returned by calling "rangeFont.toJSON()".

Excel.Interfaces.RangeFontLoadOptions

此对象表示对象的字体属性(字体名称、字体大小、颜色等)。This object represents the font attributes (font name, font size, color, etc.) for an object.

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

Excel.Interfaces.RangeFontUpdateData

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

Excel.Interfaces.RangeFormatData

描述通过调用 "rangeFormat ()" 返回的数据的接口。An interface describing the data returned by calling "rangeFormat.toJSON()".

Excel.Interfaces.RangeFormatLoadOptions

一个格式对象,其中封装了区域的字体、填充、边框、对齐方式和其他属性。A format object encapsulating the range's font, fill, borders, alignment, and other properties.

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

Excel.Interfaces.RangeFormatUpdateData

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

Excel.Interfaces.RangeLoadOptions

区域表示一个或多个相邻的单元格,例如单元格、行、列、单元格块等。Range represents a set of one or more contiguous cells such as a cell, a row, a column, block of cells, etc.

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

Excel.Interfaces.RangeUpdateData

用于更新 range 对象上的数据的接口, 可用于 "range. set (An interface for updating data on the Range object, for use in "range.set({ ... })".

Excel.Interfaces.RangeViewCollectionData

描述通过调用 "rangeViewCollection ()" 返回的数据的接口。An interface describing the data returned by calling "rangeViewCollection.toJSON()".

Excel.Interfaces.RangeViewCollectionLoadOptions

表示一组 RangeView 对象。Represents a collection of RangeView objects.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.Interfaces.RangeViewCollectionUpdateData

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

Excel.Interfaces.RangeViewData

描述通过调用 "rangeView ()" 返回的数据的接口。An interface describing the data returned by calling "rangeView.toJSON()".

Excel.Interfaces.RangeViewLoadOptions

RangeView 表示父范围的一组可见单元格。RangeView represents a set of visible cells of the parent range.

[API 集: ExcelApi 1.3][ API set: ExcelApi 1.3 ]

Excel.Interfaces.RangeViewUpdateData

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

Excel.Interfaces.RemoveDuplicatesResultData

描述通过调用 "removeDuplicatesResult ()" 返回的数据的接口。An interface describing the data returned by calling "removeDuplicatesResult.toJSON()".

Excel.Interfaces.RemoveDuplicatesResultLoadOptions

代表区域中的 removeDuplicates 方法的结果Represents the results from the removeDuplicates method on range

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

Excel.Interfaces.RowColumnPivotHierarchyCollectionData

描述通过调用 "rowColumnPivotHierarchyCollection ()" 返回的数据的接口。An interface describing the data returned by calling "rowColumnPivotHierarchyCollection.toJSON()".

Excel.Interfaces.RowColumnPivotHierarchyCollectionLoadOptions

代表与数据透视表相关联的 RowColumnPivotHierarchy 项目的集合。Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable.

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

Excel.Interfaces.RowColumnPivotHierarchyCollectionUpdateData

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

Excel.Interfaces.RowColumnPivotHierarchyData

描述通过调用 "rowColumnPivotHierarchy ()" 返回的数据的接口。An interface describing the data returned by calling "rowColumnPivotHierarchy.toJSON()".

Excel.Interfaces.RowColumnPivotHierarchyLoadOptions

表示 Excel RowColumnPivotHierarchy。Represents the Excel RowColumnPivotHierarchy.

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

Excel.Interfaces.RowColumnPivotHierarchyUpdateData

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

Excel.Interfaces.RuntimeData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "runtime.toJSON()".

Excel.Interfaces.RuntimeLoadOptions

表示 Excel 运行时类。Represents the Excel Runtime class.

[API 集: ExcelApi 1.5][ API set: ExcelApi 1.5 ]

Excel.Interfaces.RuntimeUpdateData

用于更新运行时对象上的数据的接口, 可用于 "runtime. set (An interface for updating data on the Runtime object, for use in "runtime.set({ ... })".

Excel.Interfaces.SettingCollectionData

描述通过调用 "settingCollection ()" 返回的数据的接口。An interface describing the data returned by calling "settingCollection.toJSON()".

Excel.Interfaces.SettingCollectionLoadOptions

表示作为工作簿一部分的键值对设置对象的集合。Represents a collection of key-value pair setting objects that are part of the workbook. 作用域限制为每个文件和加载项 (任务窗格或内容) 组合。The scope is limited to per file and add-in (task-pane or content) combination.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

Excel.Interfaces.SettingCollectionUpdateData

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

Excel.Interfaces.SettingData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "setting.toJSON()".

Excel.Interfaces.SettingLoadOptions

Setting 表示保存在文档中的设置的键值对 (每个加载项每个文件)。Setting represents a key-value pair of a setting persisted to the document (per file per add-in). 这些自定义键值对可用于存储内容或任务窗格外接程序所需的状态或生命周期信息。These custom key-value pair can be used to store state or lifecycle information needed by the content or task-pane add-in. 请注意, 设置在文档中保持不变, 因此不是存储任何敏感或受保护的信息 (如用户信息和密码) 的地方。Note that settings are persisted in the document and hence it is not a place to store any sensitive or protected information such as user information and password.

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

Excel.Interfaces.SettingUpdateData

一个用于更新设置对象上的数据的接口, 用于 "setting" 中使用。 set (An interface for updating data on the Setting object, for use in "setting.set({ ... })".

Excel.Interfaces.ShapeCollectionData

描述通过调用 "shapeCollection ()" 返回的数据的接口。An interface describing the data returned by calling "shapeCollection.toJSON()".

Excel.Interfaces.ShapeCollectionLoadOptions

代表工作表中所有形状的集合。Represents a collection of all the shapes in the worksheet.

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

Excel.Interfaces.ShapeCollectionUpdateData

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

Excel.Interfaces.ShapeData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "shape.toJSON()".

Excel.Interfaces.ShapeFillData

描述通过调用 "shapeFill ()" 返回的数据的接口。An interface describing the data returned by calling "shapeFill.toJSON()".

Excel.Interfaces.ShapeFillLoadOptions

代表 shape 对象的填充格式。Represents the fill formatting of a shape object.

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

Excel.Interfaces.ShapeFillUpdateData

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

Excel.Interfaces.ShapeFontData

描述通过调用 "shapeFont ()" 返回的数据的接口。An interface describing the data returned by calling "shapeFont.toJSON()".

Excel.Interfaces.ShapeFontLoadOptions

代表形状的 TextRange 对象的字体属性, 如字体名称、字体大小和颜色。Represents the font attributes, such as font name, font size, and color, for a shape's TextRange object.

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

Excel.Interfaces.ShapeFontUpdateData

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

Excel.Interfaces.ShapeGroupData

描述通过调用 "shapeGroup ()" 返回的数据的接口。An interface describing the data returned by calling "shapeGroup.toJSON()".

Excel.Interfaces.ShapeGroupLoadOptions

代表工作表中的形状组。Represents a shape group inside a worksheet. 若要获取相应的 Shape 对象, 请使用ShapeGroup.shapeTo get the corresponding Shape object, use ShapeGroup.shape.

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

Excel.Interfaces.ShapeLineFormatData

描述通过调用 "shapeLineFormat ()" 返回的数据的接口。An interface describing the data returned by calling "shapeLineFormat.toJSON()".

Excel.Interfaces.ShapeLineFormatLoadOptions

代表 shape 对象的线条格式。Represents the line formatting for the shape object. 对于图像和几何形状, 线条格式表示形状的边框。For images and geometric shapes, line formatting represents the border of the shape.

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

Excel.Interfaces.ShapeLineFormatUpdateData

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

Excel.Interfaces.ShapeLoadOptions

代表工作表中的一个通用 shape 对象。Represents a generic shape object in the worksheet. 一个形状可以是一个几何形状、一条线、一组形状, 等等。A shape could be a geometric shape, a line, a group of shapes, etc.

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

Excel.Interfaces.ShapeUpdateData

用于更新 Shape 对象上的数据的接口, 可用于 "shape。 set (An interface for updating data on the Shape object, for use in "shape.set({ ... })".

Excel.Interfaces.SlicerCollectionData

描述通过调用 "slicerCollection ()" 返回的数据的接口。An interface describing the data returned by calling "slicerCollection.toJSON()".

Excel.Interfaces.SlicerCollectionLoadOptions

代表工作簿或工作表上所有切片器对象的集合。Represents a collection of all the slicer objects on the workbook or a worksheet.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.SlicerCollectionUpdateData

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

Excel.Interfaces.SlicerData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "slicer.toJSON()".

Excel.Interfaces.SlicerItemCollectionData

描述通过调用 "slicerItemCollection ()" 返回的数据的接口。An interface describing the data returned by calling "slicerItemCollection.toJSON()".

Excel.Interfaces.SlicerItemCollectionLoadOptions

表示切片器上所有切片器项目对象的集合。Represents a collection of all the slicer item objects on the slicer.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.SlicerItemCollectionUpdateData

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

Excel.Interfaces.SlicerItemData

描述通过调用 "slicerItem ()" 返回的数据的接口。An interface describing the data returned by calling "slicerItem.toJSON()".

Excel.Interfaces.SlicerItemLoadOptions

表示切片器中的切片器项目。Represents a slicer item in a slicer.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.SlicerItemUpdateData

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

Excel.Interfaces.SlicerLoadOptions

表示工作簿中的切片器对象。Represents a slicer object in the workbook.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.SlicerStyleCollectionData

描述通过调用 "slicerStyleCollection ()" 返回的数据的接口。An interface describing the data returned by calling "slicerStyleCollection.toJSON()".

Excel.Interfaces.SlicerStyleCollectionLoadOptions

表示 SlicerStyle 对象的集合。Represents a collection of SlicerStyle objects.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.SlicerStyleCollectionUpdateData

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

Excel.Interfaces.SlicerStyleData

描述通过调用 "slicerStyle ()" 返回的数据的接口。An interface describing the data returned by calling "slicerStyle.toJSON()".

Excel.Interfaces.SlicerStyleLoadOptions

表示一个切片器样式, 该样式按切片器区域定义样式元素。Represents a Slicer Style, which defines style elements by region of the slicer.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.SlicerStyleUpdateData

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

Excel.Interfaces.SlicerUpdateData

一个用于更新切片器对象上的数据的接口, 可用于 "切片器"。 set (An interface for updating data on the Slicer object, for use in "slicer.set({ ... })".

Excel.Interfaces.StyleCollectionData

描述通过调用 "styleCollection ()" 返回的数据的接口。An interface describing the data returned by calling "styleCollection.toJSON()".

Excel.Interfaces.StyleCollectionLoadOptions

代表所有样式的集合。Represents a collection of all the styles.

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

Excel.Interfaces.StyleCollectionUpdateData

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

Excel.Interfaces.StyleData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "style.toJSON()".

Excel.Interfaces.StyleLoadOptions

一个封装样式的格式和其他属性的对象。An object encapsulating a style's format and other properties.

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

Excel.Interfaces.StyleUpdateData

用于更新样式对象上的数据的接口, 可用于 "style. set (An interface for updating data on the Style object, for use in "style.set({ ... })".

Excel.Interfaces.TableCollectionData

描述通过调用 "tableCollection ()" 返回的数据的接口。An interface describing the data returned by calling "tableCollection.toJSON()".

Excel.Interfaces.TableCollectionLoadOptions

表示属于工作簿或工作表(具有取决于限定到的范围)的所有表的集合。Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.

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

Excel.Interfaces.TableCollectionUpdateData

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

Excel.Interfaces.TableColumnCollectionData

描述通过调用 "tableColumnCollection ()" 返回的数据的接口。An interface describing the data returned by calling "tableColumnCollection.toJSON()".

Excel.Interfaces.TableColumnCollectionLoadOptions

表示属于表的所有列的集合。Represents a collection of all the columns that are part of the table.

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

Excel.Interfaces.TableColumnCollectionUpdateData

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

Excel.Interfaces.TableColumnData

描述通过调用 "tableColumn ()" 返回的数据的接口。An interface describing the data returned by calling "tableColumn.toJSON()".

Excel.Interfaces.TableColumnLoadOptions

代表表格中的一列。Represents a column in a table.

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

Excel.Interfaces.TableColumnUpdateData

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

Excel.Interfaces.TableData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "table.toJSON()".

Excel.Interfaces.TableLoadOptions

表示一个 Excel 表。Represents an Excel table.

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

Excel.Interfaces.TableRowCollectionData

描述通过调用 "tableRowCollection ()" 返回的数据的接口。An interface describing the data returned by calling "tableRowCollection.toJSON()".

Excel.Interfaces.TableRowCollectionLoadOptions

表示属于表的所有行的集合。Represents a collection of all the rows that are part of the table.

请注意, 与在添加新行/列之前的区域或列不同, TableRow 对象表示表行的物理位置, 而不是数据。Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. 也就是说, 如果对数据进行排序或添加新行, 则表行将继续指向为其创建该索引的索引。That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

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

Excel.Interfaces.TableRowCollectionUpdateData

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

Excel.Interfaces.TableRowData

描述通过调用 "tableRow ()" 返回的数据的接口。An interface describing the data returned by calling "tableRow.toJSON()".

Excel.Interfaces.TableRowLoadOptions

表示表中的行。Represents a row in a table.

请注意, 与在添加新行/列之前的区域或列不同, TableRow 对象表示表行的物理位置, 而不是数据。Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. 也就是说, 如果对数据进行排序或添加新行, 则表行将继续指向为其创建该索引的索引。That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

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

Excel.Interfaces.TableRowUpdateData

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

Excel.Interfaces.TableScopedCollectionData

描述通过调用 "tableScopedCollection ()" 返回的数据的接口。An interface describing the data returned by calling "tableScopedCollection.toJSON()".

Excel.Interfaces.TableScopedCollectionLoadOptions

表示已确定范围的表的集合。Represents a scoped collection of tables. 对于每个表, 其左上角都被认为是其定位点位置, 表按从上到下, 然后从左到右进行排序。For each table its top-left corner is considered its anchor location and the tables are sorted top to bottom and then left to right.

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

Excel.Interfaces.TableScopedCollectionUpdateData

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

Excel.Interfaces.TableSortData

描述通过调用 "tableSort ()" 返回的数据的接口。An interface describing the data returned by calling "tableSort.toJSON()".

Excel.Interfaces.TableSortLoadOptions

管理对 Table 对象的排序操作。Manages sorting operations on Table objects.

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

Excel.Interfaces.TableStyleCollectionData

描述通过调用 "tableStyleCollection ()" 返回的数据的接口。An interface describing the data returned by calling "tableStyleCollection.toJSON()".

Excel.Interfaces.TableStyleCollectionLoadOptions

表示 TableStyles 的集合。Represents a collection of TableStyles.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.TableStyleCollectionUpdateData

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

Excel.Interfaces.TableStyleData

描述通过调用 "tableStyle ()" 返回的数据的接口。An interface describing the data returned by calling "tableStyle.toJSON()".

Excel.Interfaces.TableStyleLoadOptions

表示一个 TableStyle, 它按表的区域定义样式元素。Represents a TableStyle, which defines the style elements by region of the Table.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.TableStyleUpdateData

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

Excel.Interfaces.TableUpdateData

一个用于更新 Table 对象上的数据的接口, 可用于 "table。 set (An interface for updating data on the Table object, for use in "table.set({ ... })".

Excel.Interfaces.TextConditionalFormatData

描述通过调用 "textConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "textConditionalFormat.toJSON()".

Excel.Interfaces.TextConditionalFormatLoadOptions

代表特定的文本条件格式。Represents a specific text conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.TextConditionalFormatUpdateData

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

Excel.Interfaces.TextFrameData

描述通过调用 "textFrame ()" 返回的数据的接口。An interface describing the data returned by calling "textFrame.toJSON()".

Excel.Interfaces.TextFrameLoadOptions

代表 shape 对象的文本框架。Represents the text frame of a shape object.

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

Excel.Interfaces.TextFrameUpdateData

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

Excel.Interfaces.TextRangeData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "textRange.toJSON()".

Excel.Interfaces.TextRangeLoadOptions

包含附加到形状上的文本,以及用于操作文本的属性和方法。Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text.

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

Excel.Interfaces.TextRangeUpdateData

用于更新 TextRange 对象上的数据的接口, 可用于 "textRange。 set (An interface for updating data on the TextRange object, for use in "textRange.set({ ... })".

Excel.Interfaces.TimelineStyleCollectionData

描述通过调用 "timelineStyleCollection ()" 返回的数据的接口。An interface describing the data returned by calling "timelineStyleCollection.toJSON()".

Excel.Interfaces.TimelineStyleCollectionLoadOptions

表示 TimelineStyles 的集合。Represents a collection of TimelineStyles.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.TimelineStyleCollectionUpdateData

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

Excel.Interfaces.TimelineStyleData

描述通过调用 "timelineStyle ()" 返回的数据的接口。An interface describing the data returned by calling "timelineStyle.toJSON()".

Excel.Interfaces.TimelineStyleLoadOptions

表示在时间轴中按区域定义样式元素的日程表样式。Represents a Timeline style, which defines style elements by region in the Timeline.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.Interfaces.TimelineStyleUpdateData

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

Excel.Interfaces.TopBottomConditionalFormatData

描述通过调用 "topBottomConditionalFormat ()" 返回的数据的接口。An interface describing the data returned by calling "topBottomConditionalFormat.toJSON()".

Excel.Interfaces.TopBottomConditionalFormatLoadOptions

表示顶部/底部条件格式。Represents a Top/Bottom conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.Interfaces.TopBottomConditionalFormatUpdateData

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

Excel.Interfaces.WorkbookCreatedData

描述通过调用 "workbookCreated ()" 返回的数据的接口。An interface describing the data returned by calling "workbookCreated.toJSON()".

Excel.Interfaces.WorkbookData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "workbook.toJSON()".

Excel.Interfaces.WorkbookLoadOptions

工作簿是顶级对象,它包含相关 workbook 对象,例如工作表、表、范围等。Workbook is the top level object which contains related workbook objects such as worksheets, tables, ranges, etc.

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

Excel.Interfaces.WorkbookProtectionData

描述通过调用 "workbookProtection ()" 返回的数据的接口。An interface describing the data returned by calling "workbookProtection.toJSON()".

Excel.Interfaces.WorkbookProtectionLoadOptions

表示对工作簿对象的保护。Represents the protection of a workbook object.

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

Excel.Interfaces.WorkbookUpdateData

一个用于更新工作簿对象上的数据的接口, 可用于 "工作簿。 set (An interface for updating data on the Workbook object, for use in "workbook.set({ ... })".

Excel.Interfaces.WorksheetCollectionData

描述通过调用 "worksheetCollection ()" 返回的数据的接口。An interface describing the data returned by calling "worksheetCollection.toJSON()".

Excel.Interfaces.WorksheetCollectionLoadOptions

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

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

Excel.Interfaces.WorksheetCollectionUpdateData

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

Excel.Interfaces.WorksheetData

描述通过调用 "toJSON ()" 返回的数据的接口。An interface describing the data returned by calling "worksheet.toJSON()".

Excel.Interfaces.WorksheetLoadOptions

Excel 工作表是由单元格组成的网格。An Excel worksheet is a grid of cells. 它可以包含数据、表、图表等。It can contain data, tables, charts, etc.

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

Excel.Interfaces.WorksheetProtectionData

描述通过调用 "worksheetProtection ()" 返回的数据的接口。An interface describing the data returned by calling "worksheetProtection.toJSON()".

Excel.Interfaces.WorksheetProtectionLoadOptions

表示对工作表对象的保护。Represents the protection of a sheet object.

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

Excel.Interfaces.WorksheetUpdateData

用于更新工作表对象上的数据的接口, 用于在 "工作表" 中使用。 set (An interface for updating data on the Worksheet object, for use in "worksheet.set({ ... })".

Excel.ListDataValidation

表示列表数据验证条件。Represents the List data validation criteria.

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

Excel.PageLayoutMarginOptions

代表页面布局边距中的选项。Represents the options in page layout margins.

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

Excel.PageLayoutZoomOptions

表示页面缩放属性。Represents page zoom properties.

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

Excel.RangeHyperlink

表示获取/设置超链接 (XHL) 对象所需的字符串。Represents the necessary strings to get/set a hyperlink (XHL) object.

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

Excel.RangeReference

代表表单 SheetName 的字符串引用!A1: B5, 或全局或本地命名区域。Represents a string reference of the form SheetName!A1:B5, or a global or local named range.

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

Excel.ReplaceCriteria

表示要使用的替换条件。Represents the replace criteria to be used.

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

Excel.RowProperties

表示 getRowProperties 的返回属性。Represents the returned properties of getRowProperties.

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

Excel.RowPropertiesLoadOptions

表示在用作 "getRowProperties" 方法的一部分时要加载的行属性。Represents which row properties to load, when used as part of a "range.getRowProperties" method.

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

Excel.RunOptions

表示基本类型数据验证条件。Represents the Basic Type data validation criteria.

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

Excel.SearchCriteria

表示要使用的搜索条件。Represents the search criteria to be used.

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

Excel.SelectionChangedEventArgs

提供有关引发了 SelectionChanged 事件的文档的信息。Provides information about the document that raised the SelectionChanged event.

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

Excel.SettableCellProperties

表示 setCellProperties 的输入参数。Represents the input parameter of setCellProperties.

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

Excel.SettableColumnProperties

表示 setColumnProperties 的输入参数。Represents the input parameter of setColumnProperties.

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

Excel.SettableRowProperties

表示 setRowProperties 的输入参数。Represents the input parameter of setRowProperties.

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

Excel.SettingsChangedEventArgs

提供有关引发了 SettingsChanged 事件的设置的信息。Provides information about the setting that raised the SettingsChanged event

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

Excel.ShapeActivatedEventArgs

提供有关引发了激活事件的形状的信息。Provides information about the shape that raised the Activated event.

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

Excel.ShapeDeactivatedEventArgs

提供有关引发已停用事件的形状的信息。Provides information about the shape that raised the Deactivated event.

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

Excel.ShowAsRule

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

Excel.SortField

表示排序操作中的条件。Represents a condition in a sorting operation.

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

Excel.Subtotals

数据透视字段的分类汇总。Subtotals for the Pivot Field.

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

Excel.TableAddedEventArgs

提供有关引发了 OnAdded 事件的表的信息。Provides information about the table that raised the OnAdded event.

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

Excel.TableChangedEventArgs

提供有关引发 Changed 事件的表的信息。Provides information about the table that raised the Changed event.

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

Excel.TableDeletedEventArgs

提供有关引发了 OnDeleted 事件的表的信息。Provides information about the table that raised the OnDeleted event.

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

Excel.TableFilteredEventArgs

提供有关引发了筛选器应用事件的表的信息。Provides information about the table that raised the filter applied event.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.TableSelectionChangedEventArgs

提供有关引发了 SelectionChanged 事件的表的信息。Provides information about the table that raised the SelectionChanged event.

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

Excel.WorkbookAutoSaveSettingChangedEventArgs

提供有关工作簿的 onAutoSaveSettingChanged 事件的信息。Provides information about the workbook's onAutoSaveSettingChanged event.

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

Excel.WorksheetActivatedEventArgs

提供有关引发了激活事件的工作表的信息。Provides information about the worksheet that raised the Activated event.

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

Excel.WorksheetAddedEventArgs

提供有关引发添加的事件的工作表的信息。Provides information about the worksheet that raised the Added event.

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

Excel.WorksheetCalculatedEventArgs

提供有关引发计算事件的工作表的信息。Provides information about the worksheet that raised the Calculated event.

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

Excel.WorksheetChangedEventArgs

提供有关引发 Changed 事件的工作表的信息。Provides information about the worksheet that raised the Changed event.

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

Excel.WorksheetColumnSortedEventArgs

提供有关引发了 ColumnSorted 事件的工作表的信息。Provides information about the worksheet that raised the ColumnSorted event.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.WorksheetDeactivatedEventArgs

提供有关引发已停用事件的工作表的信息。Provides information about the worksheet that raised the Deactivated event.

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

Excel.WorksheetDeletedEventArgs

提供有关引发了已删除事件的工作表的信息。Provides information about the worksheet that raised the Deleted event.

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

Excel.WorksheetFilteredEventArgs

提供有关引发了筛选器应用事件的工作表的信息。Provides information about the worksheet that raised the filter applied event.

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.WorksheetFormatChangedEventArgs

提供有关工作表格式更改事件的信息。Provides information about the worksheet format change event.

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

Excel.WorksheetProtectionOptions

代表工作表保护中的选项。Represents the options in sheet protection.

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

Excel.WorksheetRowSortedEventArgs

提供有关引发了 RowSorted 事件的工作表的信息。Provides information about the worksheet that raised the RowSorted event.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.WorksheetSearchCriteria

表示要使用的工作表搜索条件。Represents the worksheet search criteria to be used.

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

Excel.WorksheetSelectionChangedEventArgs

提供有关引发了 SelectionChanged 事件的工作表的信息。Provides information about the worksheet that raised the SelectionChanged event.

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

Excel.WorksheetSingleClickedEventArgs

提供有关引发了左键单击或点击过的事件的工作表的信息。Provides information about the worksheet that raised the left-clicked/tapped event.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

枚举

Excel.AggregationFunction

数据透视字段的聚合函数。Aggregation Function for the Data Pivot Field.

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

Excel.ArrowheadLength

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

Excel.ArrowheadStyle

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

Excel.ArrowheadWidth

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

Excel.AutoFillType

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

Excel.BindingType

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

Excel.BorderIndex

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

Excel.BorderLineStyle

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

Excel.BorderWeight

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

Excel.BuiltInStyle

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

Excel.CalculationMode

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

Excel.CalculationState

表示整个 Excel 应用程序之间的计算状态。Represents the state of calculation across the entire Excel application.

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

Excel.CalculationType

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

Excel.ChartAxisCategoryType

指定分类轴的类型。Specifies the type of the category axis.

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

Excel.ChartAxisDisplayUnit

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

Excel.ChartAxisGroup

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

Excel.ChartAxisPosition

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

Excel.ChartAxisScaleType

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

Excel.ChartAxisTickLabelPosition

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

Excel.ChartAxisTickMark

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

Excel.ChartAxisTimeUnit

指定图表轴和数据系列的时间单位。Specifies the unit of time for chart axes and data series.

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

Excel.ChartAxisType

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

Excel.ChartBinType

指定直方图图表或排列图表系列的 bin 类型。Specifies the bin's type of a histogram chart or pareto chart series.

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

Excel.ChartBoxQuartileCalculation

表示图表系列布局的四分数计算类型。Represents the quartile calculation type of chart series layout. 仅适用于 box 和形图。Only applies to a box and whisker chart.

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

Excel.ChartColorScheme

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

Excel.ChartDataLabelPosition

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

Excel.ChartDisplayBlanksAs

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

Excel.ChartErrorBarsInclude

表示要包含的误差线部分。Represents which parts of the error bar to include.

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

Excel.ChartErrorBarsType

代表误差线的范围类型。Represents the range type for error bars.

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

Excel.ChartGradientStyle

表示图表系列的渐变样式。Represents the gradient style of a chart series. 这仅适用于地区地图图表。This is only applicable for region map charts.

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

Excel.ChartGradientStyleType

表示图表系列的渐变样式类型。Represents the gradient style type of a chart series. 这仅适用于地区地图图表。This is only applicable for region map charts.

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

Excel.ChartLegendPosition

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

Excel.ChartLineStyle

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

Excel.ChartMapAreaLevel

表示图表系列的映射级别。Represents the mapping level of a chart series. 这仅适用于地区地图图表。This only applies to region map charts.

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

Excel.ChartMapLabelStrategy

表示图表系列布局的区域级别。Represents the region level of a chart series layout. 这仅适用于地区地图图表。This only applies to region map charts.

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

Excel.ChartMapProjectionType

表示图表系列布局的区域投影类型。Represents the region projection type of a chart series layout. 这仅适用于地区地图图表。This only applies to region map charts.

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

Excel.ChartMarkerStyle

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

Excel.ChartParentLabelStrategy

表示图表系列布局的父标签策略。Represents the parent label strategy of the chart series layout. 这仅适用于树状图图表This only applies to treemap charts

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

Excel.ChartPlotAreaPosition

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

Excel.ChartPlotBy

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

Excel.ChartSeriesBy

指定系列是按行还是按列。Specifies whether the series are by rows or by columns. 在桌面上,“自动”选项将检查源数据形状以自动猜测数据是按行还按列;在 Excel Online 上,“自动”仅默认为“列”。On Desktop, the "auto" option will inspect the source data shape to automatically guess whether the data is by rows or columns; on Excel Online, "auto" will simply default to "columns".

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

Excel.ChartSplitType

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

Excel.ChartTextHorizontalAlignment

表示指定对象的水平对齐方式。Represents the horizontal alignment for the specified object.

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

Excel.ChartTextVerticalAlignment

表示指定对象的垂直对齐方式。Represents the vertical alignment for the specified object.

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

Excel.ChartTickLabelAlignment

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

Excel.ChartTitlePosition

表示图表标题的位置。Represents the position of chart title.

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

Excel.ChartTrendlineType

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

Excel.ChartType

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

Excel.ChartUnderlineStyle

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

Excel.ClearApplyTo

[API 集: ExcelApi 1.1 用于所有/格式/内容, 1.7 用于超&链接 HyperlinksAndFormats。[ API set: ExcelApi 1.1 for All/Formats/Contents, 1.7 for Hyperlinks & HyperlinksAndFormats. ]

Excel.CloseBehavior

指定工作簿的关闭行为。关闭 API。Specifies the close behavior for Workbook.close API.

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

Excel.ConditionalCellValueOperator

表示文本条件格式类型的运算符。Represents the operator of the text conditional format type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalDataBarAxisFormat

代表数据条轴的格式选项。Represents the format options for a Data Bar Axis.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalDataBarDirection

表示单元格内的数据条方向。Represents the Data Bar direction within a cell.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatColorCriterionType

表示条件格式值的类型。Represents the types of conditional format values.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatDirection

代表所选内容的方向。Represents the direction for a selection.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatIconRuleType

表示条件格式值的类型。Represents the types of conditional format values.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatPresetCriterion

代表预置条件条件格式类型的条件。Represents the criteria for the Preset Criteria conditional format type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatRuleType

表示条件格式值的类型。Represents the types of conditional format values.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalFormatType

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalIconCriterionOperator

表示每个图标条件对应的运算符。Represents the operator for each icon criteria.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeBorderIndex

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeBorderLineStyle

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalRangeFontUnderlineStyle

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalTextOperator

表示文本条件格式类型的运算符。Represents the operator of the text conditional format type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConditionalTopBottomCriterionType

代表上述/低于平均条件格式类型的条件。Represents the criteria for the above/below average conditional format type.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

Excel.ConnectorType

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

Excel.ContentType

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.CustomFunctionMetadataFormat

[API 集: customfunctions.js 1.1][ API set: CustomFunctions 1.1 ]

Excel.CustomFunctionType

[API 集: customfunctions.js 1.1][ API set: CustomFunctions 1.1 ]

Excel.DataChangeType

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

Excel.DataValidationAlertStyle

表示数据有效性错误警告样式。Represents Data validation error alert style. 默认值为 "停止"。The default is "Stop".

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

Excel.DataValidationOperator

表示数据验证运算符枚举。Represents Data validation operator enum.

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

Excel.DataValidationType

表示数据验证类型枚举。Represents Data validation type enum.

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

Excel.DeleteShiftDirection

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

Excel.DocumentPropertyItem

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

Excel.DocumentPropertyType

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

Excel.DynamicFilterCriteria

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

Excel.EventSource

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

Excel.EventType

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

Excel.FillPattern

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

Excel.FilterDatetimeSpecificity

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

Excel.FilterOn

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

Excel.FilterOperator

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

Excel.GeometricShapeType

指定 GeometricShape 对象的形状类型。Specifies the shape type for a GeometricShape object.

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

Excel.HeaderFooterState

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

Excel.HorizontalAlignment

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

Excel.IconSet

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

Excel.ImageFittingMode

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

Excel.InsertShiftDirection

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

Excel.LinkedDataTypeState

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

Excel.NamedItemScope

[API 集: ExcelApi 1.4][ API set: ExcelApi 1.4 ]

Excel.NamedItemType

[API 集: 字符串、整型、双精度、布尔值、范围、错误的 ExcelApi 1.1、数组的 1.7][ API set: ExcelApi 1.1 for String,Integer,Double,Boolean,Range,Error; 1.7 for Array ]

Excel.PageOrientation

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

Excel.PaperType

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

Excel.PictureFormat

图像的格式。The format of the image.

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

Excel.PivotAxis

数据透视字段的 ShowAs 计算函数。The ShowAs Calculation function for the Data Pivot Field.

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

Excel.PivotFilterTopBottomCriterion

代表 top/下限值筛选器的条件。Represents the criteria for the top/bottom values filter.

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

Excel.PivotLayoutType

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

Excel.Placement

指定对象附加到其下层单元格的方式。Specifies the way that an object is attached to its underlying cells.

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

Excel.PrintComments

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

Excel.PrintErrorType

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

Excel.PrintMarginUnit

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

Excel.PrintOrder

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

Excel.ProtectionSelectionMode

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

Excel.RangeCopyType

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

Excel.RangeUnderlineStyle

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

Excel.RangeValueType

[API 集: ExcelApi 1.1 for Unknown, Empty, String, Integer, Double, Boolean, Error。 1.7 for RichValue][ API set: ExcelApi 1.1 for Unknown, Empty, String, Integer, Double, Boolean, Error. 1.7 for RichValue ]

Excel.ReadingOrder

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

Excel.RibbonTab

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

Excel.SaveBehavior

指定工作簿的保存行为。保存 API。Specifies the save behavior for Workbook.save API.

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

Excel.SearchDirection

指定搜索方向。Specifies the search direction.

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

Excel.ShapeAutoSize

确定允许的自动调整大小的类型。Determines the type of automatic sizing allowed.

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

Excel.ShapeFillType

指定形状的填充类型。Specifies a shape's fill type.

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

Excel.ShapeFontUnderlineStyle

应用于字体的下划线的类型。The type of underline applied to a font.

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

Excel.ShapeLineDashStyle

线条的虚线样式。The dash style for a line.

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

Excel.ShapeLineStyle

线条的样式。The style for a line.

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

Excel.ShapeScaleFrom

指定在缩放形状时,该形状的哪一部分将保持在原有的位置。Specifies which part of the shape retains its position when the shape is scaled.

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

Excel.ShapeScaleType

指定是相对于形状的原始尺寸还是当前尺寸来对其进行缩放。Specifies whether the shape is scaled relative to its original or current size.

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

Excel.ShapeTextHorizontalAlignment

指定形状中的文本框架的水平对齐方式。Specifies the horizontal alignment for the text frame in a shape.

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

Excel.ShapeTextHorizontalOverflow

指定形状中的文本框架的水平溢出。Specifies the horizontal overflow for the text frame in a shape.

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

Excel.ShapeTextOrientation

指定形状中的文本框架的方向。Specifies the orientation for the text frame in a shape.

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

Excel.ShapeTextReadingOrder

指定形状中的文本框架的阅读顺序。Specifies the reading order for the text frame in a shape.

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

Excel.ShapeTextVerticalAlignment

指定形状中的文本框架的垂直对齐方式。Specifies the vertical alignment for the text frame in a shape.

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

Excel.ShapeTextVerticalOverflow

指定形状中的文本框架的垂直溢出。Specifies the vertical overflow for the text frame in a shape.

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

Excel.ShapeType

指定形状的类型。Specifies the type of a shape.

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

Excel.ShapeZOrder

指定要将形状移动到的相对于其他形状的 z-顺序位置。Specifies where in the z-order a shape should be moved relative to other shapes.

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

Excel.SheetVisibility

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

Excel.ShowAsCalculation

数据透视字段的 ShowAs 计算函数。The ShowAs Calculation function for the Data Pivot Field.

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

Excel.SlicerSortType

[API 集: ExcelApi BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

Excel.SortBy

表示排序方向。Represents the sort direction.

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

Excel.SortDataOption

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

Excel.SortMethod

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

Excel.SortOn

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

Excel.SortOrientation

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

Excel.SpecialCellType

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

Excel.SpecialCellValueType

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

Excel.SubtotalLocationType

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

Excel.VerticalAlignment

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

Excel.WorksheetPositionType

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

函数

Excel.createWorkbook

创建并打开新工作簿。Creates and opens a new workbook. (可选)工作簿可以预先填充 base64 编码的 .xlsx 文件。Optionally, the workbook can be pre-populated with a base64-encoded .xlsx file.

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

Excel.getDataCommonPostprocess
Excel.postprocessBindingDescriptor
Excel.run

使用新的 RequestContext 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using a new RequestContext. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

Excel.run_1

使用以前创建的 API 对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created API object. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

Excel.run_2

使用以前创建的 API 对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of previously-created API objects.

Excel.run_3

使用以前创建的 API 对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created API object. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

Excel.run_4

使用以前创建的对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created object. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

函数详细信息

Excel.createWorkbook

创建并打开新工作簿。Creates and opens a new workbook. (可选)工作簿可以预先填充 base64 编码的 .xlsx 文件。Optionally, the workbook can be pre-populated with a base64-encoded .xlsx file.

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

export function createWorkbook(base64?: string): Promise<void>;

参数

base64
string

返回

Promise<void>

示例Examples

var myFile = document.getElementById("file");
var reader = new FileReader();

reader.onload = function (event) {
    // strip off the metadata before the base64-encoded string
    var startIndex = event.target.result.indexOf("base64,");
    var copyBase64 = event.target.result.substr(startIndex + 7);

    Excel.createWorkbook(copyBase64);        
};

// read in the file as a data URL so we can parse the base64-encoded string
reader.readAsDataURL(myFile.files[0]);

Excel.getDataCommonPostprocess

export function getDataCommonPostprocess(response: any, callArgs: any): any;

参数

response
any
callArgs
any

返回

any

Excel.postprocessBindingDescriptor

export function postprocessBindingDescriptor(response: any): any;

参数

response
any

返回

any

Excel.run

使用新的 RequestContext 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using a new RequestContext. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

export function run<T>(batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

参数

batch
(context: Excel.RequestContext) => Promise<T>

一个采用 RequestContext 的函数, 并返回一个承诺 (通常只是 "context。 sync ()" 的结果)。A function that takes in a RequestContext and returns a promise (typically, just the result of "context.sync()"). Context 参数可促进对 Excel 应用程序的请求。The context parameter facilitates requests to the Excel application. 由于 Office 加载项和 Excel 应用程序在两个不同的进程中运行, 因此需要 RequestContext 以从外接程序获取对 Excel 对象模型的访问权限。Since the Office add-in and the Excel application run in two different processes, the RequestContext is required to get access to the Excel object model from the add-in.

返回

Promise<T>

Excel.run_1

使用以前创建的 API 对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created API object. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

export function run<T>(object: OfficeExtension.ClientObject, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

参数

object
OfficeExtension.ClientObject

以前创建的 API 对象。A previously-created API object. 批处理将使用与传入的对象相同的 RequestContext, 这意味着应用于该对象的任何更改都将由 "context" () 来选取。The batch will use the same RequestContext as the passed-in object, which means that any changes applied to the object will be picked up by "context.sync()".

batch
(context: Excel.RequestContext) => Promise<T>

一个采用 RequestContext 的函数, 并返回一个承诺 (通常只是 "context。 sync ()" 的结果)。A function that takes in a RequestContext and returns a promise (typically, just the result of "context.sync()"). Context 参数可促进对 Excel 应用程序的请求。The context parameter facilitates requests to the Excel application. 由于 Office 加载项和 Excel 应用程序在两个不同的进程中运行, 因此需要 RequestContext 以从外接程序获取对 Excel 对象模型的访问权限。Since the Office add-in and the Excel application run in two different processes, the RequestContext is required to get access to the Excel object model from the add-in.

返回

Promise<T>

Excel.run_2

使用以前创建的 API 对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of previously-created API objects.

export function run<T>(objects: OfficeExtension.ClientObject[], batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

参数

objects
OfficeExtension.ClientObject[]

以前创建的 API 对象的数组。An array of previously-created API objects. 将验证该数组, 以确保所有对象都共享相同的上下文。The array will be validated to make sure that all of the objects share the same context. 批处理将使用此共享 RequestContext, 这意味着应用于这些对象的任何更改都将由 "context。 sync ()" 选取。The batch will use this shared RequestContext, which means that any changes applied to these objects will be picked up by "context.sync()".

batch
(context: Excel.RequestContext) => Promise<T>

一个采用 RequestContext 的函数, 并返回一个承诺 (通常只是 "context。 sync ()" 的结果)。A function that takes in a RequestContext and returns a promise (typically, just the result of "context.sync()"). Context 参数可促进对 Excel 应用程序的请求。The context parameter facilitates requests to the Excel application. 由于 Office 加载项和 Excel 应用程序在两个不同的进程中运行, 因此需要 RequestContext 以从外接程序获取对 Excel 对象模型的访问权限。Since the Office add-in and the Excel application run in two different processes, the RequestContext is required to get access to the Excel object model from the add-in.

返回

Promise<T>

Excel.run_3

使用以前创建的 API 对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created API object. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

export function run<T>(options: Excel.RunOptions, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

参数

options
Excel.RunOptions

此 Excel 的其他选项。运行, 它指定以前的对象, 是否延迟单元格编辑、会话信息等的请求。The additional options for this Excel.run which specify previous objects, whether to delay the request for cell edit, session info, etc.

batch
(context: Excel.RequestContext) => Promise<T>

一个采用 RequestContext 的函数, 并返回一个承诺 (通常只是 "context。 sync ()" 的结果)。A function that takes in a RequestContext and returns a promise (typically, just the result of "context.sync()"). Context 参数可促进对 Excel 应用程序的请求。The context parameter facilitates requests to the Excel application. 由于 Office 加载项和 Excel 应用程序在两个不同的进程中运行, 因此需要 RequestContext 以从外接程序获取对 Excel 对象模型的访问权限。Since the Office add-in and the Excel application run in two different processes, the RequestContext is required to get access to the Excel object model from the add-in.

返回

Promise<T>

Excel.run_4

使用以前创建的对象的 RequestContext, 执行对 Excel 对象模型执行操作的批处理脚本。Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created object. 解决承诺时, 将释放在执行期间自动分配的任何已跟踪对象。When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

export function run<T>(context: OfficeExtension.ClientRequestContext, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

参数

context
OfficeExtension.ClientRequestContext

以前创建的对象。A previously-created object. 批处理将使用与传入的对象相同的 RequestContext, 这意味着应用于该对象的任何更改都将由 "context" () 来选取。The batch will use the same RequestContext as the passed-in object, which means that any changes applied to the object will be picked up by "context.sync()".

batch
(context: Excel.RequestContext) => Promise<T>

一个采用 RequestContext 的函数, 并返回一个承诺 (通常只是 "context。 sync ()" 的结果)。A function that takes in a RequestContext and returns a promise (typically, just the result of "context.sync()"). Context 参数可促进对 Excel 应用程序的请求。The context parameter facilitates requests to the Excel application. 由于 Office 加载项和 Excel 应用程序在两个不同的进程中运行, 因此需要 RequestContext 以从外接程序获取对 Excel 对象模型的访问权限。Since the Office add-in and the Excel application run in two different processes, the RequestContext is required to get access to the Excel object model from the add-in.

返回

Promise<T>

注解

除了此签名之外, 该方法还具有以下签名:In addition to this signature, the method also has the following signatures:

run<T>(object: OfficeExtension.ClientObject, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

run<T>(objects: OfficeExtension.ClientObject[], batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

run<T>(options: Excel.RunOptions, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

run<T>(batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;