Class Worksheet

Namespace

FileFormat.Cells

Assembly

FileFormat.Cells.dll

public sealed class Worksheet

Inheritance

object

Worksheet

Inherited Members

object.GetType()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Fields

DefaultColumnWidth

public const double DefaultColumnWidth = 8.43

Field Value

double

DefaultRowHeight

public const double DefaultRowHeight = 15

Field Value

double

Properties

Cells

public CellIndexer Cells { get; }

Property Value

CellIndexer

Name

public string Name { get; set; }

Property Value

string

Methods

AddComment(string, Comment)

public void AddComment(string cellReference, Comment comment)

Parameters

cellReference string

comment Comment

AddDropdownListValidation(string, string[])

public void AddDropdownListValidation(string cellReference, string[] options)

Parameters

cellReference string

options string[]

AddImage(Image, int, int, int, int)

public void AddImage(Image image, int startRowIndex, int startColumnIndex, int endRowIndex, int endColumnIndex)

Parameters

image Image

startRowIndex int

startColumnIndex int

endRowIndex int

endColumnIndex int

ApplyValidation(string, ValidationRule)

public void ApplyValidation(string cellReference, ValidationRule rule)

Parameters

cellReference string

rule ValidationRule

ExtractImages()

public List<Image> ExtractImages()

Returns

List<Image>

GetCell(string)

public Cell GetCell(string cellReference)

Parameters

cellReference string

Returns

Cell

GetColumnCount()

public int GetColumnCount()

Returns

int

GetColumnWidth(uint)

public double GetColumnWidth(uint columnIndex)

Parameters

columnIndex uint

Returns

double

GetRange(string, string)

public Range GetRange(string startCellReference, string endCellReference)

Parameters

startCellReference string

endCellReference string

Returns

Range

GetRange(uint, uint, uint, uint)

public Range GetRange(uint startRowIndex, uint startColumnIndex, uint endRowIndex, uint endColumnIndex)

Parameters

startRowIndex uint

startColumnIndex uint

endRowIndex uint

endColumnIndex uint

Returns

Range

GetRowCount()

public int GetRowCount()

Returns

int

GetRowHeight(uint)

public double GetRowHeight(uint rowIndex)

Parameters

rowIndex uint

Returns

double

GetSheetIndex()

public int GetSheetIndex()

Returns

int

GetValidationRule(string)

public ValidationRule GetValidationRule(string cellReference)

Parameters

cellReference string

Returns

ValidationRule

HideColumn(string)

public void HideColumn(string columnName)

Parameters

columnName string

HideRow(uint)

public void HideRow(uint rowIndex)

Parameters

rowIndex uint

HideRows(uint, uint)

public void HideRows(uint startRowIndex, uint numberOfRows)

Parameters

startRowIndex uint

numberOfRows uint

InsertColumn(string)

public void InsertColumn(string startColumn)

Parameters

startColumn string

InsertColumns(string, int)

public void InsertColumns(string startColumn, int numberOfColumns)

Parameters

startColumn string

numberOfColumns int

InsertRow(uint)

public void InsertRow(uint rowIndex)

Parameters

rowIndex uint

InsertRows(uint, uint)

public void InsertRows(uint startRowIndex, uint numberOfRows)

Parameters

startRowIndex uint

numberOfRows uint

IsColumnHidden(string)

public bool IsColumnHidden(string columnName)

Parameters

columnName string

Returns

bool

IsProtected()

public bool IsProtected()

Returns

bool

IsRowHidden(uint)

public bool IsRowHidden(uint rowIndex)

Parameters

rowIndex uint

Returns

bool

MergeCells(string, string)

public void MergeCells(string startCellReference, string endCellReference)

Parameters

startCellReference string

endCellReference string

ProtectSheet(string)

public void ProtectSheet(string password)

Parameters

password string

SetColumnWidth(string, double)

public void SetColumnWidth(string columnName, double width)

Parameters

columnName string

width double

SetRowHeight(uint, double)

public void SetRowHeight(uint rowIndex, double height)

Parameters

rowIndex uint

height double

UnhideColumn(string)

public void UnhideColumn(string columnName)

Parameters

columnName string

UnhideColumns(string, int)

public void UnhideColumns(string startColumn, int numberOfColumns)

Parameters

startColumn string

numberOfColumns int

UnhideRow(uint)

public void UnhideRow(uint rowIndex)

Parameters

rowIndex uint

UnhideRows(uint, uint)

public void UnhideRows(uint startRowIndex, uint numberOfRows)

Parameters

startRowIndex uint

numberOfRows uint

UnprotectSheet()

public void UnprotectSheet()