C# Class ExportToExcel, code

Class for generator of Excel file

显示文件 Open project: shendongnian/code Class Usage Examples

Public Methods

Method	Description
ExportTable ( string procName, string sheetName ) : void
ExportToExcel ( string folder )
SaveWorkbook ( ) : void
addData ( Microsoft.Office.Interop.Excel.Worksheet worksheet, int row, int col, string data ) : void
createHeaders ( Microsoft.Office.Interop.Excel.Worksheet worksheet, int row, int col, string htext ) : void
shutDown ( ) : void

Private Methods

Method	Description
createDoc ( ) : void

Method Details

ExportTable() public method

public ExportTable ( string procName, string sheetName ) : void
procName	string
sheetName	string
return	void

ExportToExcel() public method

public ExportToExcel ( string folder )
folder	string

SaveWorkbook() public method

public SaveWorkbook ( ) : void
return	void

addData() public method

public addData ( Microsoft.Office.Interop.Excel.Worksheet worksheet, int row, int col, string data ) : void
worksheet	Microsoft.Office.Interop.Excel.Worksheet
row	int
col	int
data	string
return	void

createHeaders() public method

public createHeaders ( Microsoft.Office.Interop.Excel.Worksheet worksheet, int row, int col, string htext ) : void
worksheet	Microsoft.Office.Interop.Excel.Worksheet
row	int
col	int
htext	string
return	void

shutDown() public method

public shutDown ( ) : void
return	void