OfficeExtension.UpdateOptions interface
提供用于设置多个属性的对象尝试设置只读属性时禁止显示错误的选项。
注解
使用方
- Excel.AllowEditRange: set
- Excel.Application: set
- Excel.CellValueConditionalFormat: set
- Excel.Chart: set
- Excel.ChartAreaFormat: set
- Excel.ChartAxes: set
- Excel.ChartAxis: set
- Excel.ChartAxisFormat: set
- Excel.ChartAxisTitle: set
- Excel.ChartAxisTitleFormat: set
- Excel.ChartBinOptions: set
- Excel.ChartBorder: set
- Excel.ChartBoxwhiskerOptions: set
- Excel.ChartDataLabel: set
- Excel.ChartDataLabelAnchor: set
- Excel.ChartDataLabelFormat: set
- Excel.ChartDataLabels: set
- Excel.ChartDataTable: set
- Excel.ChartDataTableFormat: set
- Excel.ChartErrorBars: set
- Excel.ChartErrorBarsFormat: set
- Excel.ChartFont: set
- Excel.ChartFormatString: set
- Excel.ChartGridlines: set
- Excel.ChartGridlinesFormat: set
- Excel.ChartLeaderLines: set
- Excel.ChartLeaderLinesFormat: set
- Excel.ChartLegend: set
- Excel.ChartLegendEntry: set
- Excel.ChartLegendFormat: set
- Excel.ChartLineFormat: set
- Excel.ChartMapOptions: set
- Excel.ChartPivotOptions: set
- Excel.ChartPlotArea: set
- Excel.ChartPlotAreaFormat: set
- Excel.ChartPoint: set
- Excel.ChartPointFormat: set
- Excel.ChartSeries: set
- Excel.ChartSeriesFormat: set
- Excel.ChartTitle: set
- Excel.ChartTitleFormat: set
- Excel.ChartTrendline: set
- Excel.ChartTrendlineFormat: set
- Excel.ChartTrendlineLabel: set
- Excel.ChartTrendlineLabelFormat: set
- Excel.ColorScaleConditionalFormat: set
- Excel.Comment: set
- Excel.CommentReply: set
- Excel.ConditionalDataBarNegativeFormat: set
- Excel.ConditionalDataBarPositiveFormat: set
- Excel.ConditionalFormat: set
- Excel.ConditionalFormatRule: set
- Excel.ConditionalRangeBorder: set
- Excel.ConditionalRangeFill: set
- Excel.ConditionalRangeFont: set
- Excel.ConditionalRangeFormat: set
- Excel.CustomConditionalFormat: set
- Excel.CustomProperty: set
- Excel.DataBarConditionalFormat: set
- Excel.DataPivotHierarchy: set
- Excel.DataValidation: set
- Excel.DocumentProperties: set
- Excel.FilterPivotHierarchy: set
- Excel.FormatProtection: set
- Excel.HeaderFooter: set
- Excel.HeaderFooterGroup: set
- Excel.HeaderFooterPicture: set
- Excel.IconSetConditionalFormat: set
- Excel.Image: set
- Excel.IterativeCalculation: set
- Excel.Line: set
- Excel.NamedItem: set
- Excel.Note: set
- Excel.PageLayout: set
- Excel.PivotField: set
- Excel.PivotHierarchy: set
- Excel.PivotItem: set
- Excel.PivotLayout: set
- Excel.PivotTable: set
- Excel.PivotTableStyle: set
- Excel.PresetCriteriaConditionalFormat: set
- Excel.Range: set
- Excel.RangeAreas: set
- Excel.RangeBorder: set
- Excel.RangeFill: set
- Excel.RangeFont: set
- Excel.RangeFormat: set
- Excel.RangeView: set
- Excel.RowColumnPivotHierarchy: set
- Excel.Runtime: set
- Excel.Setting: set
- Excel.Shape: set
- Excel.ShapeFill: set
- Excel.ShapeFont: set
- Excel.ShapeLineFormat: set
- Excel.Slicer: set
- Excel.SlicerItem: set
- Excel.SlicerStyle: set
- Excel.Style: set
- Excel.Table: set
- Excel.TableColumn: set
- Excel.TableRow: set
- Excel.TableStyle: set
- Excel.TextConditionalFormat: set
- Excel.TextFrame: set
- Excel.TextRange: set
- Excel.TimelineStyle: set
- Excel.TopBottomConditionalFormat: set
- Excel.Window: set
- Excel.Workbook: set
- Excel.Worksheet: set
- Excel.WorksheetCustomProperty: set
- OneNote.Application: set
- OneNote.Image: set
- OneNote.InkAnalysis: set
- OneNote.InkAnalysisLine: set
- OneNote.InkAnalysisParagraph: set
- OneNote.InkAnalysisWord: set
- OneNote.Page: set
- OneNote.PageContent: set
- OneNote.Paragraph: set
- OneNote.Table: set
- OneNote.TableCell: set
- Visio.Application: set
- Visio.Comment: set
- Visio.Document: set
- Visio.DocumentView: set
- Visio.Page: set
- Visio.PageView: set
- Visio.Shape: set
- Visio.ShapeView: set
- Word。应用程序:set
- Word。书目:set
- Word。正文:set
- Word。书签:设置
- Word。边框:设置
- Word。BorderUniversal:set
- Word。中断:设置
- Word。BuildingBlock:set
- Word。BuildingBlockGalleryContentControl:set
- Word。Canvas:set
- Word。CheckboxContentControl: set
- Word。共同创作Lock:set
- Word。共同创作Update:set
- Word。ColorFormat:set
- Word。注释:设置
- Word。CommentContentRange: set
- Word。CommentReply:set
- Word。冲突:设置
- Word。ContentControl:set
- Word。ContentControlListItem:set
- Word。CustomProperty:set
- Word。CustomXmlNode:set
- Word。CustomXmlPart:set
- Word。CustomXmlValidationError:set
- Word。DatePickerContentControl: set
- Word。文档:set
- Word。DocumentCreated: set
- Word。DocumentProperties:set
- Word。编辑器:set
- Word。字段:set
- Word。FillFormat:set
- Word。字体:set
- Word。帧:set
- Word。GlowFormat:set
- Word。GroupContentControl:set
- Word。HeadingStyle:set
- Word。超链接:设置
- Word。索引:set
- Word。InlinePicture:set
- Word。LineFormat:set
- Word。LineNumbering: set
- Word。LinkFormat:set
- Word。ListFormat:set
- Word。ListItem:set
- Word。ListLevel:set
- Word。ListTemplate:set
- Word。NoteItem:set
- Word。OleFormat:set
- Word。PageSetup:set
- Word。段落:set
- Word。ParagraphFormat:set
- Word。PictureContentControl:set
- Word。范围:设置
- Word。ReflectionFormat:set
- Word。RepeatingSectionContentControl: set
- Word。RepeatingSectionItem: set
- Word。审阅者:设置
- Word。修订:set
- Word。RevisionsFilter: set
- Word。SearchOptions:set
- Word。节:设置
- Word。设置:设置
- Word。底纹:set
- Word。ShadingUniversal:set
- Word。ShadowFormat:set
- Word。形状:设置
- Word。ShapeFill:set
- Word。ShapeGroup:set
- Word。ShapeTextWrap:set
- Word。样式:设置
- Word。表:set
- Word。TableBorder:set
- Word。TableCell:set
- Word。TableColumn:set
- Word。TableOfAuthorities:set
- Word。TableOfContents:set
- Word。TableOfFigures: set
- Word。TableRow:set
- Word。TableStyle:set
- Word。模板:设置
- Word。TextColumn:set
- Word。TextFrame:set
- Word。ThreeDimensionalFormat: set
- Word。视图:设置
- Word。窗口:set
- Word。XmlMapping:set
示例
// Update a range in an Excel worksheet using the RangeUpdateData interface.
await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getItem("Sample");
const range = sheet.getRange("B2:E2");
// Configure the set operation to still run if a readonly property is included.
// All settable properties will be updated.
const options: OfficeExtension.UpdateOptions = {throwOnReadOnly: false};
// Set the range with some data from another source (`updateData` is set elsewhere).
range.set(updateData, options);
await context.sync();
});
属性
| throw |
如果传入的属性列表包含只读属性, (default = true) ,则引发错误。 |
属性详细信息
throwOnReadOnly
如果传入的属性列表包含只读属性, (default = true) ,则引发错误。
throwOnReadOnly?: boolean
属性值
boolean