C#通过Excel导出用户信息

ゝ一纸荒年。 2021-09-12 05:44 330阅读 0赞

很多的Web后台管理系统都可以已Excel的形式将网站中数据导出，方便管理员处理数据。

下面已在.net网页中导出用户信息为例。

1、创建Web页面，如：OutputExcel.aspx

2、创建用户信息实体类

/// <summary>
    /// 用户信息实体类
    /// </summary>
    public class UserInfo {
        public int UserId { get; set; }
        public string UserName { get; set; }
        public string Address { get; set; }
    }

3、获取用户信息

/// <summary>
    /// 获取用户信息
    /// </summary>
    /// <returns></returns>
    public List<UserInfo> GetUserInfoList()
    {
        List<UserInfo> userList = new List<UserInfo>();
    
        UserInfo user1 = new UserInfo() { 
            UserId = 1,
            UserName ="张三",
            Address="广东深圳"
        };
    
        UserInfo user2 = new UserInfo()
        {
            UserId = 2,
            UserName = "李四",
            Address = "山西太原"
        };
    
        UserInfo user3 = new UserInfo()
        {
            UserId = 3,
            UserName = "王五",
            Address = "湖南长沙"
        };
    
        userList.Add(user1);
        userList.Add(user2);
        userList.Add(user3);
    
        return userList;
    }

3、生成和导出CSV文件

protected void Page_Load(object sender, EventArgs e)
    {
        //获取用户信息列表
        List<UserInfo> userList = GetUserInfoList();
        if (userList != null && userList.Count > 0)
        {
            #region 生成CSV
    
            Response.Clear();
            Response.ContentType = "application/vnd.ms-excel";
            Response.ContentEncoding = System.Text.Encoding.Default;
    
            string fileName = "用户信息";
            Response.AddHeader("content-disposition", "attachment; filename=" + fileName + ".csv");
    
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.AppendLine("用户ID,用户名,地址");
            foreach (UserInfo item in userList)
            {
                System.Text.StringBuilder rowBuilder = new System.Text.StringBuilder();
                rowBuilder.Append(item.UserId.ToString() + ",");
                rowBuilder.Append(item.UserName + ",");
                rowBuilder.Append(item.Address + ",");
                sb.AppendLine(rowBuilder.ToString());
            }
            //输出
            Response.Write(sb.ToString());
            Response.End();
            #endregion
    
        }
    }