如何从Excel文件中删除 [英] How Can I remove   from my Excel file

问题描述

我如何删除 来自我的Excel文件，它从数据视图转换为CSV ...我希望在Excel中显示空白



i将我的gridview数据转换为CSV但是在excel时是没有显示的数据

如何删除它并显示空白

How Can I remove   from my Excel file which is converted to CSV from a dataview... I want a blank in Excel instead

i am convert my gridview data to CSV but in excel when there is no data it is showing
how can i remove this and showing blank

推荐答案

在ASP.NET中将Gridview数据导出到Excel [ ^ ]

Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition",
         "attachment;filename=GridViewExport.csv");
        Response.Charset = "";
        Response.ContentType = "application/text";

        //GridSearchdetails.AllowPaging = false;
        //GridSearchdetails.DataBind();



        //now we want to write the columns headers of the table
        StringBuilder sb = new StringBuilder();
        for (int k = 0; k < GridView1.Columns.Count; k++)
        {
            //add separator
            sb.Append(GridView1.Columns[k].HeaderText + ',');
        }
        //append new line
        sb.Append("\r\n");
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            for (int k = 0; k < GridView1.Columns.Count; k++)
            {
                //add separator
                //sb.Append(GridView1.Rows[i].Cells[k].Text + ',');
                string abc = GridView1.Rows[i].Cells[k].Text;
                abc.Trim();
                if (abc == "&nbsp;")
                {
                    abc = "";
                }
                if (abc == "")
                {

                }
                sb.Append(abc + ',');
            }
            //append new line
            sb.Append("\r\n");
        }
        Response.Output.Write(sb.ToString());
        Response.Flush();
        Response.End();

这篇关于如何从Excel文件中删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！