Interface IExcelSheetWriter
Namespace: Casewhere.Runtime.IO
Assembly: Casewhere.Runtime.IO.dll
public interface IExcelSheetWriter
Extension Methods
ObjectExtension.ConvertToBsonValue(object), EnumExtensions.DeepClone<IExcelSheetWriter>(IExcelSheetWriter)
Methods
FreezePanes(int, int)
Freeze some rows and columns given.
void FreezePanes(int row, int col)
Parameters
row int
The number of rows frozen.
col int
The number of column frozen.
GetCell(int, int)
Get a cell at the given position.
IExcelCellWriter GetCell(int row, int column)
Parameters
row int
The index of a row.
column int
The index of a column.
Returns
An excel cell writer.
GetLastColumn()
Get the last column of the current sheet.
int GetLastColumn()
Returns
GetLastRow()
Get the last row of the current sheet.
int GetLastRow()
Returns
GetRange(int, int, int, int)
Get a range of cells.
IExcelCellWriter GetRange(int start, int startCol, int end, int endCol)
Parameters
start int
startCol int
end int
endCol int
Returns
SetName(string)
Set the name of the current sheet.
void SetName(string name)
Parameters
name string
The sheet name.
Write(int, int, object)
Write the value to a cell at the given position.
void Write(int row, int column, object value)
Parameters
row int
The index of a row.
column int
The index of a colunn.
value object
The value assigned to the cell.