DEX Library Excel Read "TRUE" and "FALSE" values

  • 7 November 2022
  • 4 replies

Badge +1

Hi AIMMS Community,

I am writing a procedure to read in data from an Excel file using the DEX library. Some of our tables have binary data written as strings: “TRUE” and “FALSE”. I have been unsuccessful in reading these values, and am seeking guidance. Here is a simplified example

Test data, I’ve also attached it to this file:

And the XML file (also attached):

I tried a few tests to read in the column with TRUE/FALSE :

  1. Read into P_test(i_test), a parameter with binary range
  2. Read into P_test(i_test), a parameter with no defined range
  3. Read into SP_Test(i_test), a string parameter

Additional Notes:

  • The set “s1” reads successfully into i_test. “value2” also successfully read into SP_Test2.
  • “true” autocorrects to “TRUE” in Excel, so it seems that Excel is doing something to format these values. When I save this tab as a CSV, the values show as strings “TRUE” and “FALSE”.
  • We have used the most recent DEX library version (

Best answer by MarcelRoelofs 8 November 2022, 11:27

View original

4 replies

Badge +1

Hey Chris,

Thanks for your response! I’d like to complete the conversion in AIMMS as you outlined, but I’m not able to read into sp_test(i_test). 

With the test outlined above, I get empty values into sp_test(i_test), even when the other value is read in correctly. 

Have you seen this before? 





Userlevel 5
Badge +7

Hey Melody,


I reproduced the behavior you described based on your materials in a small project, see enclosed.

I forwarded this example to AIMMS PD&I for investigation.


With kind regards,



Userlevel 4
Badge +5

Hi @melody.shellman 

Nothing was done with boolean cells from an Excel sheet. This is corrected in DEX

Thanks for pointing this out!

Badge +1

Thank you @MarcelRoelofs , I will try it out with DEX!


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

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