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.
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).
Member
15 Points
74 Posts
How to create Excel Pivot tables in a .NET web page?
May 15, 2012 05:48 PM|csharpnew|LINK
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.
Thanks,
web openxml net excel
Member
80 Points
34 Posts
Re: How to create Excel Pivot tables in a .NET web page?
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).