Export multiple tables to Excel Sheets from database

Question

1.00/5 (1 vote)

See more:

In my program i displayed all the table names with in the gridview.I want export more than one table from that gridview by clicking on the checkbox... this selection done at runtime at that which tables are selected those are only dynamically Exported to Excel sheets..

Posted 25-Mar-12 18:58pm

shwetha1

Updated 25-Mar-12 18:59pm

v2

Add a Solution

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)

Roman Lerman · Answer 1 · 2012-03-25T21:02:00

Solution 1

Use the CodeProject search engine...

Exporting DataGrid to Excel, Word and Text Files[^]

DataTable to Excel[^]

Export DataGrid to Excel[^]

Posted 25-Mar-12 21:02pm

Roman Lerman

Comments

shwetha1 26-Mar-12 3:48am

I want to export multiple tables at a time is this possible?

Roman Lerman 26-Mar-12 3:53am

Yes it is.
A Very Easy to Use Excel XML Import-Export Library[^]
You paid attention to where I found it...

shwetha1 26-Mar-12 4:15am

but i want to export tables from datbase to excel sheets..