RMS.Common/Tools/ExportExcelResult.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Web;
using System.Web.Mvc;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using System.Data;
using System.IO;
using System.Collections.Generic;

namespace RMS.Common
{
    public class ExportExcelResult : ActionResult
    {
        #region 构造函数
        /// <summary>
        /// 导出Excel的Result
        /// </summary>
        /// <param name="data">数据</param>
        public ExportExcelResult(IEnumerable<Object> data)
            : this(data, "")
        {
            DateTime time = DateTime.Now;
            this.FileName = string.Format("{0}_{1}_{2}_{3}",
                time.Month, time.Day, time.Hour, time.Minute);
        }
        /// <summary>
        /// 导出Excel的Result
        /// </summary>
        /// <param name="data">数据</param>
        /// <param name="fileName">文件名</param>
        public ExportExcelResult(IEnumerable<Object> data, string fileName)
            : this(data, fileName, null)
        {
            this.TitleFormater = p => p;
        }
        /// <summary>
        /// 导出Excel的Result
        /// </summary>
        /// <param name="data">数据</param>
        /// <param name="fileName">文件名</param>
        /// <param name="titleFormater">标题格式化</param>
        public ExportExcelResult(IEnumerable<Object> data, string fileName, Func<string, string> titleFormater)
        {
            this.Data = data;
            this.FileName = fileName;
            this.TitleFormater = titleFormater;
        } 
        #endregion

        #region 属性
        /// <summary>
        /// 数据
        /// </summary>
        public IEnumerable<Object> Data
        {
            get;