1 using System;
 2 using System.Data;
 3 using Lee.Library.Reports.Office.Excel;
 4 
 5 namespace Lee.Sample.Reports.Office.Excel
 6 {
 7     public class SampleReport : BaseReport<DataSet>
 8     {
 9         public SampleReport(DataSet ds) : base(ds) { }
10 
11         protected override void InitReport()
12         {
13             this.ReportName = @"UserInfo";
14             this.ReportSavePath = AppDomain.CurrentDomain.BaseDirectory + @"Reports\Office\Excel\";
15             this.Excel = new WorkBook(AppDomain.CurrentDomain.BaseDirectory + @"Reports\Office\Excel\UserInfo.xls", "UserInfo");
16             this.Excel.Sheets.Add(new WorkSheet("MyUserInfo"));
17             for (int i = 0; i < this.DataSource.Tables[0].Rows.Count; i++)
18             {
19                 DataRow dr = this.DataSource.Tables[0].Rows[i];
20                 this.Excel.Sheets[0].Add(new WorkCell("B" + (i + 3).ToString(), dr.Field<string>("ID")));
21                 this.Excel.Sheets[0].Add(new WorkCell("C" + (i + 3).ToString(), dr.Field<string>("NAME")));
22             }
23         }
24     }
25 }