SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Dec 2011
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Write a Excel with outline and group

    Dear All,

    I create asp page when user click button then open a excel file with related data but i want to group that data using Group and outline Excel function

    How to do it

    Thank you

    Best regard
    Chandana

  2. #2
    #titanic {float:none} silver trophy
    molona's Avatar
    Join Date
    Feb 2005
    Location
    from Madrid to Heaven
    Posts
    8,179
    Mentioned
    234 Post(s)
    Tagged
    1 Thread(s)
    I'm not sure that I understand what you want... do you have an example or can you clarify a little bit more?

  3. #3
    SitePoint Wizard bronze trophy
    Join Date
    Oct 2001
    Location
    Vancouver BC Canada
    Posts
    2,029
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    I think if you want to use Excel functions, you'll need to go with an ASP.NET solution.

    ASP Excel functionality is very limited. You can change the mime header to output Excel and then put all of your data in a table. This will make your browser think it's Excel and you can use simple Excel formulas but yo won't be able to use any advanced Excel functionality because it's a bit beyond what ASP was capable of when it was last supported.

    EDIT: I've used the Carlos Ag Excel writer which is an ASP.NET component. I've used it in a Classic ASP site that was on a server that supported both ASP and .NET. I added a "bin" directory to the server root, inserted the Carlos Ag component and wrote a simple ASP.NET file to do the Excel processing. It worked quite well for my purposes of producing a multi-sheet report.

    http://www.carlosag.net/tools/excelxmlwriter/
    Andrew Wasson | www.lunadesign.org
    Principal / Internet Development

  4. #4
    SitePoint Member
    Join Date
    Dec 2011
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Molona,

    I want to create excel report like following

    Excel Report.png

    Thank u


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •