Write a Excel with outline and group

[chandanajagath]

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

[molona]

I'm not sure that I understand what you want... do you have an example or can you clarify a little bit more?

[awasson]

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/

[chandanajagath]

Dear Molona,

I want to create excel report like following

Excel Report.png

Thank u