gridview to excel [ASP .NET]

Prev: Confirm dialog and ajax call
Next: How to add namespace to <html> node

From: JohnE on 31 Jan 2010 19:47

I have a gridview on a page that is to export to excel. Below is the code
that is used. Also placed the EnableEventValidation="false" at the top of
the aspx as well as the verifyingrenderinginserviceform. I have googled and
found info on exporting and most all show what I have below. I added the
paging and sorting lines as the export still looked like the gridview. There
should be 184 records in the spreadsheet for the user to manipulate, but
rather the gridview look is there. The user should be able to see a
spreadsheet to do what they further need to do with the information.

protected void btnExportToExcel_Click(object sender, EventArgs e)
{
gvwChangeRequestList.AllowPaging = false;
gvwChangeRequestList.AllowSorting = false;
ExportToExcel();
}

//Export to Excel from a GridView
protected void ExportToExcel()
{
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition",
"attachment;filename=ChangeRequest.xls");
Response.Charset = "";
this.EnableViewState = false;

System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new
System.Web.UI.HtmlTextWriter(sw);

gvwChangeRequestList.RenderControl(htw);

Response.Write(sw.ToString());
Response.End();
}

The gridview uses a sqldatasource. Hoping someone can shed some light on
this as to what is wrong or missing (reference, line, or something).

Thanks...John

From: Alvin Bruney - ASP.NET MVP on 31 Jan 2010 20:05

The GridView needs to be on a page by itself, no other server controls
should be present. Then you can change the content type and it will work.

--
Vapordan
Shameless Author Plug
ASP.NET 4 by Example only $20
OWC Blackbook www.lulu.com/owc

"JohnE" <JohnE(a)discussions.microsoft.com> wrote in message
news:7811E0AF-EC85-412E-964E-8234A7A9953A(a)microsoft.com...
> I have a gridview on a page that is to export to excel. Below is the code
> that is used. Also placed the EnableEventValidation="false" at the top of
> the aspx as well as the verifyingrenderinginserviceform. I have googled
> and
> found info on exporting and most all show what I have below. I added the
> paging and sorting lines as the export still looked like the gridview.
> There
> should be 184 records in the spreadsheet for the user to manipulate, but
> rather the gridview look is there. The user should be able to see a
> spreadsheet to do what they further need to do with the information.
>
> protected void btnExportToExcel_Click(object sender, EventArgs e)
> {
> gvwChangeRequestList.AllowPaging = false;
> gvwChangeRequestList.AllowSorting = false;
> ExportToExcel();
> }
>
> //Export to Excel from a GridView
> protected void ExportToExcel()
> {
> Response.Clear();
> Response.Buffer = true;
> Response.ContentType = "application/vnd.ms-excel";
> Response.AddHeader("content-disposition",
> "attachment;filename=ChangeRequest.xls");
> Response.Charset = "";
> this.EnableViewState = false;
>
> System.IO.StringWriter sw = new System.IO.StringWriter();
> System.Web.UI.HtmlTextWriter htw = new
> System.Web.UI.HtmlTextWriter(sw);
>
> gvwChangeRequestList.RenderControl(htw);
>
> Response.Write(sw.ToString());
> Response.End();
> }
>
> The gridview uses a sqldatasource. Hoping someone can shed some light on
> this as to what is wrong or missing (reference, line, or something).
>
> Thanks...John
>
>

From: JohnE on 31 Jan 2010 20:13

Thanks for the reply. I found a way to get the full grid. In my sample code
just after the paging and sorting lines I rebound the sqldatasource. I also
added a line turning off the Edit command in the gridview so it doesn't show
in the spreadsheet (gvwChangeRequestList.AutoGenerateEditButton = false;).
But, there is a a Detail command link as well. Line below.

<asp:CommandField SelectText="Detail" ShowSelectButton="true"
ButtonType="Link"/>

I would like to turn this off as well so it doesn't show on the spreadsheet.
Do you happen to know how that would be done?

Thanks.
John

"Alvin Bruney - ASP.NET MVP" wrote:

