How to create Excel Pivot tables in a .NET web page? RRS feed

  • Question

  • User1045719674 posted

    Hello All,

    I want to create Microsoft Excel files with pivot tables in it using a .NET website.  I was able to do it using a tool ( Aspose.cells), but we couldn't get a license, due to budget issues. Hence, is there a way to create Excel pivot files using a free tool.

    I read about Open XML SDK but am not able to install it properly. Hence, if anyone has previously created Excel files using either a free tool or Open XML SDK, please let me know. I want to start with the basics and then build complex pivot tables.


    Tuesday, May 15, 2012 5:48 PM


  • User1108898723 posted

    The question is rather old, but it still has no answers for some reason.

    Excel PivotTable may be easily generated with EPPlus library (.NET-Core compatible build: Shaman.EPPlus ); note that input data for the pivot table should be exported to the worksheet. In case of large dataset (say, > 50,000 rows) you may pre-aggregate it by dimensions that are used in the Excel PivotTable with NReco PivotData library: how to create Excel PivotTable by DataTable (the same approach can be used for ado.net data reader, typed models list etc).

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, December 3, 2016 7:08 AM