export datagrid to excel

Question

1.00/5 (4 votes)

See more:

VB

how can export data in datagrid view control from vb.net to excel work sheet

Posted 10-Jul-10 1:54am

hassan shehata

Add a Solution

Comments

Ourning 22-Mar-16 9:03am

hassan you can do this with a VB.NET DLL for excel.
See this article about exporting DataGridView control into an excel worksheet with VB.NET.

1 solution

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)

Sandeep Mewara · Answer 1 · 2010-07-10T02:56:00

Solution 1

Look at the following:
GridView – Export to Excel (VB.Net)[^]
Best method for exporting a DataGridView to Excel[^]
How to export datagridview to excel using vb.net?[^]
CodeSnip: Exporting GridView to Excel[^]

There are a lot more, just GOOGLE it!

Posted 10-Jul-10 2:56am

Sandeep Mewara

Comments

Sandeep Mewara 19-May-11 8:05am

If Everytime We Need To Google only Than Why We are Here. And Why You are Here
At your service sir! :laugh:

Pete O'Hanlon 19-May-11 8:12am

To help you learn that you can Google for this information yourself. We're happy to help when you have a specific problem, but when you want somebody to think for you that's where we draw the line.

CPallini 19-May-11 8:19am

"No, poems, no less! Poems, everybody! The laddie reckons himself a poet!"

CPallini 19-May-11 8:54am

Of course. Sorry, I must apologize for, it was just a quote from Pink Floyd's "The Wall", nothing personal.

Keith Barrow 19-May-11 8:25am

Why You are Here
Google doesn't Google itself you know! Yet.

Richard MacCutchan 19-May-11 8:40am

OK, so what's the answer?

#realJSOP 19-May-11 9:07am

Because most of the time, we have to google to find the answer that you could have found by using google. I've forgotten more stuff than I currenntly know, and I use google EVERY DAY to find answers, or to be reminded of how to accomplish a task. Learn how to use google. It will save you butt loads of time and grief.

Nagy Vilmos 19-May-11 9:09am

Poetry is an art form,
Using rhyme and beat.
Computers can't compete.

Ankur^\m/ 21-May-11 0:47am

You haven't read the guideline then. It is right there when you ask the question. Here you go - http://www.codeproject.com/Questions/ask.aspx#ctl00_ctl00_MC_AMC_PostEntry_HelpTips.
Point no. 1

Nagy Vilmos 19-May-11 9:13am

+5 if I could do it.
Chris has said no way.
You're rep will stays this way now.

Karwa_Vivek 21-May-11 1:32am

next time I will take Care of this..

NekoNao 22-Sep-14 2:02am

do you have answer for this?
Export to Excel : Two DataGridView[^