Free Support Forum - aspose.com

Aspose.cells - find pivot tables- data connections- macros-

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