We're looking into using Aspose.Cells for the .NET platform. We need to make sure that the following things are supported before we can move forward.
1) External data sources (SQL and OLAP) for Pivot Tables and Pivot Charts (without manually importing the datasets into the worksheet. i.e. it should be able to setup the connection string for the pivot cache and a pivot table should be able to be created from that pivot cache)
2) Ability to drill down Pivot Tables in a custom way based upon the data hierarchy in the Pivot Table.
3) Can manage macros in the workbook
4) Supports Excel 2007
Please let me know if Aspose.Cells can meet these requirements and especially in the cases of #1 and #2 if there are any working code examples that I can review.