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

Show file 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