Export GridView data to Excel.

Question

0.00/5 (No votes)

See more:

Hello to all,

I am in trouble.

Can any one tell me how I export my Gridview data into Excel File.
Please send a specific Code I tried but it shows error like

Error	1	

The type or namespace name 'ExcInterop' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)

and then I use Namespace

using Excel = Microsoft.Office.Interop.Excel;

It shows error. What should I do know I also install DLL reg but its not working...

Thanks & Regards
Mohit

[edit]Subject, Tags, Capitalization, code blocks, minor English, urgency removed. It may be urgent to you, but it isn't to us. All that your stressing the urgency does is to make us think you have left it too late, and want us to do it for you. This annoys some people, and can slow a response - OriginalGriff[/edit]
[edit2]...And then I disanbled "Ignore HTML..." option. I must check the preview. I must check the preview. I must check the preview... - OriginalGriff[/edit2]

Posted 1-Apr-11 21:41pm

Mohit3

Updated 2-Apr-11 3:59am

Dalek Dave

v4

Add a Solution

Comments

Sandeep Mewara 2-Apr-11 3:45am

please send a specific Code
:doh:

Edit and update with small code snippet here. Further, did you tried to Google? It's a very comment requirement to export gridview data to Excel file... lots of articles and blogs..

+ I am sure, lots of links for the error too that you get.

Mohit3 2-Apr-11 3:53am

thanks but sir iam not understand which namespace is used for Excel,how i registered Excel Dll in my Toolbox that all excel coding file are coming in my Project.

3 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)

poloyzhang · Answer 1 · 2011-04-01T23:07:00

Solution 2

using assembly reference

please send a specific Code in you problem.

Posted 1-Apr-11 23:07pm

poloyzhang

RaviRanjanKr · Answer 2 · 2011-04-02T00:57:00

Solution 3

Take a look there-CPArticle[^] to learn how to export Grdiview data to Excel.

Posted 2-Apr-11 0:57am

RaviRanjanKr

Comments

Dalek Dave 2-Apr-11 9:59am

Good Link

OriginalGriff · Answer 3 · 2011-04-01T21:53:00

Google is an amazing tool: a quick search using the new subject for your question "Export GridView data to Excel" gave 1,490,000 hits. Including this one, right at the top: Export GridView to Excel Complete Code![^]

The whole first page of the search was different ways to achieve it with full source code...

Use Google. It can save you a lot of time and effort.