欢迎使用优快云-markdown编辑器

最新推荐文章于 2021-01-07 23:01:28 发布

原创最新推荐文章于 2021-01-07 23:01:28 发布 · 348 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#c#导出到excel

欢迎使用Markdown编辑器写博客

本Markdown编辑器使用StackEdit修改而来，用它写博客，将会带来全新的体验哦：

//protected void txtout_Click(object sender, EventArgs e)
//{
// Response.Clear();
// Response.Buffer = true;
// Response.Charset = “utf-8”;
// Response.AppendHeader(“Content-Disposition”, “attachment;filename=” + System.Web.HttpUtility.UrlEncode(“叶片结构信息” + System.DateTime.Now.ToString(“yyyyMMddHHmmss”)) + “.xls”);
// Response.ContentEncoding = System.Text.Encoding.GetEncoding(“GB2312”);//设置输出流为简体中文

//    Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。

//    string strHeaders = "", strItems = "";
//    //strHeaders += "检测次数" + "\n" + "取样时间 " + "\n" + "单位 " + "\n" + "叶片总重 " + "\n" + "≥25.4mm" + "\n"  + "12.7-25.4mm" + "\n" + "≥12.7mm " + "\n" + "6.35-12.7mm" + "\n" + "≥6.35mm " + "\n" + "3.18-6.35mm " + "\n" + "≥3.18mm" + "\n" + "≤3.18mm " + "\n" + "总梗重 " + "\n" + "叶中含梗 " + "\n" + "OBJ " + "\n" + "梗重 " + "\n" + "叶重" + "\n" + "≥20mm烟梗 " + "\t";
//    //strHeaders += "检测次数" + "\t" + "取样时间 " + "\t" + "单位 " + "\t" + "叶片总重 " + "\t" + "≥25.4mm" + "\t" + "12.7-25.4mm" + "\t" + "≥12.7mm " + "\t" + "6.35-12.7mm" + "\t" + "≥6.35mm " + "\t" + "3.18-6.35mm " + "\t" + "≥3.18mm" + "\t" + "≤3.18mm " + "\t" + "总梗重 " + "\t" + "叶中含梗 " + "\t" + "OBJ " + "\t" + "梗重 " + "\t" + "叶重" + "\t" + "≥20mm烟梗 " + "\n";
//    strHeaders += "检测次数" + "\t" + "取样时间 " + "\t" + "叶片总重 " + "\t" + "≥25.4mm重量" + "\t" + "≥25.4mm比率 " + "\t" + "12.7-25.4mm" + "\t" + "12.7-25.4mm比率" + "\t" + "≥12.7mm " + "\t" + "≥12.7mm比率 " + "\t" + "6.35-12.7mm" + "\t" + "6.35-12.7mm" + "\t" + "≥6.35mm " + "\t" + "≥6.35mm比率 " + "\t" + "3.18-6.35mm " + "\t" + "3.18-6.35mm比率 " + "\t" + "≥3.18mm" + "\t" + "≥3.18mm比率" + "\t" + "≤3.18mm " + "\t" + "≤3.18mm 比率" + "\t" + "总梗重 " + "\t" + "叶中含梗 " + "\t" + "叶中含梗比率 " + "\t" + "OBJ " + "\t" + "OBJ比率 " + "\t" + "梗重 " + "\t" + "叶重" + "\t" + "叶重比率" + "\t" + "≥20mm烟梗 " + "\t" + "≥20mm烟梗比率 " + "\n";

//    //int iColumns = gvPieceStem.Columns.Count;

//    ////获取标题行信息
//    //for (int i = 1; i < gvPieceStem.Columns.Count; i++)
//    //{
//    //    if (i == iColumns - 1)
//    //    {
//    //        strHeaders += gvPieceStem.Columns[i].HeaderText + "\n";
//    //    }
//    //    else
//    //    {
//    //        strHeaders += gvPieceStem.Columns[i].HeaderText + "\t";

//    //    }
//    //}
//    //Page.ClientScript.RegisterStartupScript(this.GetType(), "MyScript", " Response.Write(strHeaders)");

//    Response.Write(strHeaders);
//    /*
//    //获取数据值
//    foreach (GridViewRow row in gvStoreInfo.Rows)
//    {
//        for (int i = 1; i < iColumns; i++)
//        {
//            if (i == iColumns - 1)
//            {
//                strItems += row.Cells[i].Text + "\n";
//            }
//            else
//            {
//                strItems += row.Cells[i].Text + "\t";
//            }
//        }
//        strItems = strItems.Replace("&nbsp;", "");
//        Response.Write(strItems);
//        strItems = "";
//    }
//    */
//    //获取储柜信息

