数据集到Excel报告 [英] Dataset to Excel reports

问题描述

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

推荐答案

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ea02f8e8-edf5-4aca-8c74-ef3a9​​4b5328d/ [ ^ ] [ ]

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 [ ^ ] [ ]



可能对你有帮助。

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.

将Gridview数据导出到ASP.NET中的Excel [ ^ ]

<啊REF = http://www.webpronews.com/aspnet-export-a-datatable-to-excel-2006-11> http://www.webpronews.com/aspnet-export-a-datatable-to- excel-2006-11 [ ^ ]

http：// stackoverflow .com / questions / 1746701 / export-datatable-to-excel-file [ ^ ]

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[^]

这篇关于数据集到Excel报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！