后台代码：

public static string Export2007<T>(IList<T> sourceData)
        {
            if (sourceData =http://www.mamicode.com/= null) throw new ArgumentNullException("sourceData");>
前台代码：
            
public ActionResult ExportExecl(int? pid)
        {
            if (!pid.HasValue) return null;

            var list = _userinfoBo.GetAnswerByUser(pid.Value);

            if (null == list) return null;

            var newList = list.Select(question => new ResultExecl()
            {
              //加载数据
            }).ToList();

            var filePath = ExcelUtil.Export2007(newList);

            var fileName = Path.GetFileName(filePath);

            return File(filePath, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName);
        }


导出数据到Excel 2007 多个Sheet页(NPOI)(web版)