Calculate VBA

Aspose.Cells Product Family
1

do you have the option to calculate VBA in excel with
workbook.calculateFormula()?

what about calculation values of cells that come dynamically from odata / webquery when opening the excel?

2

@turaaa,
We are afraid, Aspose.Cells cannot execute Macros or VBA scripts. However, you can modify or insert VBA scripts via Aspose.Cells.

Please see the following documentation article for your reference.

Although Aspose.Cells does not support external data sources, but for creating Excel data query pointing to OData feed, we have already logged a ticket to investigate this option. We will write back here as soon as any feedback is ready to share.

CELLSNET-46512 - Create Excel Data Query pointing to OData Feed