OfficeExtension.UpdateOptions interface
Proporciona una opción para suprimir un error cuando el objeto que se usa para establecer varias propiedades intenta establecer propiedades de solo lectura.
Comentarios
Usada por
- 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: establecer
- Visio.PageView: set
- Visio.Shape: set
- Visio.ShapeView: set
- Word. Aplicación: set
- Word. Bibliografía: set
- Word. Cuerpo: set
- Word. Marcador: set
- Word. Borde: establecer
- Word. BorderUniversal: set
- Word. Interrupción: establecer
- Word. BuildingBlock: set
- Word. BuildingBlockGalleryContentControl: set
- Word. Canvas: set
- Word. CheckboxContentControl: set
- Word. CoauthoringLock: set
- Word. CoauthoringUpdate: set
- Word. ColorFormat: set
- Word. Comentario: set
- Word. CommentContentRange: set
- Word. CommentReply: set
- Word. Conflicto: set
- Word. ContentControl: set
- Word. ContentControlListItem: set
- Word. CustomProperty: set
- Word. CustomXmlNode: set
- Word. CustomXmlPart: set
- Word. CustomXmlValidationError: set
- Word. DatePickerContentControl: set
- Word. Documento: set
- Word. DocumentCreated: set
- Word. DocumentProperties: set
- Word. Editor: set
- Word. Campo: set
- Word. FillFormat: set
- Word. Fuente: set
- Word. Marco: establecer
- Word. GlowFormat: set
- Word. GroupContentControl: set
- Word. HeadingStyle: set
- Word. Hipervínculo: set
- Word. Índice: 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. Párrafo: set
- Word. ParagraphFormat: set
- Word. PictureContentControl: set
- Word. Intervalo: establecido
- Word. ReflectionFormat: set
- Word. RepeatingSectionContentControl: set
- Word. RepeatingSectionItem: set
- Word. Revisor: establecer
- Word. Revisión: set
- Word. RevisionsFilter: set
- Word. SearchOptions: set
- Word. Sección: set
- Word. Configuración: establecer
- Word. Sombreado: establecer
- Word. ShadingUniversal: set
- Word. ShadowFormat: set
- Word. Forma: set
- Word. ShapeFill: set
- Word. ShapeGroup: set
- Word. ShapeTextWrap: set
- Word. Estilo: set
- Word. Tabla: 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. Plantilla: set
- Word. TextColumn: set
- Word. TextFrame: set
- Word. ThreeDimensionalFormat: set
- Word. Vista: establecer
- Word. Ventana: establecer
- Word. XmlMapping: set
Ejemplos
// 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();
});
Propiedades
| throw |
Se produce un error si la lista de propiedades pasadas incluye propiedades de solo lectura (valor predeterminado = true). |
Detalles de las propiedades
throwOnReadOnly
Se produce un error si la lista de propiedades pasadas incluye propiedades de solo lectura (valor predeterminado = true).
throwOnReadOnly?: boolean
Valor de propiedad
boolean