locked
Import cross tab excel data (horizontal + vertical) columns data in sql server 2005 in asp.net RRS feed

  • Question

  • User442831413 posted

    hi,

    i have a situation, can we export the following format(horizonal and vertical columns) of data from excel in asp.net in c# in sql server 2005

       FY2012 QUARTER 1   FY 2012 QUARTER 2   FY 2012 QUARTER 3 
       SALES   INPUTS   SALES   INPUTS   SALES   INPUTS 
    CUSTOMER Plan  Fcst   Act   Plan   Fcst   Act  Plan Fcst Act Plan Fcst Act Plan  Fcst   Act   Plan   Fcst   Act 
    maruti  $        150  $        250  $     1,500 3 2 1  $        154  $        254  $        250 3 3 0  $        241  $     5,418  $        500 2 2 0
    honda  $    40,000  $    25,900  $    18,680 21 15 4  $    35,050  $        254  $        250 3 3 0  $        241  $     5,418  $        500 2 2 0
    skoda  $    36,750  $    27,050  $    16,555 20 17 9  $    33,175  $        254  $        250 3 3 0  $        241  $     5,418  $        500 2 2 0
    TOTAL  $  139,485  $  138,285  $    91,436 91 93 46  $  135,210  $  135,210  $          -   94 94 0  $  119,655  $  118,905  $          -   85 84 0
    Running Total  $  139,485  $  138,285  $    91,436 91 93 46  $  274,695  $  273,495  $    91,436 185 187 46  $  394,350  $  392,400  $   91,436 270 271 46
    Friday, September 28, 2012 10:34 AM

Answers