Dataset to Excel reports

Question

0.00/5 (No votes)

See more:

XML

<pre lang="xml">&lt;pre lang=&quot;xml&quot;&gt;&amp;lt;pre lang=&amp;quot;xml&amp;quot;&amp;gt;&amp;amp;lt;pre lang=&amp;amp;quot;xml&amp;amp;quot;&amp;amp;gt;&amp;amp;amp;lt;pre lang=&amp;amp;amp;quot;xml&amp;amp;amp;quot;&amp;amp;amp;gt;I need dataset data to be exported to excel.
The show stopper is : i need to transpose the data present in the dataset while presenting it in the excel.eg:
RollNo     Name       Age        Phone number
101        ABC        18         9821982121
102        PQR        17
103        XYZ        20         9819981919
104        LMN        18         9898989898
105        STU
105        STU        19

And the result should be like this.

RollNo         | 102        | 103        | 104        | 105         | 105
Name           | PQR        | XYZ        | LMN        | STU         | STU
Age            | 17         | 20         | 18         |             | 19
Phone number   |            | 9819981919 | 9898989898 |             |

The values will be dynamic, and the number of data present may be not equal in every records.
Also, there may be multiple entries of the same record(Roll number 101 repeated twice) with variable data present( )&amp;amp;amp;lt;/pre&amp;amp;amp;gt;&amp;amp;lt;/pre&amp;amp;gt;&amp;lt;/pre&amp;gt;&lt;/pre&gt;</pre>

Posted 18-Feb-13 19:39pm

Vinay iGATE

Updated 18-Feb-13 20:24pm

v2

Add a Solution

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

Asim Mahmood · Answer 1 · 2013-02-18T19:51:00

Solution 1

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ea02f8e8-edf5-4aca-8c74-ef3a94b5328d/[^][]
http://itsrashid.wordpress.com/2007/05/14/export-dataset-to-excel-in-c/[^][]
http://social.msdn.microsoft.com/Forums/en-US/csharplanguage/thread/b5376135-75e3-4960-990b-ad16013561f1[^][]

may it's helpful to u.

Posted 18-Feb-13 19:51pm

Asim Mahmood

Comments

Vinay iGATE 19-Feb-13 2:25am

Thanks for the solution. It would be more helpful, if you can provide me with the way as how to work around with the dataset data so that i can transpose the records as explained in the example in my query

Asim Mahmood 19-Feb-13 2:27am

then please view these links

http://www.codeproject.com/Articles/32370/Import-Excel-File-to-DataSet
http://stackoverflow.com/questions/7244971/how-do-i-import-from-excel-to-a-dataset-using-microsoft-office-interop-excel

Avik Ghosh22 · Answer 2 · 2013-02-18T19:54:00

Solution 2

Export Gridview Data to Excel in ASP.NET[^]
http://www.webpronews.com/aspnet-export-a-datatable-to-excel-2006-11[^]
http://stackoverflow.com/questions/1746701/export-datatable-to-excel-file[^]

Posted 18-Feb-13 19:54pm

Avik Ghosh22

Comments

Vinay iGATE 19-Feb-13 2:25am

Thanks for the solution. It would be more helpful, if you can provide me with the way as how to work around with the dataset data so that i can transpose the records as explained in the example in my query

Avik Ghosh22 19-Feb-13 2:31am

http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx
http://asp.net-informations.com/dataset/howto-asp-dataset.htm

https://www.google.co.in/#hl=en&tbo=d&sclient=psy-ab&q=how+to+use+dataset+in+asp.net+with+c%23&oq=HOW+TO+USE+dataset+IN+ASP.NET&gs_l=hp.1.1.0l2j0i7i30j0i30.65022.68890.3.71284.11.11.0.0.0.2.332.2274.0j6j3j2.11.0.les%3B..0.0...1c.1.3.psy-ab.wZSVv7oBjbs&pbx=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.&bvm=bv.42553238,d.bmk&fp=81d14d7c7e348b8c&biw=1280&bih=629