Skip to main content
Question

Get the formula of a cell using AXLL

  • May 4, 2026
  • 0 replies
  • 8 views

gdiepen
AIMMS Champ
Forum|alt.badge.img+7

When using the AIMMS Excel library (AXLL), is it possible to determine whether a cell is a formula or not?

 

There is an explicit WriteFormula function in the library, but I don’t see anything that gives me information about whether a cell is an entered value or whether it is a formula.

 

I am currently reading in an excel file and need to handle these two situations differently: majority of cells in a range are defined by a formula, but some are manually overruled (i.e. just an entered value) and I need to know which ones are overruled and which ones not.

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator