Skip to main content

SpreadsheetRibbonItemCollectionBuilder Methods

A builder for the Spreadsheet ribbon item collection.
Name Description
AddAlignBottomItem() Adds the Align Bottom item to the ribbon item collection.
AddAlignMiddleItem() Adds the Align Middle item to the ribbon item collection.
AddAlignParagraphCenterItem() Adds the Align Paragraph Center item to the ribbon item collection.
AddAlignParagraphLeftItem() Adds the Align Paragraph Left item to the ribbon item collection.
AddAlignParagraphRightItem() Adds the Align Paragraph Right item to the ribbon item collection.
AddAlignTopItem() Adds the Align Top item to the ribbon item collection.
AddAutoSumItem() Adds the Auto Sum item to the ribbon item collection.
AddBackgroundColorItem() Adds the Background Color item to the ribbon item collection.
AddBorderLineColorItem() Adds the Border Line Color item to the ribbon item collection.
AddBordersItem() Adds the Borders item to the ribbon item collection.
AddButton() Adds a new item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddButton(String, String, Boolean, String, Boolean) Adds a new item with the specified settings to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddCalculateNowItem() Adds the Calculate Now item to the ribbon item collection.
AddCalculateSheetItem() Adds the Calculate Sheet item to the ribbon item collection.
AddCalculationOptionsItem() Adds the Calculation Options item to the ribbon item collection.
AddChartAxesItem() Adds the Chart Axes item to the ribbon item collection.
AddChartAxisTitlesItem() Adds the Chart Axis Titles item to the ribbon item collection.
AddChartBringForwardItem() Adds the Chart Bring Forward item to the ribbon item collection.
AddChartDataLabelsItem() Adds the Chart Data Labels item to the ribbon item collection.
AddChartGridlinesItem() Adds the Chart Gridlines item to the ribbon item collection.
AddChartLayoutItem() Adds the Chart Layout item to the ribbon item collection.
AddChartLegendItem() Adds the Chart Legend item to the ribbon item collection.
AddChartSelectDataItem() Adds the Chart Select Data item to the ribbon item collection.
AddChartSendBackwardItem() Adds the Chart Send Backward item to the ribbon item collection.
AddChartStyleItem() Adds the Chart Style item to the ribbon item collection.
AddChartSwitchRowColumnItem() Adds the Chart Switch Row Column item to the ribbon item collection.
AddChartTitleItem() Adds the Chart Title item to the ribbon item collection.
AddChartTypeItem() Adds the Chart Type item to the ribbon item collection.
AddClearFilterItem() Adds the Clear Filter item to the ribbon item collection.
AddClearItem() Adds the Clear item to the ribbon item collection.
AddColorBox() Adds a new color box item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddColorBox(String, String, Boolean, String) Adds a new color box item with the specified settings to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddCopyItem() Adds the Copy item to the ribbon item collection.
AddCutItem() Adds the Cut item to the ribbon item collection.
AddDataValidationItem() Adds the Data Validation item to the ribbon item collection.
AddDateAndTimeFunctionsItem() Adds the Date And Time Functions item to the ribbon item collection.
AddDecreaseDecimalItem() Adds the Decrease Decimal item to the ribbon item collection.
AddDecreaseFontSizeItem() Adds the Decrease Font Size item to the ribbon item collection.
AddDecreaseIndentItem() Adds the Decrease Indent item to the ribbon item collection.
AddDeleteCellsItem() Adds the Delete Cells item to the ribbon item collection.
AddDeleteCommentItem() Adds the Delete Comment item to the ribbon item collection.
AddEditCommentItem() Adds the Edit Comment item to the ribbon item collection.
AddFillItem() Adds the Fill item to the ribbon item collection.
AddFilterItem() Adds the Filter item to the ribbon item collection.
AddFinancialFunctionsItem() Adds the Financial Functions item to the ribbon item collection.
AddFindItem() Adds the Find item to the ribbon item collection.
AddFontBoldItem() Adds the Font Bold item to the ribbon item collection.
AddFontItalicItem() Adds the Font Italic item to the ribbon item collection.
AddFontNameItem() Adds the Font Name item to the ribbon item collection.
AddFontSizeItem() Adds the Font Size item to the ribbon item collection.
AddFontStrikeoutItem() Adds the Font Strikeout item to the ribbon item collection.
AddFontUnderlineItem() Adds the Font Underline item to the ribbon item collection.
AddForeColorItem() Adds the Font Color item to the ribbon item collection.
AddFormatAsTableItem() Adds the Format As Table item to the ribbon item collection.
AddFormatItem() Adds the Format item to the ribbon item collection.
AddFreezePanesItem() Adds the Freeze Panes item to the ribbon item collection.
AddFullScreenItem() Adds the Full Screen item to the ribbon item collection.
AddGridlinesItem() Adds the Gridlines item to the ribbon item collection.
AddHeadingsItem() Adds the Headings item to the ribbon item collection.
AddIncreaseDecimalItem() Adds the Increase Decimal item to the ribbon item collection.
AddIncreaseFontSizeItem() Adds the Increase Font Size item to the ribbon item collection.
AddIncreaseIndentItem() Adds the Increase Indent item to the ribbon item collection.
AddInsertAreaChartItem() Adds the Insert Area Chart item to the ribbon item collection.
AddInsertBarChartItem() Adds the Insert Bar Chart item to the ribbon item collection.
AddInsertCellsItem() Adds the Insert Cells item to the ribbon item collection.
AddInsertColumnChartItem() Adds the Insert Column Chart item to the ribbon item collection.
AddInsertHyperlinkItem() Adds the Insert Hyperlink item to the ribbon item collection.
AddInsertLineChartItem() Adds the Insert Line Char item to the ribbon item collection.
AddInsertOtherChartsItem() Adds the Insert Other Charts item to the ribbon item collection.
AddInsertPictureItem() Adds the Insert Picture item to the ribbon item collection.
AddInsertPieChartItem() Adds the Insert Pie Chart item to the ribbon item collection.
AddInsertScatterChartItem() Adds the Insert Scatter Chart item to the ribbon item collection.
AddInsertTableItem() Adds the Insert Table item to the ribbon item collection.
AddLogicalFunctionsItem() Adds the Logical Functions item to the ribbon item collection.
AddLookupAndReferenceFunctionsItem() Adds the Lookup And Reference Functions item to the ribbon item collection.
AddMathAndTrigFunctionsItem() Adds the Math And Trig Functions item to the ribbon item collection.
AddMenu() Adds a new menu item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddMergeCellsItem() Adds the Merge Cells item to the ribbon item collection.
AddMoreFunctionsItem() Adds the More Functions item to the ribbon item collection.
AddNewCommentItem() Adds the New Comment item to the ribbon item collection.
AddNumberBox() Adds a new number box item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddNumberBox(String, String, Boolean, Int32, Int32, Int32, Int32, String, Int32) Adds a new number box item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddNumberCurrencyItem() Adds the Number Currency item to the ribbon item collection.
AddPasteItem() Adds the Paste item to the ribbon item collection.
AddPercentageItem() Adds the Percentage item to the ribbon item collection.
AddPictureBringForwardItem() Adds the Picture Bring Forward item to the ribbon item collection.
AddPictureSendBackwardItem() Adds the Picture Send Backward item to the ribbon item collection.
AddPrintItem() Adds the Print item to the ribbon item collection.
AddReapplyFilterItem() Adds the Reapply Filter item to the ribbon item collection.
AddRedoItem() Adds the Redo item to the ribbon item collection.
AddSelectBox() Adds a new select box item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddShowHideCommentItem() Adds the Show Hide Comment item to the ribbon item collection.
AddSortAndFilterItem() Adds the Sort And Filter item to the ribbon item collection.
AddSortAscendingItem() Adds the Sort Ascending item to the ribbon item collection.
AddSortDescendingItem() Adds the Sort Descending item to the ribbon item collection.
AddTableConvertToRangeItem() Adds the Table Convert To Range item to the ribbon item collection.
AddTableModifyStyleItem() Adds the Table Modify Style item to the ribbon item collection.
AddTableStyleOptionsItem() Adds the Table Style Options item to the ribbon item collection.
AddTextFunctionsItem() Adds the Text Functions item to the ribbon item collection.
AddThousandsSeparatorItem() Adds the Thousands Separator item to the ribbon item collection.
AddToggleButton(Boolean) Adds a new button item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddToggleButton(String, String, Boolean, String, Boolean, Boolean) Adds a new button item to the end of the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
AddUndoItem() Adds the Undo item to the ribbon item collection.
AddWrapTextItem() Adds the Wrap Text item to the ribbon item collection.
Clear() Removes all items from the collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
InsertAlignBottomItem(Int32) Inserts the Align Bottom item to the ribbon item collection at the specified position.
InsertAlignMiddleItem(Int32) Inserts the Align Middle item to the ribbon item collection at the specified position.
InsertAlignParagraphCenterItem(Int32) Inserts the Align Paragraph Center item to the ribbon item collection at the specified position.
InsertAlignParagraphLeftItem(Int32) Inserts the Align Paragraph Left item to the ribbon item collection at the specified position.
InsertAlignParagraphRightItem(Int32) Inserts the Align Paragraph Right item to the ribbon item collection at the specified position.
InsertAlignTopItem(Int32) Inserts the Align Top item to the ribbon item collection at the specified position.
InsertAutoSumItem(Int32) Inserts the Auto Sum item to the ribbon item collection at the specified position.
InsertBackgroundColorItem(Int32) Inserts the Background Color item to the ribbon item collection at the specified position.
InsertBorderLineColorItem(Int32) Inserts the Border Line Color item to the ribbon item collection at the specified position.
InsertBordersItem(Int32) Inserts the Borders item to the ribbon item collection at the specified position.
InsertButton(Int32) Inserts a new button item to the ribbon item collection at the specified position. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
InsertCalculateNowItem(Int32) Inserts the Calculate Now item to the ribbon item collection at the specified position.
InsertCalculateSheetItem(Int32) Inserts the Calculate Sheet item to the ribbon item collection at the specified position.
InsertCalculationOptionsItem(Int32) Inserts the Calculation Options item to the ribbon item collection at the specified position.
InsertChartAxesItem(Int32) Inserts the Chart Axes item to the ribbon item collection at the specified position.
InsertChartAxisTitlesItem(Int32) Inserts the Chart Axis Titles item to the ribbon item collection at the specified position.
InsertChartBringForwardItem(Int32) Inserts the Chart Bring Forward item to the ribbon item collection at the specified position.
InsertChartDataLabelsItem(Int32) Inserts the Chart Data Labels item to the ribbon item collection at the specified position.
InsertChartGridlinesItem(Int32) Inserts the Chart Gridlines item to the ribbon item collection at the specified position.
InsertChartLayoutItem(Int32) Inserts the Chart Layout item to the ribbon item collection at the specified position.
InsertChartLegendItem(Int32) Inserts the Chart Legend item to the ribbon item collection at the specified position.
InsertChartSelectDataItem(Int32) Inserts the Chart Select Data item to the ribbon item collection at the specified position.
InsertChartSendBackwardItem(Int32) Inserts the Chart Send Backward item to the ribbon item collection at the specified position.
InsertChartStyleItem(Int32) Inserts the Chart Style item to the ribbon item collection at the specified position.
InsertChartSwitchRowColumnItem(Int32) Inserts the Chart Switch Row Column item to the ribbon item collection at the specified position.
InsertChartTitleItem(Int32) Inserts the Chart Title item to the ribbon item collection at the specified position.
InsertChartTypeItem(Int32) Inserts the Chart Type item to the ribbon item collection at the specified position.
InsertClearFilterItem(Int32) Inserts the Clear Filter item to the ribbon item collection at the specified position.
InsertClearItem(Int32) Inserts the Clear item to the ribbon item collection at the specified position.
InsertColorBox(Int32) Inserts a new color box item to the ribbon item collection at the specified position. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
InsertCopyItem(Int32) Inserts the Copy item to the ribbon item collection at the specified position.
InsertCutItem(Int32) Inserts the Cut item to the ribbon item collection at the specified position.
InsertDataValidationItem(Int32) Inserts the Data Validation item to the ribbon item collection at the specified position.
InsertDateAndTimeFunctionsItem(Int32) Inserts the Date And Time Functions item to the ribbon item collection at the specified position.
InsertDecreaseDecimalItem(Int32) Inserts the Decrease Decimal item to the ribbon item collection at the specified position.
InsertDecreaseFontSizeItem(Int32) Inserts the Decrease Font Size item to the ribbon item collection at the specified position.
InsertDecreaseIndentItem(Int32) Inserts the Decrease Indent item to the ribbon item collection at the specified position.
InsertDeleteCellsItem(Int32) Inserts the Delete Cells item to the ribbon item collection at the specified position.
InsertDeleteCommentItem(Int32) Inserts the Delete Comment item to the ribbon item collection at the specified position.
InsertEditCommentItem(Int32) Inserts the Edit Comment item to the ribbon item collection at the specified position.
InsertFillItem(Int32) Inserts the Fill item to the ribbon item collection at the specified position.
InsertFilterItem(Int32) Inserts the Filter item to the ribbon item collection at the specified position.
InsertFinancialFunctionsItem(Int32) Inserts the Financial Functions item to the ribbon item collection at the specified position.
InsertFindItem(Int32) Inserts the Find item to the ribbon item collection at the specified position.
InsertFontBoldItem(Int32) Inserts the Font Bold item to the ribbon item collection at the specified position.
InsertFontItalicItem(Int32) Inserts the Font Italic item to the ribbon item collection at the specified position.
InsertFontNameItem(Int32) Inserts the Font Name item to the ribbon item collection at the specified position.
InsertFontSizeItem(Int32) Inserts the Font Size item to the ribbon item collection at the specified position.
InsertFontStrikeoutItem(Int32) Inserts the Font Strikeout item to the ribbon item collection at the specified position.
InsertFontUnderlineItem(Int32) Inserts the Font Underline item to the ribbon item collection at the specified position.
InsertForeColorItem(Int32) Inserts the Font Color item to the ribbon item collection at the specified position.
InsertFormatAsTableItem(Int32) Inserts the Format As Table item to the ribbon item collection at the specified position.
InsertFormatItem(Int32) Inserts the Format item to the ribbon item collection at the specified position.
InsertFreezePanesItem(Int32) Inserts the Freeze Panes item to the ribbon item collection at the specified position.
InsertFullScreenItem(Int32) Inserts the Full Screen item to the ribbon item collection at the specified position.
InsertGridlinesItem(Int32) Inserts the Gridlines item to the ribbon item collection at the specified position.
InsertHeadingsItem(Int32) Inserts the Headings item to the ribbon item collection at the specified position.
InsertIncreaseDecimalItem(Int32) Inserts the Increase Decimal item to the ribbon item collection at the specified position.
InsertIncreaseFontSizeItem(Int32) Inserts the Increase Font Size item to the ribbon item collection at the specified position.
InsertIncreaseIndentItem(Int32) Inserts the Increase Indent item to the ribbon item collection at the specified position.
InsertInsertAreaChartItem(Int32) Inserts the Insert Area Chart item to the ribbon item collection at the specified position.
InsertInsertBarChartItem(Int32) Inserts the Insert Bar Chart item to the ribbon item collection at the specified position.
InsertInsertCellsItem(Int32) Inserts the Insert Cells item to the ribbon item collection at the specified position.
InsertInsertColumnChartItem(Int32) Inserts the Insert Column Chart item to the ribbon item collection at the specified position.
InsertInsertHyperlinkItem(Int32) Inserts the Insert Hyperlink item to the ribbon item collection at the specified position.
InsertInsertLineChartItem(Int32) Inserts the Insert Line Char item to the ribbon item collection at the specified position.
InsertInsertOtherChartsItem(Int32) Inserts the Insert Other Charts item to the ribbon item collection at the specified position.
InsertInsertPictureItem(Int32) Inserts the Insert Picture item to the ribbon item collection at the specified position.
InsertInsertPieChartItem(Int32) Inserts the Insert Pie Chart item to the ribbon item collection at the specified position.
InsertInsertScatterChartItem(Int32) Inserts the Insert Scatter Chart item to the ribbon item collection at the specified position.
InsertInsertTableItem(Int32) Inserts the Insert Table item to the ribbon item collection at the specified position.
InsertLogicalFunctionsItem(Int32) Inserts the Logical Functions item to the ribbon item collection at the specified position.
InsertLookupAndReferenceFunctionsItem(Int32) Inserts the Lookup And Reference Functions item to the ribbon item collection at the specified position.
InsertMathAndTrigFunctionsItem(Int32) Inserts the Math And Trig Functions item to the ribbon item collection at the specified position.
InsertMenu(Int32) Inserts a new menu item to the ribbon item collection at the specified position. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
InsertMergeCellsItem(Int32) Inserts the Merge Cells item to the ribbon item collection at the specified position.
InsertMoreFunctionsItem(Int32) Inserts the More Functions item to the ribbon item collection at the specified position.
InsertNewCommentItem(Int32) Inserts the New Comment item to the ribbon item collection at the specified position.
InsertNumberBox(Int32) Inserts a new number box item to the ribbon item collection at the specified position. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
InsertNumberCurrencyItem(Int32) Inserts the Number Currency item to the ribbon item collection at the specified position.
InsertPasteItem(Int32) Inserts the Paste item to the ribbon item collection at the specified position.
InsertPercentageItem(Int32) Inserts the Percentage item to the ribbon item collection at the specified position.
InsertPictureBringForwardItem(Int32) Inserts the Picture Bring Forward item to the ribbon item collection at the specified position.
InsertPictureSendBackwardItem(Int32) Inserts the Picture Send Backward item to the ribbon item collection at the specified position.
InsertPrintItem(Int32) Inserts the Print item to the ribbon item collection at the specified position.
InsertReapplyFilterItem(Int32) Inserts the Reapply Filter item to the ribbon item collection at the specified position.
InsertRedoItem(Int32) Inserts the Redo item to the ribbon item collection at the specified position.
InsertSelectBox(Int32) Inserts a new select box item to the ribbon item collection at the specified position. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
InsertShowHideCommentItem(Int32) Inserts the Show Hide Comment item to the ribbon item collection at the specified position.
InsertSortAndFilterItem(Int32) Inserts the Sort And Filter item to the ribbon item collection at the specified position.
InsertSortAscendingItem(Int32) Inserts the Sort Ascending item to the ribbon item collection at the specified position.
InsertSortDescendingItem(Int32) Inserts the Sort Descending item to the ribbon item collection at the specified position.
InsertTableConvertToRangeItem(Int32) Inserts the Table Convert To Range item to the ribbon item collection at the specified position.
InsertTableModifyStyleItem(Int32) Inserts the Table Modify Style item to the ribbon item collection at the specified position.
InsertTableStyleOptionsItem(Int32) Inserts the Table Style Options item to the ribbon item collection at the specified position.
InsertTextFunctionsItem(Int32) Inserts the Text Functions item to the ribbon item collection at the specified position.
InsertThousandsSeparatorItem(Int32) Inserts the Thousands Separator item to the ribbon item collection at the specified position.
InsertToggleButton(Int32, Boolean) Inserts a new button item into the ribbon item collection at the specified position. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
InsertUndoItem(Int32) Inserts the Undo item to the ribbon item collection at the specified position.
InsertWrapTextItem(Int32) Inserts the Wrap Text item to the ribbon item collection at the specified position.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
RemoveAt(Int32) Removes an item at the specified position from the ribbon item collection. Inherited from RibbonItemCollectionBuilder<TItemCollectionBuilder>.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also