locked
Export Dataset to excel sheet in a required format? RRS feed

  • Question

  • User355090264 posted

    Hi,

    I know how to export a grid view to excel.

    But here i have a Dataset which consists of data like below and also it need to display in a required format like below.

    pno psubno pstate pdetailid pdetails

     12    1          CA         1           cbsdjcbdjc     

    12     1          CA          2        cndcnjdcjcj

    12     2           VA         4          xcndwkfcgygry

    13     1            AL        1           ncdcnjdcndj

    My excel sheet  should like this.

    pid       pstate     

     12/1      CA                 

    Details

    (pdetailid)1. cbsdjcbdjc

    2. cndcnjdcjcj

    12/2        VA

    4. xcndwkfcgygry

     

    can any body post sample code.

    Thanks In Advance.

    Wednesday, August 11, 2010 9:21 AM

Answers

  • User-481631678 posted

    Checkout this link,

    http://zeeshanumardotnet.blogspot.com/2010/07/export-to-excel-in-net.html


    This link uses YogeshXml component to export data into Excel file. It provides many option to format data as per your requirement.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, August 11, 2010 10:00 AM