public MonthlyReport(string financeType, int month, int year, DataTable dt) { SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY"); SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial; output = new ExcelOutput ("Report_" + financeType + "_" + year + "_" + month + ".xls"); this.workbook = new ExcelFile(); this.worksheet = workbook.Worksheets.Add("Report"); this.month = month; this.year = year; this.dt = dt; this.financeType = financeType; row = 0; worksheet.Columns[3].Width = 35 * 256; worksheet.Columns[1].Width = 15 * 256; worksheet.Columns[2].Width = 12 * 256; worksheet.Columns[1].Style.HorizontalAlignment = HorizontalAlignmentStyle.Right; }
public DateReport(string financeType, DateTime date, DataTable dt) { SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY"); SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial; output = new ExcelOutput ("Report_" + financeType + "_" + date.ToString("yyyyMMdd") + "_" + ".xls"); this.workbook = new ExcelFile(); this.worksheet = workbook.Worksheets.Add("Report"); this.date = date; this.dt = dt; this.financeType = financeType; row = 0; worksheet.Columns[3].Width = 35 * 256; worksheet.Columns[1].Width = 15 * 256; worksheet.Columns[2].Width = 12 * 256; worksheet.Columns[1].Style.HorizontalAlignment = HorizontalAlignmentStyle.Right; }