Last post May 18, 2012 08:49 PM by Decker Dong - MSFT
May 17, 2012 10:42 AM|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.
May 18, 2012 08:49 PM|Decker Dong - MSFT|LINK
I think you have two choices：
1）Just use Office desktop tools or Web Office（if you have an hotmail，it's totally free！:-)）for you to develop Pivot table as a nested function of Excel software：http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx
2）If you want to use a 3-rd party control，I think：
2.1）Use Pivot table related classes：http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.pivottablewizard%28VS.80%29.aspx
2.2）http://blogs.msdn.com/b/andreww/archive/2008/07/25/creating-a-pivottable-programmatically.aspx（Use OleDbConnection+OleDbCommand to export and
PS：All of them are totally free！