Changing sheet name while exporting to CSV

See more:

C#3.5

CSV

ASP.NET4

Hi All,

I am facing a situation here where I need to change the worksheet name of CSV file. I use below code to export my grid to CSV.

StringBuilder sb = new StringBuilder();
string f_name = "GridViewExport.csv";

if (gv.Rows[i].Cells[k].Text != "" && gv.Columns[k].HeaderText == "Question")
{
    string question = gv.Rows[i].Cells[k].Text.Replace(" ", "");

    string newquestion = System.Text.RegularExpressions.Regex.Replace(question, @"\s+", " ");

    sb.Append(newquestion + ',');
}

if (gv.Rows[i].Cells[k].Text != "" && gv.Columns[k].HeaderText == "Answer")
{
    int sequence_number = Convert.ToInt32(gv.Rows[i].Cells[7].Text);
    int item_number = Convert.ToInt32(gv.Rows[i].Cells[k].Text);

    DataSet ds_interview_content = _tpsInterviewdetailManager._GetInterviewDetailBySequenceNumber(sequence_number, item_number);

    if (ds_interview_content.Tables[0].Rows.Count > 0)
    {
        string answ = ds_interview_content.Tables[0].Rows[0]["item_content"].ToString();
        sb.Append(answ + ',');
    }
}

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

//Response.Output.Write(sb.ToString());
Response.Write(sb1.ToString());
Response.Flush();
Response.End();

Actually my worksheet name is different than filename. If I give this code, then filename will be assigned to worksheet, but I don't want that.
Thanks in advance!!!