ASP.NET create excel pivot table

Question

May I know if there has something can help to create excel pivot table for ASP.NET? Thanks.

I heard there is a Office Web Component. Is it free and can it make pivot table? Since we have some complex Excel vba file, we would migrate it into pure web based generated file.

Eugene Astafiev · Accepted Answer · 2015-04-15 14:03:25Z

1

OWC is deprecated. See Office Web Components Lifecycle which states the following:

The most important thing to be aware of is that the Office Web Components technology has been deprecated. This means that only security fixes are being made to all versions of OWC, and no future versions of OWC will be produced. If you are using OWC, you should begin migrating to a new technology as soon as possible. For more information, see the blog post "Office Web Components Roadmap".

Use Excel services instead. See Replacing OWC Reporting with Excel Services for more information.

If you need to generate Excel files on the server side you may consider using the Open XML SDK.

answered Apr 15, 2015 at 14:03

Eugene Astafiev

49.8k3 gold badges28 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3691709 Over a year ago

How about NPOI? Is it good to use, or Open XML is better? Thanks

Collectives™ on Stack Overflow

ASP.NET create excel pivot table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related