how to export dtagridview data into Excel and pdf

Question

1.00/5 (1 vote)

See more:

I gt so many option to export data into excel but my problem is I am showing 2 lines in single cell. And whenever I am export data it takes that both line data into next line and data is not in correct format.

-----------------------------------------------------
| 6000 | 5000 | 1200 | |
| Groupname | groupname | groupname | |
| | | | |
-----------------------------------------------------
| 1254 | 654 | 9845 | |
| Groupname | groupname | groupname| |
| | | | |
this the structure of my datagridview data which i am trying to export into excel but it take every data into new row into excel.
Help me guys.

Posted 4-Feb-15 1:14am

Member 11302460

Add a Solution

Comments

CHill60 4-Feb-15 7:22am

Post the code that you use to export the data

Herman<T>.Instance 4-Feb-15 8:24am

asp.net, Winforms, WPF?

1 solution

Add a Solution

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

Sisir Patro · Answer 1 · 2015-02-04T02:19:00

Solution 1

Hi,

Here are couple of links that will help you in achieving your goal.

Export to PDF:
Export-datagridview-data-to-pdf-Csharp

Export to Excel:
Export to Excel in any format/extension

Follow these links you will get an idea how you can achieve your goal.

Thanks
Sisir Patro

Posted 4-Feb-15 2:19am

Sisir Patro

how to export dtagridview data into Excel and pdf

1 solution

Solution 1

Add your solution here

Preview 0

how to export dtagridview data into Excel and pdf

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us