public ResultSet<T> ExportDataSetToExcel<T>(List<T> list, string downloadPath, string destFilename, string searchParams = "")
        {
            //创建excel 工作簿对象
            IWorkbook workbook = CreateWorkbook(downloadPath + destFilename);

            //创建excel 表对象
            ISheet sheet = CreateSheet<T>(list, searchParams, workbook);

            //写入到excel文件中
            var stream = WorkBookToMemoryStream(workbook);
            WriteSteamToFile(stream, downloadPath + destFilename);

            return new ResultSet<T> { IsSuccess = true };
        }

private IWorkbook CreateWorkbook(string templateFileName)
        {
            using (FileStream file = new FileStream(templateFileName, FileMode.Open, FileAccess.Read))
            {
                IWorkbook workbook;
                if ((templateFileName.Substring(templateFileName.LastIndexOf(".")).IndexOf("xlsx")) > 0)
                {
                    workbook = new XSSFWorkbook(file);
                }
                else
                {
                    workbook = new HSSFWorkbook(file);
                }
                return workbook;

            }

        }

private static ISheet CreateSheet<T>(List<T> list, string searchParams, IWorkbook workbook)
        {
            ISheet sheet = workbook.GetSheet("Sheet1");

            var bgRow = sheet.FirstRowNum;
            var edRow = sheet.LastRowNum;

            //插入查询条件到excel
            sheet.GetRow(2).GetCell(1).SetCellValue(searchParams);

            IRow rData = http://www.mamicode.com/sheet.GetRow(bgRow);//excel表的第一行内容>

/// <summary>
/// 转换成输出流
/// </summary>
/// <param name="InputStream"></param>
/// <returns></returns>
public static MemoryStream WorkBookToMemoryStream(IWorkbook workbook)
{
      MemoryStream file = new MemoryStream();
      workbook.Write(file);
      return file;
}

/// <summary>
/// 写入到excel文件中
/// </summary>
/// <param name="ms"></param>
/// <param name="FileName"></param>
private static void WriteSteamToFile(MemoryStream ms, string FileName)
{
      FileStream fs = new FileStream(FileName, FileMode.Create, FileAccess.Write);
      byte[] data = http://www.mamicode.com/ms.ToArray();>