Interface IWorksheetGroup

Namespace

Spire.Xls.Core

Assembly

Spire.XLS.dll

public interface IWorksheetGroup : IWorksheet, ITabSheet, IExcelApplication

Inherited Members

IWorksheet.Clear()

IWorksheet.ClearData()

IWorksheet.CheckExistence(int, int)

IWorksheet.CreateNamedRanges(string, string, bool)

IWorksheet.IsColumnVisible(int)

IWorksheet.IsRowVisible(int)

IWorksheet.DeleteRow(int)

IWorksheet.DeleteColumn(int)

IWorksheet.InsertArray(object[], int, int, bool)

IWorksheet.InsertArray(string[], int, int, bool)

IWorksheet.InsertArray(int[], int, int, bool)

IWorksheet.InsertArray(double[], int, int, bool)

IWorksheet.InsertArray(DateTime[], int, int, bool)

IWorksheet.InsertArray(object[,], int, int)

IWorksheet.InsertDataColumn(DataColumn, bool, int, int)

IWorksheet.InsertDataTable(DataTable, bool, int, int)

IWorksheet.InsertDataTable(DataTable, bool, int, int, bool)

IWorksheet.InsertDataTable(DataTable, bool, int, int, int, int)

IWorksheet.InsertDataTable(DataTable, bool, int, int, int, int, bool)

IWorksheet.InsertDataView(DataView, bool, int, int)

IWorksheet.InsertDataView(DataView, bool, int, int, bool)

IWorksheet.InsertDataView(DataView, bool, int, int, int, int)

IWorksheet.InsertDataView(DataView, bool, int, int, int, int, bool)

IWorksheet.RemovePanes()

IWorksheet.Protect(string)

IWorksheet.Unprotect(string)

IWorksheet.AutoFitRow(int)

IWorksheet.AutoFitColumn(int)

IWorksheet.Replace(string, string)

IWorksheet.Replace(string, double)

IWorksheet.Replace(string, DateTime)

IWorksheet.Replace(string, string[], bool)

IWorksheet.Replace(string, int[], bool)

IWorksheet.Replace(string, double[], bool)

IWorksheet.Replace(string, DataTable, bool)

IWorksheet.Replace(string, DataColumn, bool)

IWorksheet.Remove()

IWorksheet.MoveWorksheet(int)

IWorksheet.ColumnWidthToPixels(double)

IWorksheet.PixelsToColumnWidth(double)

IWorksheet.SetColumnWidthInPixels(int, int)

IWorksheet.SetRowHeightPixels(int, double)

IWorksheet.GetColumnWidthPixels(int)

IWorksheet.GetRowHeightPixels(int)

IWorksheet.SaveToFile(string, string)

IWorksheet.SaveToStream(Stream, string)

IWorksheet.SetDefaultColumnStyle(int, IStyle)

IWorksheet.SetDefaultColumnStyle(int, int, IStyle)

IWorksheet.SetDefaultRowStyle(int, IStyle)

IWorksheet.SetDefaultRowStyle(int, int, IStyle)

IWorksheet.GetDefaultColumnStyle(int)

IWorksheet.GetDefaultRowStyle(int)

IWorksheet.SetValue(int, int, string)

IWorksheet.SetNumber(int, int, double)

IWorksheet.SetBoolean(int, int, bool)

IWorksheet.SetText(int, int, string)

IWorksheet.SetFormula(int, int, string)

IWorksheet.SetError(int, int, string)

IWorksheet.SetBlank(int, int)

IWorksheet.SetFormulaNumberValue(int, int, double)

IWorksheet.SetFormulaErrorValue(int, int, string)

IWorksheet.SetFormulaBoolValue(int, int, bool)

IWorksheet.SetFormulaStringValue(int, int, string)

IWorksheet.GetText(int, int)

IWorksheet.GetNumber(int, int)

IWorksheet.GetFormula(int, int, bool)

IWorksheet.GetError(int, int)

IWorksheet.GetBoolean(int, int)

IWorksheet.GetFormulaBoolValue(int, int)

IWorksheet.GetFormulaErrorValue(int, int)

IWorksheet.GetFormulaNumberValue(int, int)

IWorksheet.GetFormulaStringValue(int, int)

IWorksheet.SaveToHtml(string)

IWorksheet.SaveToHtml(Stream)

IWorksheet.SaveToHtml(string, HTMLOptions)

IWorksheet.SaveToHtml(Stream, HTMLOptions)

IWorksheet.AutoFilters

IWorksheet.Cells

IWorksheet.DisplayPageBreaks

IWorksheet.Index

IWorksheet.MergedCells

IWorksheet.Names

IWorksheet.CodeName

IWorksheet.PageSetup

IWorksheet.AllocatedRange

IWorksheet.Rows

IWorksheet.Columns

IWorksheet.DefaultRowHeight

IWorksheet.DefaultColumnWidth

IWorksheet.Type

IWorksheet.Range

IWorksheet.Zoom

IWorksheet.VerticalSplit

IWorksheet.HorizontalSplit

IWorksheet.FirstVisibleRow

IWorksheet.FirstVisibleColumn

IWorksheet.ActivePane

IWorksheet.IsDisplayZeros

IWorksheet.GridLinesVisible

IWorksheet.GridLineColor

IWorksheet.RowColumnHeadersVisible

IWorksheet.FormulasVisible

IWorksheet.VPageBreaks

IWorksheet.HPageBreaks

IWorksheet.IsStringsPreserved

IWorksheet.Comments

IWorksheet.this[int, int]

IWorksheet.this[int, int, int, int]

IWorksheet.this[string]

IWorksheet.HyperLinks

IWorksheet.UseRangesCache

IWorksheet.TopVisibleRow

IWorksheet.LeftVisibleColumn

IWorksheet.PivotTables

IWorksheet.ListObjects

IWorksheet.OleObjects

IWorksheet.HasOleObjects

IWorksheet.CellValueChanged

ITabSheet.Activate()

ITabSheet.Select()

ITabSheet.Unselect()

ITabSheet.Protect(string, SheetProtectionType)

ITabSheet.TabKnownColor

ITabSheet.TabColor

ITabSheet.Pictures

ITabSheet.Workbook

ITabSheet.IsRightToLeft

ITabSheet.IsSelected

ITabSheet.TabIndex

ITabSheet.Name

ITabSheet.Visibility

ITabSheet.TextBoxes

ITabSheet.CheckBoxes

ITabSheet.ComboBoxes

ITabSheet.RadioButtons

ITabSheet.ProtectContents

ITabSheet.ProtectDrawingObjects

ITabSheet.ProtectScenarios

ITabSheet.Protection

ITabSheet.IsPasswordProtected

IExcelApplication.Parent

Properties

Count

int Count { get; }

Property Value

int

IsEmpty

bool IsEmpty { get; }

Property Value

bool

this[int]

IWorksheet this[int index] { get; }

Parameters

index int

Property Value

IWorksheet

Methods

Add(ITabSheet)

int Add(ITabSheet sheet)

Parameters

sheet ITabSheet

Returns

int