Exporting DataGridview To Excel

Code Works on Net 3.5, great work...

// Export data.
            for (int i = 0; i < dGV.RowCount - 1; i++)

IList<DummyPerson> dummyPeople = new List<DummyPerson>();
//Add data to dummyPeople...
IExportEngine engine = new ExcelExportEngine();
engine.AddData(dummyPeople);
MemoryStream memory = engine.Export();

private void ToCsV(DataGridView dGV, string filename)
        {
            StringBuilder stOutput = new StringBuilder();
            // Export titles:
            string sHeaders = "";

            for (int j = 0; j < dGV.Columns.Count; j++)
                sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator;
            stOutput.Append(sHeaders + "\r\n");
            // Export data.
            for (int i = 0; i < dGV.RowCount - 1; i++)
            {
                //string stLine = "";
                for (int j = 0; j < dGV.Rows[i].Cells.Count; j++)
                {
                    if (dGV[j, i] is DataGridViewImageCell)
                    {
                        stOutput.AppendFormat("\"{0}\"", Convert.ToString(dGV.Rows[i].Cells[j].Tag));
                    }
                    else
                    {
                        stOutput.AppendFormat("\"{0}\"", Convert.ToString(dGV.Rows[i].Cells[j].Value));
                    }
                    stOutput.Append(System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator);

                }
                stOutput.Append("\r\n");
            }
            Encoding utf16 = Encoding.GetEncoding(1254);
            byte[] output = utf16.GetBytes(stOutput.ToString());
            FileStream fs = new FileStream(filename, FileMode.Create);
            BinaryWriter bw = new BinaryWriter(fs);
            bw.Write(output, 0, output.Length); //write the encoded file
            bw.Flush();
            bw.Close();
            fs.Close();
        }

// I tidied the code a little:
// Firstly, if you have a DataGridView instance already, the function can be declared static.
// Secondly, "" should be referenced to the string.Empty field rather than creating a new empty string.
// Thirdly, rather than using a constant \r\n, use Environment.NewLine to be less platform dependent. 
// I also changed the Encoding to ASCII and tabs to commas to better fit the CSV de-facto standard of RFC 4180. Titles and values can be wrapped in quotes. I did this in case headers contained unparsable characters such as commas.
// I renamed some variables for readability.
// And finally use usings to make sure the Streams are disposed properly in case of an exception.
public static void SaveAsCSV(DataGridView dgv, string filename)
{
  string outputStr = string.Empty;
  string headersStr = string.Empty;

  for (int col = 0; col < dgv.Columns.Count; col++)
  {
    headersStr += '\"' + dgv.Columns[col].HeaderText + "\","; // "header",
  }
  outputStr += headersStr + Environment.NewLine; // "header1","header2",[...],CRLF

  for (int row = 0; row < dgv.RowCount - 1; row++)
  {
    string line = string.Empty;
    for (int cell = 0; cell < dgv.Rows[row].Cells.Count; cell++)
    {
      line += '\"' + Convert.ToString(dgv.Rows[row].Cells[cell].Value) + "\","; // "cellvalue",
    }
    outputStr += line + Environment.NewLine; // "cellvalue1","cellvalue2",[...],CRLF
  }

  byte[] output = Encoding.ASCII.GetBytes(outputStr);
  using (FileStream fs = new FileStream(filename, FileMode.Create))
  {
    using (BinaryWriter bw = new BinaryWriter(fs))
    {
      bw.Write(output, 0, output.Length);
      bw.Flush();
    }
  }
}  

for (int i = 0; i < dGV.RowCount - 1; i++)
            {
                string stLine = "";
                for (int j = 0; j < dGV.Rows[i].Cells.Count; j++)
                    stLine = stLine.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + "\t";
                stOutput += stLine + "\r\n";
            }

for (int i = 0; i < dGV.RowCount ; i++)
            {
                string stLine = "";
                for (int j = 0; j < dGV.Rows[i].Cells.Count; j++)
                    stLine = stLine.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + "\t";
                stOutput += stLine + "\r\n";
            }

protected void btnExport_Click(object sender, EventArgs e)
    {
        try
        {
            string strReport = "_Details_" + ".xls";
            ExportDataGrid(dgDetails, strReport);
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

public void ExportDataGrid(DataGrid oGrid, string exportFile)
    {
        try
        {
            //Clear the response, and set the content type and mark as attachment
            Response.ClearContent();
            Response.AddHeader("content-disposition", "attachment; filename=\"" + exportFile + "\"");
            Response.ContentType = "application/excel";

            //Clear the character set
            Response.Charset = "";

                    
            //Create a string and Html writer needed for output
            System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

            //Clear the controls from the pased grid

            ClearControls(oGrid);

            //Show grid lines
            oGrid.GridLines = GridLines.Both;

            //Color header
            oGrid.HeaderStyle.BackColor = System.Drawing.Color.LightGray;

            oGrid.Columns[7].Visible = false;

            //Render the grid to the writer
            oGrid.RenderControl(oHtmlTextWriter);

            Response.Write(oStringWriter.ToString());

            Response.Flush();
            Response.End();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

private void ClearControls(Control control)
    {
        //Recursively loop through the controls, calling this method
        for (int i = control.Controls.Count - 1; i >= 0; i--)
        {
            ClearControls(control.Controls[i]);
        }

        //If we have a control that is anything other than a table cell
        if (!(control is TableCell))
        {
            if (control.GetType().GetProperty("SelectedItem") != null)
            {
                LiteralControl literal = new LiteralControl();
                control.Parent.Controls.Add(literal);
                try
                {
                    literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control, null);
                }
                catch
                {
                }
                control.Parent.Controls.Remove(control);
            }
            else if (control.GetType().GetProperty("Text") != null)
            {
                LiteralControl literal = new LiteralControl();
                control.Parent.Controls.Add(literal);
                literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control, null);
                control.Parent.Controls.Remove(control);
            }
        }
        return;
    }