> The GridView needs to be on a page by itself, no other server controls
> should be present. Then you can change the content type and it will work.
>
> --
> Vapordan
> Shameless Author Plug
> ASP.NET 4 by Example only $20
> OWC Blackbook www.lulu.com/owc
>
> "JohnE" <JohnE(a)discussions.microsoft.com> wrote in message
> news:7811E0AF-EC85-412E-964E-8234A7A9953A(a)microsoft.com...
> > I have a gridview on a page that is to export to excel. Below is the code
> > that is used. Also placed the EnableEventValidation="false" at the top of
> > the aspx as well as the verifyingrenderinginserviceform. I have googled
> > and
> > found info on exporting and most all show what I have below. I added the
> > paging and sorting lines as the export still looked like the gridview.
> > There
> > should be 184 records in the spreadsheet for the user to manipulate, but
> > rather the gridview look is there. The user should be able to see a
> > spreadsheet to do what they further need to do with the information.
> >
> > protected void btnExportToExcel_Click(object sender, EventArgs e)
> > {
> > gvwChangeRequestList.AllowPaging = false;
> > gvwChangeRequestList.AllowSorting = false;
> > ExportToExcel();
> > }
> >
> > //Export to Excel from a GridView
> > protected void ExportToExcel()
> > {
> > Response.Clear();
> > Response.Buffer = true;
> > Response.ContentType = "application/vnd.ms-excel";
> > Response.AddHeader("content-disposition",
> > "attachment;filename=ChangeRequest.xls");
> > Response.Charset = "";
> > this.EnableViewState = false;
> >
> > System.IO.StringWriter sw = new System.IO.StringWriter();
> > System.Web.UI.HtmlTextWriter htw = new
> > System.Web.UI.HtmlTextWriter(sw);
> >
> > gvwChangeRequestList.RenderControl(htw);
> >
> > Response.Write(sw.ToString());
> > Response.End();
> > }
> >
> > The gridview uses a sqldatasource. Hoping someone can shed some light on
> > this as to what is wrong or missing (reference, line, or something).
> >
> > Thanks...John
> >
> >

From: JohnE on 31 Jan 2010 22:09

Nevermind in responding. I figured it out.
John

"JohnE" wrote:

> Thanks for the reply. I found a way to get the full grid. In my sample code
> just after the paging and sorting lines I rebound the sqldatasource. I also
> added a line turning off the Edit command in the gridview so it doesn't show
> in the spreadsheet (gvwChangeRequestList.AutoGenerateEditButton = false;).
> But, there is a a Detail command link as well. Line below.
>
> <asp:CommandField SelectText="Detail" ShowSelectButton="true"
> ButtonType="Link"/>
>
> I would like to turn this off as well so it doesn't show on the spreadsheet.
> Do you happen to know how that would be done?
>
> Thanks.
> John
>
>
>
> "Alvin Bruney - ASP.NET MVP" wrote:
>
> > The GridView needs to be on a page by itself, no other server controls
> > should be present. Then you can change the content type and it will work.
> >
> > --
> > Vapordan
> > Shameless Author Plug
> > ASP.NET 4 by Example only $20
> > OWC Blackbook www.lulu.com/owc
> >
> > "JohnE" <JohnE(a)discussions.microsoft.com> wrote in message
> > news:7811E0AF-EC85-412E-964E-8234A7A9953A(a)microsoft.com...
> > > I have a gridview on a page that is to export to excel. Below is the code
> > > that is used. Also placed the EnableEventValidation="false" at the top of
> > > the aspx as well as the verifyingrenderinginserviceform. I have googled
> > > and
> > > found info on exporting and most all show what I have below. I added the
> > > paging and sorting lines as the export still looked like the gridview.
> > > There
> > > should be 184 records in the spreadsheet for the user to manipulate, but
> > > rather the gridview look is there. The user should be able to see a
> > > spreadsheet to do what they further need to do with the information.
> > >
> > > protected void btnExportToExcel_Click(object sender, EventArgs e)
> > > {
> > > gvwChangeRequestList.AllowPaging = false;
> > > gvwChangeRequestList.AllowSorting = false;
> > > ExportToExcel();
> > > }
> > >
> > > //Export to Excel from a GridView
> > > protected void ExportToExcel()
> > > {
> > > Response.Clear();
> > > Response.Buffer = true;
> > > Response.ContentType = "application/vnd.ms-excel";
> > > Response.AddHeader("content-disposition",
> > > "attachment;filename=ChangeRequest.xls");
> > > Response.Charset = "";
> > > this.EnableViewState = false;
> > >
> > > System.IO.StringWriter sw = new System.IO.StringWriter();
> > > System.Web.UI.HtmlTextWriter htw = new
> > > System.Web.UI.HtmlTextWriter(sw);
> > >
> > > gvwChangeRequestList.RenderControl(htw);
> > >
> > > Response.Write(sw.ToString());
> > > Response.End();
> > > }
> > >
> > > The gridview uses a sqldatasource. Hoping someone can shed some light on
> > > this as to what is wrong or missing (reference, line, or something).
> > >
> > > Thanks...John
> > >
> > >

