Interface IInternalWorksheet

Namespace

Spire.Xls.Core

Assembly

Spire.XLS.dll

public interface IInternalWorksheet : 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

DefaultPrintRowHeight

int DefaultPrintRowHeight { get; }

Property Value

int

FirstColumn

int FirstColumn { get; set; }

Property Value

int

FirstRow

int FirstRow { get; set; }

Property Value

int

LastColumn

int LastColumn { get; set; }

Property Value

int

LastRow

int LastRow { get; set; }

Property Value

int

ParentWorkbook

XlsWorkbook ParentWorkbook { get; }

Property Value

XlsWorkbook

Version

ExcelVersion Version { get; }

Property Value

ExcelVersion

Methods

GetClonedObject(Dictionary<string, string>, XlsWorkbook)

IInternalWorksheet GetClonedObject(Dictionary<string, string> hashNewNames, XlsWorkbook book)

Parameters

hashNewNames Dictionary<string, string>

book XlsWorkbook

Returns

IInternalWorksheet

IsArrayFormula(long)

bool IsArrayFormula(long index)

Parameters

index long

Returns

bool