• asp.net 导出 Excel


    /// <summary>
        /// List 数据导出Excel
        /// </summary>
        /// <param name="list">数据集合</param>
        /// <param name="filename">文件名 不用加 .xls</param>
        /// <param name="ColumNames">标题名(数组-所有标题)</param>
        public void HtmlToExcel(数据 list, string filename, string[] ColumNames)
        {
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=" + filename + ".xls");
            Response.Charset = "gb2312";
            Response.ContentType = "application/vnd.xls";
            //拼接数据结构
            string xls = @"<Table border='1'><TR>";
            int i;
            int j;
            //标题
            for (i = 0; i < ColumNames.Length; i++)
            {
                xls += @"<TD>" + ColumNames[i] + @"</TD>";
            }
            xls = xls + @"</TR>";
            //内容
            for (j = 0; j < list.Count(); j++)
            {
                xls = xls + @"<TR>";
                xls = xls + @"<TD>" + list[j].字段一对应的字段 + "&nbsp;" + @"</TD>";
                xls = xls + @"<TD>" + list[j].字段二对应的字段 + "&nbsp;" + @"</TD>";
                xls = xls + @"<TD>" + list[j].字段三对应的字段 + "&nbsp;" + @"</TD>";
                xls = xls + @"<TD>" + list[j].字段四对应的字段 + "&nbsp;" + @"</TD>";
                xls = xls + @"<TD>" + list[j].字段五对应的字段+ "&nbsp;" + @"</TD>";
                xls = xls + @"<TD>" + list[j].字段六对应的字段 + "&nbsp;" + @"</TD>";
             
              
            xls = xls + @"</Table>";
            Response.Write(xls);    //stringWrite.ToString());
            Response.End();
        }
    //调用
    
    string[] ColumNames = new string[] { "字段一", "字段二", "字段三", "字段四", "字段五", "字段六" };
            HtmlToExcel(数据, "文件名称", ShowNames);
  • 相关阅读:
    [转]学习NotesList(Robotium自带的例子)
    [转] Android Test Auto Test Multi Activities
    [转]重新签名Android preinstall APK
    [转]简单介绍如何使用robotium进行自动化测试
    javascript bind函数
    IE中不可遍历的属性
    访问私有变量
    高效地获取XMLhttp对象
    判定IE的各个版本
    CSS Selector の最大の欠点
  • 原文地址:https://www.cnblogs.com/wrq6/p/9101561.html
Copyright © 2020-2023  润新知