Hello Technical support team,
We have been using Aspose.Cells for .NET for last two years. The version of the Aspose.cells.dll file that we have is 7.4.0.0.
We use SQL Server 2008 BIDS to create and develop SSRS reports. We have an ASP.NET web application that uses ReportVeiwer Control and we render a report and we use Aspose.Cells for .NET to apply some formatting before the report is generated and is saved as Excel.
I tried to search for the following questions but could not get the right or clear answer in your forums or articles.
The questions we have are the following:
Can Aspose support the following, please point us to the example and links if possible:
-
Power Pivot (add on to excel)
-
Functions in excel (e.g. does it export just the raw data to excel or can it export the underlying formulas as well. If we were to export the formulas that make each report happen, and then wanted to filter/change data based on those formulas within excel, would we be able to?)
-
VBA and/or Macros?
Your expert guidance would be greatly appreciated.
Thanks,
Riz Atique.
Hi,
1) Do you need to set the Microsoft Power Pivot add-ins in MS Excel or you want the functionality of the Add-ins? Well, I am afraid, Aspose.Cells is just a class library and might not offer the extensive functionality, it does not provide any UI too. Aspose.Cells does support to create, manipulate Pivot Tables in Excel files. Also, it supports to set or calculate MS Excel formulas/ functions that you may utilize for your requirements, so you may try to utilize the relevant APIs for your needs, please see the documents in the sections:
2) Supported. Sure, it supports to export underlying formulas to Excel file formats (e.g XLS, XLSX, XLSM, XLSB, CSV, ODS, SpreadsheetML etc.). When you open the generated file (by Aspose.Cells) into Ms Excel or any other Excel viewer, you will see that the data is exported with formulas, so when you change the source data in the cells, the corresponding cells having formulas get updated (with their calculated values) accordingly.
3) Not Supported. Aspose.Cells can only load a file (which has vbas/ macros attached) and re-save the file with it, so if you have VBA codes/ macros in an Excel file, these would be retained in the file as they are. Aspose.Cells does not support to create, manipulate or run VBA codes or macros.
Thank you.