Error Export to excel download.

Ankit Agarwal

11y869.NET

Hello,

I am using this code but its getting error:- system.io.streamwriter' does not contain a constructor that takes 0 arguments.

public void ExportDetails() {  SqlConnClass connClass = new SqlConnClass();         DataTable dt = connClass.GetQrCodeDetails();         GridView gv = new GridView();         gv.AutoGenerateColumns = false;           BoundField ID = new BoundField();         ID.HeaderText = "ID";         ID.DataField = "ID";         gv.Columns.Add(ID);           BoundField QRIMAGE = new BoundField();         IMAGE.HeaderText = "IMAGE";         IMAGE.DataField = "IMAGE";         gv.Columns.Add(IMAGE);           StreamWriter sw = new StreamWriter(); //Error is showing in this line.         HtmlTextWriter htw = new HtmlTextWriter(sw);         gv.RenderControl(htw);         Response.Write(htw); ExportTableData(sw.ToString()); }   public void ExportTableData(string data)     {         string attach = "attachment;filename=CodeDetails.xls";         Response.ClearContent();         Response.AddHeader("content-disposition", attach);         Response.ContentType = "application/ms-excel";           Response.Write(data);         Response.End();     }

please help me.
How to resolve this error.

Thanks in Advance.

Ankit Agarwal
Software Engineer

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
I have modified two things in your code. First QRIMAGE was not properly set, secondly use StringWriter instead of StreamWriter object.

See yellow marked code:

public void ExportDetails()
{
   SqlConnClass connClass = new SqlConnClass();
   DataTable dt = connClass.GetQrCodeDetails();
   GridView gv = new GridView();
   gv.AutoGenerateColumns = false;
   BoundField ID = new BoundField();
   ID.HeaderText = "ID"; ID.DataField = "ID";
   gv.Columns.Add(ID);
   BoundField QRIMAGE = new BoundField();
   QRIMAGE.HeaderText = "IMAGE";
   QRIMAGE.DataField = "IMAGE";
   gv.Columns.Add(QRIMAGE);
   StringWriter sw = new StringWriter();
   HtmlTextWriter htw = new HtmlTextWriter(sw);
   gv.RenderControl(htw); Response.Write(htw);
   ExportTableData(sw.ToString());
}
0
Ravi Kumar11y ago
hi
check the fallowing code

using Excel = Microsoft.Office.Interop.Excel;
using System.Configuration;
using System.Data.SqlClient;

-----click event-----

Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.ApplicationClass();
xlApp.Visible = true;
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;
for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
{
DataGridViewCell cell = dataGridView1[j, i];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}
//xlWorkBook.SaveAs("csharp.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);

0