Hi,
Can you tell me please, if aspose.cells supports the following:
(1) Get a list of pivot tables from an excel file (pivot tables created in excel)
(2) Get a list of data connections from excel (as defined in excel->connections->add workbook connections)
(3) Is hasMacro() working?
(4) Can aspose return the macro code (just the source) to a string in c#?
If these are not working or not available, when are these features planned for release?
thank you,
Ronan
Hi Ronan,
1. Pivot Table List:
//Getting the pivot tables collection in the sheet
Aspose.Cells.Pivot.PivotTableCollection pivotTables = sheet2.PivotTables;
2. Yes you can detect and removes connections to external data
3.HasMacro
public bool HasMacro {get;}
Indicates if this spreadsheet contains macro/VBA. It is working fine.
4. Macro Code
For now, we have CodeName property
public string CodeName {get;}
Represents worksheet code name.
We are continuously working on implementing more and more feature in Aspose.Cells.
Thanks,
Salman,
thank you for the very quick reply.
Can I just ask -
(1) how to get the list of data connections (or what the method to test for data connections without removing them).
(2) Is there a plan to allow access to the macro source code, and if not, is there is specific reason?
kind regards,
Ronan