C# Class SympleLib.OpenXml.XLSWorker

Public Methods

Method	Description
AddHeaderRow ( List colNames, int rowNum ) : void	Write a New Header Row - Sets the Header Row of the current sheet to the row specified
AddNewRow ( ) : XLSRow
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 ) : XLSWorker	Creates a new Excel Workbook
Create ( string path, bool overwrite ) : XLSWorker	Creates a new Excel Workbook - Overwrites Existing File
CreateOrOpen ( string path ) : XLSWorker	Checks to see if document exists - creates if not - opens if it does exist
InsertNewRow ( int rowNumber ) : XLSRow
Open ( string path ) : XLSWorker	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

Write a New Header Row - Sets the Header Row of the current sheet to the row specified

public AddHeaderRow ( List colNames, int rowNum ) : void
colNames	List
rowNum	int
return	void

public AddNewRow ( ) : XLSRow
return	XLSRow

public AddNewSheet ( string sheetName ) : void
sheetName	string
return	void

public AddNewSheet ( string sheetName, int position ) : void
sheetName	string
position	int
return	void

Filter Row Collection on a specific Column

public ApplyFilter ( string columnName, string filterString ) : void
columnName	string
filterString	string
return	void

Creates a new Excel Workbook

public static Create ( string path ) : XLSWorker
path	string
return	XLSWorker

Creates a new Excel Workbook - Overwrites Existing File

public static Create ( string path, bool overwrite ) : XLSWorker
path	string
overwrite	bool
return	XLSWorker

Checks to see if document exists - creates if not - opens if it does exist

public static CreateOrOpen ( string path ) : XLSWorker
path	string
return	XLSWorker

public InsertNewRow ( int rowNumber ) : XLSRow
rowNumber	int
return	XLSRow

Open an Existing xls file for Reading and Modfification

public static Open ( string path ) : XLSWorker
path	string
return	XLSWorker

public Save ( ) : void
return	void

public SaveAs ( string path ) : void
path	string
return	void

public SaveToMemoryStream ( ) : Stream
return	Stream

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

public XLSWorker ( ) : System
return	System