Last post Dec 03, 2016 07:08 AM by VitaliyMF
May 15, 2012 05:48 PM|csharpnew|LINK
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.
Dec 03, 2016 07:08 AM|VitaliyMF|LINK
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).