//    //List<Entity.QualManage.PieceStem> list1 = SelectRows();
//    //string word = list1[0].WorkOrderID;
//    string word = ViewState["SelectedWOID"].ToString();
//    List<Entity.QualManage.PieceStem> list = bllPS.GetexcelInfo(word);
//    int  num = list.Count;
//    int no = num / 10;
//    for (int i = 1; i < num; i+=10) {
//        string de = list[i -1].DetectProp.ToString();
//        string ded = list[i-1].SampleWt.ToString();
//        string deeed = list[i ].DetectProp.ToString();
//        string deed = list[i ].SampleWt.ToString();
//        Response.Write(ded);
//    }
//    string time = list[0].DetectTime;
//    string wt = list[0].SampleTotalWt.ToString ();
//    string a = list[0].DetectProp.ToString ();
//    string aa = list[0].SampleWt.ToString();
//    string b = list[1].DetectProp.ToString();
//    string bb = list[1].SampleWt.ToString();
//    string cc = list[2].SampleWt.ToString();
//    string c = list[2].DetectProp.ToString ();
//    string d = list[3].DetectProp.ToString();
//    string dd = list[3].SampleWt.ToString();
//    string ee = list[4].DetectProp.ToString();
//    string eee = list[4].SampleWt.ToString();
//    string f = list[5].DetectProp.ToString();
//    string ff = list[5].SampleWt.ToString();
//    string g = list[6].DetectProp.ToString();
//    string gg = list[6].SampleWt .ToString();
//    string hh = list[7].SampleWt.ToString();
//    string h = list[7].DetectProp.ToString();
//    //strItems += "\t" + time + "\t" + "g/%" + "\t" + wt + "\t" + aa +"/"+ a + "\t" + bb +"/" +b + "\t" + cc +"/"+ c + "\t" + dd +"/"+ d + "\t" + eee + "/"+ee + "\t" + ff +"/"+ f + "\t" + hh +"/"+ h + "\t" + gg + g + "\n";
//    //int iColumns = gvPieceStem.Columns.Count;
//    strItems += "\t" + time + "\t"  + wt + "\t" + aa + "\t" + a + "\t" + bb + "\t" + b + "\t" + cc + "\t" + c + "\t" + dd + "\t" + d + "\t" + eee + "\t" + ee + "\t" + ff + "\t" + f + "\t" + hh + "\t" + h + "\t" + gg +"\t"+ g + "\n";
//     //string str = "";
//    //str += "项目"+"\t"+"检测次数"+"\t"+"1"+"\n";
//    //Response.Write(str);
//    //str += "项目" + "\t" + "取样时间" + "\t" + time + "\n";
//    //Response.Write(str);
//    //str += "项目" + "\t" + "取样时间" + "\t" + time + "\n";
//    //strItems  += a + "/t" + b + "/n" + c + "/t" + d + "/n" + ee + "/n" + f + "/n" + g + "/n" + h + "/n";
//    Response.Write(strItems);
//    //foreach (Entity.QualManage.PieceStem entity in list)
//    //{
//    //    //lyx 20140928 修改 批次号改为18位以后，导出Excel，只能保存15位数字格式。应尤工要求，此处将批次号进行截取，只保留后4位
//    //    //strItems = entity.SlotId + "\t" + entity.SlotName + "\t" + entity.MaterialName + "\t" + entity.SortName + "\t" + (entity.BatchID.Length > 14 ? entity.BatchID.Substring(14) : entity.BatchID) + "\t" + entity.InEndTime + "\t"
//    //    //        + entity.OutStartTime + "\t" + entity.CurrentStoreWt + "\t" + entity.StoreTime + "\t" + entity.RunState + "\t" + entity.EquipmentState + "\n";
//    //    strItems = "\t" + "\t" + entity.SampleTotalWt + "\t" + entity.DetectProp + "\n";
//    //    Response.Write(strItems);
//    //    strItems = "";
//    //}

//    Response.End();


//}--------------

快捷键

加粗 Ctrl + B
斜体 Ctrl + I
引用 Ctrl + Q
插入链接 Ctrl + L
插入代码 Ctrl + K
插入图片 Ctrl + G
提升标题 Ctrl + H
有序列表 Ctrl + O
无序列表 Ctrl + U
横线 Ctrl + R
撤销 Ctrl + Z
重做 Ctrl + Y

Markdown及扩展

Markdown 是一种轻量级标记语言，它允许人们使用易读易写的纯文本格式编写文档，然后转换成格式丰富的HTML页面。 —— [ 维基百科 ]

使用简单的符号标识不同的标题，将某些文字标记为粗体或者斜体，创建一个链接等，详细语法参考帮助？。

本编辑器支持 Markdown Extra , 　扩展了很多好用的功能。具体请参考Github.

表格

Markdown　Extra　表格语法：

项目	价格
Computer	$1600
Phone	$12
Pipe	$1

可以使用冒号来定义对齐方式：

项目	价格	数量
Computer	1600 元	5
Phone	12 元	12
Pipe	1 元	234

定义列表

Markdown　Extra　定义列表语法：项目１项目２

定义 A

定义 B

项目３

定义 C

定义 D

定义D内容

代码块

代码块语法遵循标准markdown代码，例如：

@requires_authorization
def somefunc(param1='', param2=0):
    '''A docstring'''
    if param1 > param2: # interesting
        print 'Greater'
    return (param2 - param1 + 1) or None
class SomeClass:
    pass
>>> message = '''interpreter
... prompt'''