Struct ExcelWorksheet

Namespace

The.Office

Assembly

Instagile.Office.dll

public struct ExcelWorksheet

Inherited Members

ValueType.Equals(object)

ValueType.GetHashCode()

ValueType.ToString()

object.Equals(object, object)

object.GetType()

object.ReferenceEquals(object, object)

Constructors

ExcelWorksheet(ExcelSpreadsheet, uint)

public ExcelWorksheet(ExcelSpreadsheet spreadsheet, uint sheetId)

Parameters

spreadsheet ExcelSpreadsheet

sheetId uint

Fields

SheetId

public uint SheetId

Field Value

uint

Spreadsheet

public ExcelSpreadsheet Spreadsheet

Field Value

ExcelSpreadsheet

Methods

CopyRow(long, long)

public void CopyRow(long fromRow, long toRow)

Parameters

fromRow long

toRow long

Delete()

public void Delete()

ExtendConditionalFormattingTo(int, long)

public void ExtendConditionalFormattingTo(int column, long row)

Parameters

column int

row long

MergeRange(int, long, int, long)

public void MergeRange(int startColumn, long startRow, int endColumn, long endRow)

Parameters

startColumn int

startRow long

endColumn int

endRow long

SetCellStyle(int, long, uint)

public void SetCellStyle(int column, long row, uint styleIndex)

Parameters

column int

row long

styleIndex uint

SetColumnWidth(int, double)

public ExcelWorksheet SetColumnWidth(int column, double excelWidth)

Parameters

column int

excelWidth double

Returns

ExcelWorksheet

SetColumnWidthInPixels(int, int)

public ExcelWorksheet SetColumnWidthInPixels(int column, int widthInPixels)

Parameters

column int

widthInPixels int

Returns

ExcelWorksheet

SetName(string)

public ExcelWorksheet SetName(string name)

Parameters

name string

Returns

ExcelWorksheet

SetRowHeight(long, double)

public ExcelWorksheet SetRowHeight(long row, double excelHeight)

Parameters

row long

excelHeight double

Returns

ExcelWorksheet

SetRowHeightInPixels(long, int)

public ExcelWorksheet SetRowHeightInPixels(long row, int heightInPixels)

Parameters

row long

heightInPixels int

Returns

ExcelWorksheet

UnmergeRange(int, long, int, long)

public void UnmergeRange(int startColumn, long startRow, int endColumn, long endRow)

Parameters

startColumn int

startRow long

endColumn int

endRow long

UpdateCell(int, long, DateTime, uint?)

public void UpdateCell(int column, long row, DateTime value, uint? styleIndex = null)

Parameters

column int

row long

value DateTime

styleIndex uint?

UpdateCell(int, long, decimal, uint?)

public void UpdateCell(int column, long row, decimal value, uint? styleIndex = null)

Parameters

column int

row long

value decimal

styleIndex uint?

UpdateCell(int, long, int, uint?)

public void UpdateCell(int column, long row, int value, uint? styleIndex = null)

Parameters

column int

row long

value int

styleIndex uint?

UpdateCell(int, long, long, uint?)

public void UpdateCell(int column, long row, long value, uint? styleIndex = null)

Parameters

column int

row long

value long

styleIndex uint?

UpdateCell(int, long, string, uint?)

public void UpdateCell(int column, long row, string value, uint? styleIndex = null)

Parameters

column int

row long

value string

styleIndex uint?