C# Class HBS.Data.Entities.TimeTracking.Infrastructure.ExcelReportHelper

Mostrar archivo Open project: heartbeatservice/HeartbeatServiceSolution

Public Methods

Method Description
AddWorksheetFooter ( StringBuilder builder ) : void
GetExcelString ( CustomTimeTrack reportObject, string reportName ) : string
GetExcelString ( DataSet dataSource ) : string

Private Methods

Method Description
AddWorkBookFooter ( StringBuilder builder ) : void
AddWorkBookHeader ( StringBuilder builder ) : void
AddWorkSheetColumn ( StringBuilder builder, DailyTimeTrack dtt, string>.Dictionary columnsToDisplay ) : void
AddWorkSheetColumn ( StringBuilder builder, DataTable dt ) : void
AddWorkSheetData ( StringBuilder builder, DataTable dt ) : void
AddWorkSheetData ( StringBuilder builder, string EmployeeName, List dttList, string>.Dictionary columnsToDisplay ) : void
AddWorkSheetHeader ( StringBuilder builder, string worksheetName ) : void
EncodeXml ( string data ) : string
GetCell ( int columnIndex, string columnValue, int rowIndex ) : string

Method Details

AddWorksheetFooter() public static method

public static AddWorksheetFooter ( StringBuilder builder ) : void
builder StringBuilder
return void

GetExcelString() public static method

public static GetExcelString ( CustomTimeTrack reportObject, string reportName ) : string
reportObject HBS.Data.Entities.TimeTracking.Models.CustomTimeTrack
reportName string
return string

GetExcelString() public static method

public static GetExcelString ( DataSet dataSource ) : string
dataSource System.Data.DataSet
return string