How to export data from WPF toolkit datagrid to Excel

Question

0.00/5 (No votes)

See more:

.NET3.5

I want to export data from WPF toolkit datagrid (which has the data from the SQL server database) to excel.

But when I search in the google, in all sites there is the method to export from asp.net or vb.net

Such methods are not get success in the WPF.

Pls help me through any sample code snippets

Posted 23-Mar-10 1:31am

LukmanulHakeem.T

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)

#realJSOP · Answer 1 · 2010-03-23T01:44:00

I found this exchange with google:

WPF's DataGrid is a bit different than ASP.net's DataGrid. One way you can export to excel with WPF's DG is to use the DataGrid.CopyToClipboard command which makes a copy in a CSV, html, and text format. From there you can either just create a csv file or use the excel APIs to create an excel file. Hope that helps.

I might be in dire need of lunch but I can't find a CopyToClipboard command or anything like it for the WPF datagrid. Would it be possible for you to provide a brief code snippet because I'm scratching my head and clearly missing something obvious.

Sorry, I think what I meant to say was the built in copy functionality of DataGrid. DataGrid has a ClipboardCopyMode and does use a command to do a copy but the only way you can customize it is by overriding one of the protected copy methods. The default copy functionality does create the formats that I describe above so you should be able to export that to excel.

Google is easy. As for code snippets, you're on your own, but you should be able to develop the code for this in just a few lines.