Method | Description | |
---|---|---|
AddHeaderRow ( List |
Write a New Header Row - Sets the Header Row of the current sheet to the row specified
|
|
AddNewRow ( ) : |
||
AddNewSheet ( string sheetName ) : void | ||
AddNewSheet ( string sheetName, int position ) : void | ||
ApplyFilter ( string columnName, string filterString ) : void |
Filter Row Collection on a specific Column
|
|
Create ( string path ) : |
Creates a new Excel Workbook
|
|
Create ( string path, bool overwrite ) : |
Creates a new Excel Workbook - Overwrites Existing File
|
|
CreateOrOpen ( string path ) : |
Checks to see if document exists - creates if not - opens if it does exist
|
|
InsertNewRow ( int rowNumber ) : |
||
Open ( string path ) : |
Open an Existing xls file for Reading and Modfification
|
|
Save ( ) : void | ||
SaveAs ( string path ) : void | ||
SaveToMemoryStream ( ) : Stream | ||
SetActiveSheet ( IXLWorksheet sheet, int headerRowNum = 1, bool noHeaderRow = false ) : void | ||
SetActiveSheet ( int sheetNum, int headerRowNum = 1, bool noHeaderRow = false ) : void | ||
SetActiveSheet ( string sheetName, int headerRowNum = 1, bool noHeaderRow = false ) : void | ||
WriteToCell ( string CellID, object Value ) : void | ||
WriteToHttpResponse ( string fileName ) : void | ||
XLSWorker ( ) : System |
public AddHeaderRow ( List |
||
colNames | List |
|
rowNum | int | |
return | void |
public AddNewSheet ( string sheetName ) : void | ||
sheetName | string | |
return | void |
public AddNewSheet ( string sheetName, int position ) : void | ||
sheetName | string | |
position | int | |
return | void |
public ApplyFilter ( string columnName, string filterString ) : void | ||
columnName | string | |
filterString | string | |
return | void |
public static Create ( string path ) : |
||
path | string | |
return |
public static Create ( string path, bool overwrite ) : |
||
path | string | |
overwrite | bool | |
return |
public static CreateOrOpen ( string path ) : |
||
path | string | |
return |
public InsertNewRow ( int rowNumber ) : |
||
rowNumber | int | |
return |
public static Open ( string path ) : |
||
path | string | |
return |
public SetActiveSheet ( IXLWorksheet sheet, int headerRowNum = 1, bool noHeaderRow = false ) : void | ||
sheet | IXLWorksheet | |
headerRowNum | int | |
noHeaderRow | bool | |
return | void |
public SetActiveSheet ( int sheetNum, int headerRowNum = 1, bool noHeaderRow = false ) : void | ||
sheetNum | int | |
headerRowNum | int | |
noHeaderRow | bool | |
return | void |
public SetActiveSheet ( string sheetName, int headerRowNum = 1, bool noHeaderRow = false ) : void | ||
sheetName | string | |
headerRowNum | int | |
noHeaderRow | bool | |
return | void |
public WriteToCell ( string CellID, object Value ) : void | ||
CellID | string | |
Value | object | |
return | void |
public WriteToHttpResponse ( string fileName ) : void | ||
fileName | string | |
return | void |