Excel.Interfaces.WorkbookLoadOptions interface

工作簿是顶级对象,它包含相关 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 ]

属性

$all
application

表示包含此工作簿的 Excel 应用程序实例。Represents the Excel application instance that contains this workbook.

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

autoSave

指定工作簿是否处于自动保存模式。Specifies whether or not the workbook is in autosave mode. 只读。Read-Only.

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

bindings

表示属于工作簿的绑定的集合。Represents a collection of bindings that are part of the workbook.

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

calculationEngineVersion

返回有关 Excel 计算引擎的版本号。Returns a number about the version of Excel Calculation Engine. 只读。Read-Only.

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

chartDataPointTrack

如果工作簿中的所有图表都跟踪它们所附加的实际数据点,则为 True。True if all charts in the workbook are tracking the actual data points to which they are attached. 假如果图表跟踪数据点的索引。False if the charts track the index of the data points.

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

isDirty

指定自上次保存以来是否对指定的工作簿进行任何更改。Specifies whether or not changes have been made since the workbook was last saved. 如果要关闭修改过的工作簿而不保存或提示保存它, 则可以将该属性设置为 true。You can set this property to true if you want to close a modified workbook without either saving it or being prompted to save it.

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

name

获取工作簿名称。Gets the workbook name. 只读。Read-only.

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

previouslySaved

指定工作簿是否已在本地或在线保存。Specifies whether or not the workbook has ever been saved locally or online. 只读。Read-Only.

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

properties

获取工作簿属性。Gets the workbook properties.

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

protection

返回工作簿的工作簿保护对象。Returns workbook protection object for a workbook.

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

readOnly

如果在只读模式下打开工作簿,则为 True。True if the workbook is open in Read-only mode. 只读。Read-only.

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

tables

表示与工作簿关联的表的集合。Represents a collection of tables associated with the workbook.

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

use1904DateSystem

如果工作簿使用 1904 日期系统,则为 True。True if the workbook uses the 1904 date system.

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

usePrecisionAsDisplayed

如果此工作簿中的计算仅使用显示的数字精度来完成,则为 True。True if calculations in this workbook will be done using only the precision of the numbers as they're displayed. 将此属性从 false 切换到 true 时, 数据将永久丢失精度。Data will permanently lose accuracy when switching this property from false to true.

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

属性详细信息

$all

$all?: boolean;

属性值

boolean

application

表示包含此工作簿的 Excel 应用程序实例。Represents the Excel application instance that contains this workbook.

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

application?: Excel.Interfaces.ApplicationLoadOptions;

属性值

autoSave

指定工作簿是否处于自动保存模式。Specifies whether or not the workbook is in autosave mode. 只读。Read-Only.

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

autoSave?: boolean;

属性值

boolean

bindings

表示属于工作簿的绑定的集合。Represents a collection of bindings that are part of the workbook.

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

bindings?: Excel.Interfaces.BindingCollectionLoadOptions;

属性值

calculationEngineVersion

返回有关 Excel 计算引擎的版本号。Returns a number about the version of Excel Calculation Engine. 只读。Read-Only.

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

calculationEngineVersion?: boolean;

属性值

boolean

chartDataPointTrack

如果工作簿中的所有图表都跟踪它们所附加的实际数据点,则为 True。True if all charts in the workbook are tracking the actual data points to which they are attached. 假如果图表跟踪数据点的索引。False if the charts track the index of the data points.

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

chartDataPointTrack?: boolean;

属性值

boolean

isDirty

指定自上次保存以来是否对指定的工作簿进行任何更改。Specifies whether or not changes have been made since the workbook was last saved. 如果要关闭修改过的工作簿而不保存或提示保存它, 则可以将该属性设置为 true。You can set this property to true if you want to close a modified workbook without either saving it or being prompted to save it.

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

isDirty?: boolean;

属性值

boolean

name

获取工作簿名称。Gets the workbook name. 只读。Read-only.

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

name?: boolean;

属性值

boolean

previouslySaved

指定工作簿是否已在本地或在线保存。Specifies whether or not the workbook has ever been saved locally or online. 只读。Read-Only.

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

previouslySaved?: boolean;

属性值

boolean

properties

获取工作簿属性。Gets the workbook properties.

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

properties?: Excel.Interfaces.DocumentPropertiesLoadOptions;

属性值

protection

返回工作簿的工作簿保护对象。Returns workbook protection object for a workbook.

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

protection?: Excel.Interfaces.WorkbookProtectionLoadOptions;

属性值

readOnly

如果在只读模式下打开工作簿,则为 True。True if the workbook is open in Read-only mode. 只读。Read-only.

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

readOnly?: boolean;

属性值

boolean

tables

表示与工作簿关联的表的集合。Represents a collection of tables associated with the workbook.

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

tables?: Excel.Interfaces.TableCollectionLoadOptions;

属性值

use1904DateSystem

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

如果工作簿使用 1904 日期系统,则为 True。True if the workbook uses the 1904 date system.

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

use1904DateSystem?: boolean;

属性值

boolean

usePrecisionAsDisplayed

如果此工作簿中的计算仅使用显示的数字精度来完成,则为 True。True if calculations in this workbook will be done using only the precision of the numbers as they're displayed. 将此属性从 false 切换到 true 时, 数据将永久丢失精度。Data will permanently lose accuracy when switching this property from false to true.

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

usePrecisionAsDisplayed?: boolean;

属性值

boolean