File Formats

Code Examples Upgrade Guide User Guide Demos Support Forums Download
  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Interface IWorksheetGroup

    Show / Hide Table of Contents

    Interface IWorksheetGroup

    Represents a worksheet group.

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

    Properties

    Count

    Number of selected worksheets.

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

    IsEmpty

    Indicates whether collection is empty. Read-only.

    Declaration
    bool IsEmpty { get; }
    Property Value
    Type Description
    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 Description
    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 - 2023 Syncfusion Inc. All Rights Reserved