it outsourcing, web programming, emarketing, econsulting, it consultant, internet consultant, we knows all about internet

March 11, 2010

.net acces Ajax Ajuntament ASP asp.net c# css CSS2 Enterprise export globaria google gridview hibernate mapping hotel jquery linux mallorca Mamacarter Maquetación massimo estudio melia mysql Php Planeta Web SEO share files trivia XHTML

Contact us

If you have any doubt or suggestion, you may contact us with the next form:

This field is required.

Please enter a valid email.

How did you hear about us? Google Other Advertising Friend's recomendation Third party site Yahoo Comment

This field is required.

With the next code you will be able to export a GridView to Excel format (xls), it's very simple:

protected void btnExportExcel_Click(object sender, EventArgs e)
{
	Response.Clear();
	Response.Buffer = true;
	Response.AddHeader("content-disposition",
	"attachment;filename=GridViewExport.xls");
	Response.Charset = "";
	Response.ContentType = "application/vnd.ms-excel";

	StringWriter sw = new StringWriter();
	HtmlTextWriter hw = new HtmlTextWriter(sw);

	GridView1.AllowPaging = false;
	GridView1.DataBind();

	//Change the Header Row back to white color
	GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");

	//Apply style to Individual Cells
	GridView1.HeaderRow.Cells[0].Style.Add("background-color", "green");
	GridView1.HeaderRow.Cells[1].Style.Add("background-color", "green");
	GridView1.HeaderRow.Cells[2].Style.Add("background-color", "green");
	GridView1.HeaderRow.Cells[3].Style.Add("background-color", "green");  

	for (int i = 0; i < GridView1.Rows.Count;i++ )
	{
    		GridViewRow row = GridView1.Rows[i];

    		//Change Color back to white
    		row.BackColor = System.Drawing.Color.White;

    		//Apply text style to each Row
    		row.Attributes.Add("class", "textmode");
    		//Apply style to Individual Cells of Alternating Row

    		if (i % 2 != 0)
    		{
        		row.Cells[0].Style.Add("background-color", "#C2D69B");
        		row.Cells[1].Style.Add("background-color", "#C2D69B");
        		row.Cells[2].Style.Add("background-color", "#C2D69B");
        		row.Cells[3].Style.Add("background-color", "#C2D69B");  
    		}
	}

	GridView1.RenderControl(hw);

	//style to format numbers to string
	string style = @"";

	Response.Write(style);
	Response.Output.Write(sw.ToString());
	Response.Flush();
	Response.End();
} 

Good bye

Tags: asp.net, export, xls, excel, gridview

• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Add comment
Write your comment
This field is required.	Please enter a valid email.
Comment This field is required.
Security code:	Enter code: