We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Calculate VBA

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?

@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.
https://docs.aspose.com/display/cellsjava/Workbook+VBA+Project

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