menu

WinUI

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IWorksheetGroup - WinUI API Reference | Syncfusion

    Show / Hide Table of Contents

    Interface IWorksheetGroup

    Represents a worksheet group.

    Inherited Members
    ICalcData.add_ValueChanged(ValueChangedEventHandler)
    ICalcData.GetValueRowCol(Int32, Int32)
    ICalcData.remove_ValueChanged(ValueChangedEventHandler)
    ICalcData.SetValueRowCol(Object, Int32, Int32)
    ICalcData.ValueChanged
    ICalcData.WireParentObject()
    IParentApplication.Application
    IParentApplication.Parent
    ITabSheet.Activate()
    ITabSheet.Charts
    ITabSheet.CheckBoxes
    ITabSheet.CodeName
    ITabSheet.ComboBoxes
    ITabSheet.IsPasswordProtected
    ITabSheet.IsRightToLeft
    ITabSheet.IsSelected
    ITabSheet.Name
    ITabSheet.OptionButtons
    ITabSheet.Pictures
    ITabSheet.Protect(String)
    ITabSheet.Protect(String, ExcelSheetProtection)
    ITabSheet.ProtectContents
    ITabSheet.ProtectDrawingObjects
    ITabSheet.Protection
    ITabSheet.ProtectScenarios
    ITabSheet.Select()
    ITabSheet.Shapes
    ITabSheet.TabColor
    ITabSheet.TabColorRGB
    ITabSheet.TabIndex
    ITabSheet.TextBoxes
    ITabSheet.Unprotect(String)
    ITabSheet.Unselect()
    ITabSheet.Visibility
    ITabSheet.Workbook
    IWorksheet.ActivePane
    IWorksheet.add_CellValueChanged(RangeImpl.CellValueChangedEventHandler)
    IWorksheet.add_ExportDataTableEvent(WorksheetImpl.ExportDataTableEventHandler)
    IWorksheet.add_MissingFunction(MissingFunctionEventHandler)
    IWorksheet.AdvancedFilter(ExcelFilterAction, IRange, IRange, IRange, Boolean)
    IWorksheet.AutoFilters
    IWorksheet.AutofitColumn(Int32)
    IWorksheet.AutofitRow(Int32)
    IWorksheet.CalcEngine
    IWorksheet.Calculate()
    IWorksheet.Cells
    IWorksheet.CellValueChanged
    IWorksheet.Clear()
    IWorksheet.ClearData()
    IWorksheet.Columns
    IWorksheet.ColumnWidthToPixels(Double)
    IWorksheet.Comments
    IWorksheet.Contains(Int32, Int32)
    IWorksheet.ConvertToImage(Int32, Int32, Int32, Int32, ExportImageOptions, Stream)
    IWorksheet.ConvertToImage(Int32, Int32, Int32, Int32, Stream)
    IWorksheet.ConvertToImage(IRange, ExportImageOptions, Stream)
    IWorksheet.ConvertToImage(IRange, Stream)
    IWorksheet.CreateNamedRanges(String, String, Boolean)
    IWorksheet.CreateRangesCollection()
    IWorksheet.CreateTemplateMarkersProcessor()
    IWorksheet.CustomProperties
    IWorksheet.DataSorter
    IWorksheet.DeleteColumn(Int32)
    IWorksheet.DeleteColumn(Int32, Int32)
    IWorksheet.DeleteRow(Int32)
    IWorksheet.DeleteRow(Int32, Int32)
    IWorksheet.DisableSheetCalculations()
    IWorksheet.DisplayPageBreaks
    IWorksheet.EnableSheetCalculations()
    IWorksheet.ExportData<T>(Int32, Int32, Int32, Int32)
    IWorksheet.ExportData<T>(Int32, Int32, Int32, Int32, Dictionary<String, String>)
    IWorksheet.ExportDataTable(Int32, Int32, Int32, Int32, ExcelExportDataTableOptions)
    IWorksheet.ExportDataTable(Int32, Int32, Int32, Int32, ExcelExportDataTableOptions, ExcelExportDataOptions)
    IWorksheet.ExportDataTable(IRange, ExcelExportDataTableOptions)
    IWorksheet.ExportDataTable(IRange, ExcelExportDataTableOptions, ExcelExportDataOptions)
    IWorksheet.ExportDataTableEvent
    IWorksheet.FindAll(Boolean)
    IWorksheet.FindAll(DateTime)
    IWorksheet.FindAll(Double, ExcelFindType)
    IWorksheet.FindAll(String, ExcelFindType)
    IWorksheet.FindAll(String, ExcelFindType, ExcelFindOptions)
    IWorksheet.FindAll(TimeSpan)
    IWorksheet.FindFirst(Boolean)
    IWorksheet.FindFirst(DateTime)
    IWorksheet.FindFirst(Double, ExcelFindType)
    IWorksheet.FindFirst(String, ExcelFindType)
    IWorksheet.FindFirst(String, ExcelFindType, ExcelFindOptions)
    IWorksheet.FindFirst(TimeSpan)
    IWorksheet.FindStringEndsWith(String, ExcelFindType)
    IWorksheet.FindStringEndsWith(String, ExcelFindType, Boolean)
    IWorksheet.FindStringStartsWith(String, ExcelFindType)
    IWorksheet.FindStringStartsWith(String, ExcelFindType, Boolean)
    IWorksheet.FirstVisibleColumn
    IWorksheet.FirstVisibleRow
    IWorksheet.FreeRange(Int32, Int32)
    IWorksheet.FreeRange(IRange)
    IWorksheet.GetBoolean(Int32, Int32)
    IWorksheet.GetCellValue(Int32, Int32, Boolean)
    IWorksheet.GetColumnWidth(Int32)
    IWorksheet.GetColumnWidthInPixels(Int32)
    IWorksheet.GetDefaultColumnStyle(Int32)
    IWorksheet.GetDefaultRowStyle(Int32)
    IWorksheet.GetError(Int32, Int32)
    IWorksheet.GetFormula(Int32, Int32, Boolean)
    IWorksheet.GetFormulaBoolValue(Int32, Int32)
    IWorksheet.GetFormulaErrorValue(Int32, Int32)
    IWorksheet.GetFormulaNumberValue(Int32, Int32)
    IWorksheet.GetFormulaStringValue(Int32, Int32)
    IWorksheet.GetNumber(Int32, Int32)
    IWorksheet.GetRowHeight(Int32)
    IWorksheet.GetRowHeightInPixels(Int32)
    IWorksheet.GetText(Int32, Int32)
    IWorksheet.GridLineColor
    IWorksheet.HasOleObject
    IWorksheet.HideColumn(Int32)
    IWorksheet.HideRow(Int32)
    IWorksheet.HorizontalSplit
    IWorksheet.HPageBreaks
    IWorksheet.HyperLinks
    IWorksheet.ImportArray(DateTime[], Int32, Int32, Boolean)
    IWorksheet.ImportArray(Double[], Int32, Int32, Boolean)
    IWorksheet.ImportArray(Int32[], Int32, Int32, Boolean)
    IWorksheet.ImportArray(Object[,], Int32, Int32)
    IWorksheet.ImportArray(Object[], Int32, Int32, Boolean)
    IWorksheet.ImportArray(String[], Int32, Int32, Boolean)
    IWorksheet.ImportData(IEnumerable, ExcelImportDataOptions)
    IWorksheet.ImportData(IEnumerable, Int32, Int32, Boolean)
    IWorksheet.ImportDataColumn(DataColumn, Boolean, Int32, Int32)
    IWorksheet.ImportDataColumn(DataColumn, Boolean, Int32, Int32, Boolean)
    IWorksheet.ImportDataReader(IDataReader, Boolean, Int32, Int32)
    IWorksheet.ImportDataReader(IDataReader, Boolean, Int32, Int32, Boolean)
    IWorksheet.ImportDataReader(IDataReader, IName, Boolean)
    IWorksheet.ImportDataReader(IDataReader, Int32, Int32, Boolean)
    IWorksheet.ImportDataTable(DataTable, Boolean, Int32, Int32)
    IWorksheet.ImportDataTable(DataTable, Boolean, Int32, Int32, Boolean)
    IWorksheet.ImportDataTable(DataTable, Boolean, Int32, Int32, Int32, Int32)
    IWorksheet.ImportDataTable(DataTable, Boolean, Int32, Int32, Int32, Int32, Boolean)
    IWorksheet.ImportDataTable(DataTable, IName, Boolean)
    IWorksheet.ImportDataTable(DataTable, IName, Boolean, Int32, Int32)
    IWorksheet.ImportDataTable(DataTable, IName, Boolean, Int32, Int32, Int32, Int32)
    IWorksheet.ImportDataTable(DataTable, IName, Boolean, Int32, Int32, Int32, Int32, Boolean)
    IWorksheet.ImportDataTable(DataTable, Int32, Int32, Boolean)
    IWorksheet.ImportDataTable(DataTable, Int32, Int32, Boolean, Boolean)
    IWorksheet.ImportDataView(DataView, Boolean, Int32, Int32)
    IWorksheet.ImportDataView(DataView, Boolean, Int32, Int32, Boolean)
    IWorksheet.ImportDataView(DataView, Boolean, Int32, Int32, Int32, Int32)
    IWorksheet.ImportDataView(DataView, Boolean, Int32, Int32, Int32, Int32, Boolean)
    IWorksheet.ImportHtmlTable(Stream, Int32, Int32)
    IWorksheet.ImportHtmlTable(Stream, Int32, Int32, HtmlImportOptions)
    IWorksheet.ImportHtmlTable(String, Int32, Int32)
    IWorksheet.ImportHtmlTable(String, Int32, Int32, HtmlImportOptions)
    IWorksheet.ImportXml(Stream, Int32, Int32)
    IWorksheet.Index
    IWorksheet.InsertColumn(Int32)
    IWorksheet.InsertColumn(Int32, Int32)
    IWorksheet.InsertColumn(Int32, Int32, ExcelInsertOptions)
    IWorksheet.InsertRow(Int32)
    IWorksheet.InsertRow(Int32, Int32)
    IWorksheet.InsertRow(Int32, Int32, ExcelInsertOptions)
    IWorksheet.IntersectRanges(IRange, IRange)
    IWorksheet.IsColumnVisible(Int32)
    IWorksheet.IsDisplayZeros
    IWorksheet.IsFreezePanes
    IWorksheet.IsGridLinesVisible
    IWorksheet.IsRowColumnHeadersVisible
    IWorksheet.IsRowVisible(Int32)
    IWorksheet.IsStringsPreserved
    IWorksheet.Item[Int32, Int32, Int32, Int32]
    IWorksheet.Item[Int32, Int32]
    IWorksheet.Item[String, Boolean]
    IWorksheet.Item[String]
    IWorksheet.LeftVisibleColumn
    IWorksheet.ListObjects
    IWorksheet.MergedCells
    IWorksheet.MergeRanges(IRange, IRange)
    IWorksheet.MigrantRange
    IWorksheet.MissingFunction
    IWorksheet.Move(Int32)
    IWorksheet.Names
    IWorksheet.OleObjects
    IWorksheet.PageSetup
    IWorksheet.PivotTables
    IWorksheet.PixelsToColumnWidth(Int32)
    IWorksheet.Range
    IWorksheet.Remove()
    IWorksheet.remove_CellValueChanged(RangeImpl.CellValueChangedEventHandler)
    IWorksheet.remove_ExportDataTableEvent(WorksheetImpl.ExportDataTableEventHandler)
    IWorksheet.remove_MissingFunction(MissingFunctionEventHandler)
    IWorksheet.RemovePanes()
    IWorksheet.Replace(String, DataColumn, Boolean)
    IWorksheet.Replace(String, DataTable, Boolean)
    IWorksheet.Replace(String, DateTime)
    IWorksheet.Replace(String, Double)
    IWorksheet.Replace(String, Double[], Boolean)
    IWorksheet.Replace(String, Int32[], Boolean)
    IWorksheet.Replace(String, String)
    IWorksheet.Replace(String, String, ExcelFindOptions)
    IWorksheet.Replace(String, String[], Boolean)
    IWorksheet.Rows
    IWorksheet.SaveAs(Stream, String)
    IWorksheet.SaveAs(Stream, String, Encoding)
    IWorksheet.SaveAs(String, String)
    IWorksheet.SaveAs(String, String, Encoding)
    IWorksheet.SaveAsHtml(Stream)
    IWorksheet.SaveAsHtml(Stream, HtmlSaveOptions)
    IWorksheet.Scenarios
    IWorksheet.SetBlank(Int32, Int32)
    IWorksheet.SetBoolean(Int32, Int32, Boolean)
    IWorksheet.SetColumnWidth(Int32, Double)
    IWorksheet.SetColumnWidthInPixels(Int32, Int32)
    IWorksheet.SetColumnWidthInPixels(Int32, Int32, Int32)
    IWorksheet.SetDefaultColumnStyle(Int32, Int32, IStyle)
    IWorksheet.SetDefaultColumnStyle(Int32, IStyle)
    IWorksheet.SetDefaultRowStyle(Int32, Int32, IStyle)
    IWorksheet.SetDefaultRowStyle(Int32, IStyle)
    IWorksheet.SetError(Int32, Int32, String)
    IWorksheet.SetFormula(Int32, Int32, String)
    IWorksheet.SetFormulaBoolValue(Int32, Int32, Boolean)
    IWorksheet.SetFormulaErrorValue(Int32, Int32, String)
    IWorksheet.SetFormulaNumberValue(Int32, Int32, Double)
    IWorksheet.SetFormulaStringValue(Int32, Int32, String)
    IWorksheet.SetNumber(Int32, Int32, Double)
    IWorksheet.SetRowHeight(Int32, Double)
    IWorksheet.SetRowHeightInPixels(Int32, Double)
    IWorksheet.SetRowHeightInPixels(Int32, Int32, Double)
    IWorksheet.SetText(Int32, Int32, String)
    IWorksheet.SetValue(Int32, Int32, String)
    IWorksheet.ShowColumn(Int32, Boolean)
    IWorksheet.ShowRange(IRange, Boolean)
    IWorksheet.ShowRange(IRange[], Boolean)
    IWorksheet.ShowRange(RangesCollection, Boolean)
    IWorksheet.ShowRow(Int32, Boolean)
    IWorksheet.Slicers
    IWorksheet.SparklineGroups
    IWorksheet.SplitCell
    IWorksheet.StandardHeight
    IWorksheet.StandardHeightFlag
    IWorksheet.StandardWidth
    IWorksheet.ThreadedComments
    IWorksheet.TopVisibleRow
    IWorksheet.Type
    IWorksheet.UsedCells
    IWorksheet.UsedRange
    IWorksheet.UsedRangeIncludesFormatting
    IWorksheet.UseRangesCache
    IWorksheet.VerticalSplit
    IWorksheet.View
    IWorksheet.VPageBreaks
    IWorksheet.Zoom
    Namespace: Syncfusion.XlsIO
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public interface IWorksheetGroup : IWorksheet, ITabSheet, IParentApplication, ICalcData

    Properties

    Count

    Number of selected worksheets.

    Declaration
    int Count { get; }
    Property Value
    Type
    System.Int32

    IsEmpty

    Indicates whether collection is empty. Read-only.

    Declaration
    bool IsEmpty { get; }
    Property Value
    Type
    System.Boolean

    Item[Int32]

    Returns single entry from the collection. Read-only.

    Declaration
    IWorksheet this[int index] { get; }
    Parameters
    Type Name Description
    System.Int32 index
    Property Value
    Type
    IWorksheet

    Methods

    Add(ITabSheet)

    Adds new worksheet to the collection.

    Declaration
    int Add(ITabSheet sheet)
    Parameters
    Type Name Description
    ITabSheet sheet

    Worksheet to add.

    Returns
    Type Description
    System.Int32

    Index of the added worksheet.

    Exceptions
    Type Condition
    System.ArgumentNullException

    When sheet is Null.

    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved