Export ASP.NET DataGrid To Excel

- FREE CMS Download

03.26.04

By Dipal Choksi

Export to Excel is one of the most common functionality required in ASP.Net pages.

Users can download the data from the datagrid into an Excel spreadsheet for offline verification and/or computation. This article includes the source code for such functionality.

How it works

This main functionality to Export a datagrid from an ASP.Net Web Form to an Excel format is actually very simple. There are several solutions for this implementation and in this example we will convert the datagrid to excel format by manipulating the MIME type (media type or Content Type) of the Response. The RenderControl method available in the .Net Framework provides the server control content to an HtmlTextWriter which is subsequently written out to the Response Stream.

Keep your Website up and running 24x7
with SiteScope systems monitoring solution - try it!

And just one more detail

There's just one thing to take care of. A run-time error occurs if the DataGrid contains any controls other than the LiteralControl. This means that enabling Sorting, Paging or adding Template Columnns or Button columns to the datagrid can cause an error. There are several approaches to workaround this limitation. We will remove all the non-Literal controls in the DataGrid and replace the controls with a text representation , where possible. To do so, we will make use of Reflection. instead of querying each type of control and working out a replacement.

For all controls that have a SelectedItem property, we replace the control with the literal value of the SelectedItem property of the control. This covers most lists. For all controls that have a Text property, we replace the control with the literal value of the Text property of the control. This covers TextBox, Buttons, Button Columns, TemplateColumns. We make an exception only for TableCell controls. This takes care of most of the cases and you can add more checks and balances as required. The only drawback for this generalised formula is the order of the controls within a single cell could get changed.

Code Listing : Output the contents of the datagrid to Excel spreadsheet

In our sample web form, we connect to the Sample Pubs SQL Server database and display the data from the Employees table. The sample datagrid uses paging and a dummy Edit Column.

Complete Code Listing

Read the Full Article

About the Author:
Dipal Choksi is a Bachelor of Engineering (Computer Science). She has industry experience in team-effort projects and also as an individual contributor. She has worked on Visual Basic, Visual C++, Java, Directory Services, ASP projects

Read this newsletter at: http://www.webproasp.com/2004/0326.html

Free Newsletters

Part of the iEntry Network
over 4 million subscribers

WebProAsp

SecurityProNews

ITProNews

Send me relevant info on products and services.

WebmasterFree Downloads

From the Forum:

Fastest search of database

I have an access database with around 300 products. Each product has around 50 or so characteristics that differenciate it from all the others. I'm searching it with ASP using vbscript.

What I'd like to know is, am I better to have a different column for each characteristic with a simple yes/no, or would it be faster to put all related characteristics in a single olumn and use vbscripts InStr() method to find what's there?

Go Here

What is your Geek IQ? See how you rank against other techies with this free comprehensive 20 question IQ test.
Take test

-- WebProAsp is an iEntry, Inc. publication --
iEntry, Inc. 880 Corporate Drive, Lexington, KY 40503
2003 iEntry, Inc. All Rights Reserved Privacy Policy Legal

archives | advertising info | news headlines | free newsletters | comments/feedback | submit article