From: sloan on 1 Feb 2010 21:03

How about posting your (own) solution......so that when someone finds this
thread a year from now via googling...........it isn't a dead end?

...........

"JohnE" <JohnE(a)discussions.microsoft.com> wrote in message
news:706CF33D-9174-460D-B579-61BC4730921F(a)microsoft.com...
> Nevermind in responding. I figured it out.
> John
>
>
> "JohnE" wrote:
>
>> Thanks for the reply. I found a way to get the full grid. In my sample
>> code
>> just after the paging and sorting lines I rebound the sqldatasource. I
>> also
>> added a line turning off the Edit command in the gridview so it doesn't
>> show
>> in the spreadsheet (gvwChangeRequestList.AutoGenerateEditButton =
>> false;).
>> But, there is a a Detail command link as well. Line below.
>>
>> <asp:CommandField SelectText="Detail" ShowSelectButton="true"
>> ButtonType="Link"/>
>>
>> I would like to turn this off as well so it doesn't show on the
>> spreadsheet.
>> Do you happen to know how that would be done?
>>
>> Thanks.
>> John
>>
>>
>>
>> "Alvin Bruney - ASP.NET MVP" wrote:
>>
>> > The GridView needs to be on a page by itself, no other server controls
>> > should be present. Then you can change the content type and it will
>> > work.
>> >
>> > --
>> > Vapordan
>> > Shameless Author Plug
>> > ASP.NET 4 by Example only $20
>> > OWC Blackbook www.lulu.com/owc
>> >
>> > "JohnE" <JohnE(a)discussions.microsoft.com> wrote in message
>> > news:7811E0AF-EC85-412E-964E-8234A7A9953A(a)microsoft.com...
>> > > I have a gridview on a page that is to export to excel. Below is the
>> > > code
>> > > that is used. Also placed the EnableEventValidation="false" at the
>> > > top of
>> > > the aspx as well as the verifyingrenderinginserviceform. I have
>> > > googled
>> > > and
>> > > found info on exporting and most all show what I have below. I added
>> > > the
>> > > paging and sorting lines as the export still looked like the
>> > > gridview.
>> > > There
>> > > should be 184 records in the spreadsheet for the user to manipulate,
>> > > but
>> > > rather the gridview look is there. The user should be able to see a
>> > > spreadsheet to do what they further need to do with the information.
>> > >
>> > > protected void btnExportToExcel_Click(object sender, EventArgs e)
>> > > {
>> > > gvwChangeRequestList.AllowPaging = false;
>> > > gvwChangeRequestList.AllowSorting = false;
>> > > ExportToExcel();
>> > > }
>> > >
>> > > //Export to Excel from a GridView
>> > > protected void ExportToExcel()
>> > > {
>> > > Response.Clear();
>> > > Response.Buffer = true;
>> > > Response.ContentType = "application/vnd.ms-excel";
>> > > Response.AddHeader("content-disposition",
>> > > "attachment;filename=ChangeRequest.xls");
>> > > Response.Charset = "";
>> > > this.EnableViewState = false;
>> > >
>> > > System.IO.StringWriter sw = new System.IO.StringWriter();
>> > > System.Web.UI.HtmlTextWriter htw = new
>> > > System.Web.UI.HtmlTextWriter(sw);
>> > >
>> > > gvwChangeRequestList.RenderControl(htw);
>> > >
>> > > Response.Write(sw.ToString());
>> > > Response.End();
>> > > }
>> > >
>> > > The gridview uses a sqldatasource. Hoping someone can shed some
>> > > light on
>> > > this as to what is wrong or missing (reference, line, or something).
>> > >
>> > > Thanks...John
>> > >
>> > >

| Next | Last
Pages: 1 2
Prev: Confirm dialog and ajax call
Next: How to add namespace to <html> node