/// <summary>        /// 获取导出表的流.        /// </summary>        /// <param name="excelDataSource">数据源.</param>        /// <param name="sheetName">Excel名.</param>        /// <param name="stream">获取的IO流.</param>        /// <param name="summaryInfor">页面汇总信息</param>        public void GetExportExcelStream(IList<CustomerAuth> excelDataSource, string sheetName, System.IO.Stream stream, Core.Domain.Excel.SummaryInfor summaryInfor = null)        {            if (stream == null)                throw new ArgumentNullException("stream");            using (var xlPackage = new ExcelPackage(stream))            {                var worksheet = xlPackage.Workbook.Worksheets.Add(sheetName);                                // Excel表的列名                var properties = new string[]                {                    "注册号",                    "手机号",                    "姓名",                    "身份证号",                    "注册来源",                    "认证时间",                    "注册时间"                };                // 设置第一行的样式                for (int i = 0; i < properties.Length; i++)                {                    worksheet.Cells[1, i + 1].Value =http://www.mamicode.com/ properties[i];                    worksheet.Cells[1, i + 1].Style.Fill.PatternType = ExcelFillStyle.Solid;                    worksheet.Cells[1, i + 1].Style.Fill.BackgroundColor.SetColor(Color.FromArgb(184, 204, 228));                    worksheet.Cells[1, i + 1].Style.Font.Bold = true;                }                int row = 2;                foreach (var excelItem in excelDataSource)                {                    int col = 1;                    // 注册号                    worksheet.Cells[row, col].Value =http://www.mamicode.com/ excelItem.RegNumber;                    col++;                    // 手机号                    worksheet.Cells[row, col].Value =http://www.mamicode.com/ excelItem.Phone;                    col++;                    // 姓名                    worksheet.Cells[row, col].Value =http://www.mamicode.com/ excelItem.Name;                    col++;                    // 身份证号                    worksheet.Cells[row, col].Value =http://www.mamicode.com/ excelItem.CardId;                    col++;                    // 注册来源                    worksheet.Cells[row, col].Value =http://www.mamicode.com/ excelItem.Source;                    col++;                    // 认证时间                    worksheet.Cells[row, col].Value =http://www.mamicode.com/ excelItem.AuthDate;                    col++;                    // 注册时间                    worksheet.Cells[row, col].Value =http://www.mamicode.com/ excelItem.RegDate;                    col++;                    row++;                }                worksheet.Cells.AutoFitColumns(0);  // 设置为自动宽度                xlPackage.Save();            }        }