C# Class ExportToExcel, code

Class for generator of Excel file
Mostrar archivo 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