Export To Excel Data

Question

0.00/5 (No votes)

See more:

I Have a GridView, which is getting bind with data from data table and i will filter data from table and then bind to Gridview,
How to Export data to Excel which is binded to gridview.

Please Help Me ASAP

C#

BindRequestDetails();
           //dtRequestDetails = dsRequests.Tables["CertificationRequest"];
           DataTable dtReport = dtRequestDetails;
           string[] strColumns = { "RequestID", "RequestStatus", "EmployeeName", "ProjectName", "CertificationName", "PercentageObtained", "PassingPercentage", "ExpectedExamFee", "ActualExamFee", "ReimbursementAmount", "ValidTillDate", "PrimarySkills" };
           DataTable reportTable = dtReport.DefaultView.ToTable(dtReport.TableName, false, strColumns);
           string strFileNameForExport = "Report.xls";
           reportTable.Columns["RequestID"].ColumnName = "Request ID";
           reportTable.Columns["RequestStatus"].ColumnName = "Request Status";
           reportTable.Columns["EmployeeName"].ColumnName = "Employee Name";
           reportTable.Columns["ProjectName"].ColumnName = "Project Name";
           reportTable.Columns["CertificationName"].ColumnName = "Certification Name";
           reportTable.Columns["PercentageObtained"].ColumnName = "Percentage Obtained";
           reportTable.Columns["PassingPercentage"].ColumnName = "Passing Percentage";
           reportTable.Columns["ExpectedExamFee"].ColumnName = "Expected Exam Fee";
           reportTable.Columns["ActualExamFee"].ColumnName = "Actual Exam Fee";
           reportTable.Columns["ReimbursementAmount"].ColumnName = "Reimbursement Amount";
           reportTable.Columns["ValidTillDate"].ColumnName = "ValidTill Date";
           reportTable.Columns["PrimarySkills"].ColumnName = "Primary Skills";

           try
           {
               OCSCommon.GenerateExcelAndDownload(strFileNameForExport, reportTable);
           }

Posted 29-Jul-13 7:23am

vana Bharadwaj

Updated 29-Jul-13 7:50am

Ron Beyer

v4

Add a Solution

Comments

ZurdoDev 29-Jul-13 13:32pm

There are lots of samples online. Have you tried one?

vana Bharadwaj 29-Jul-13 13:33pm

ya i did, actually after Click on Export to excel button, the page will remain loading, and other button page is not working.

ZurdoDev 29-Jul-13 13:39pm

Then post your relevant code using the improve question link and let us know where you are stuck.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kishore sharma · Answer 1 · 2013-07-29T07:48:00

Solution 1

Check here for Export to excel from datatable
http://kishsharmasoftcode.blogspot.in/[^]

Posted 29-Jul-13 7:48am

kishore sharma

woopsydoozy · Answer 2 · 2013-07-29T07:55:00

I've answered a couple just like this recently. Here's Microsoft's walkthrough: http://support.microsoft.com/kb/306022[^].

It sounds like you may be experiencing a common problem--you code it right, but the processing is very slow. To speed that up, output to Excel via an array into a range instead of cell by cell. The Microsoft link above includes an example of that.