Invalid Reference on Excel Import

[mail7WJMZ]

[ FlexSim 20.1.2 ]

Hello,

I got an error message on importing Excel, not sure whether this is something need to be fixed.

Seems like the reader can't handle boolean value from Excel file. I expected getting string "TRUE" for boolean TRUE of Excel. But I guess I have to covert it to string in Excel before importing.

In the following files you can find File1.xlsx contains boolean value that causes the error; and File2.xlsx that convert to string.

ExcelImport.rar

[jeff_nordgren · Accepted solution]

Hey Steven,

FlexSim does not do Excel calculations while importing. It imports text and numbers. A boolean is a boolean to Excel that it calculates. FlexSim isn't going to do any Excel conversions or calculation while importing. If you want those booleans, they need to calculated first in the spreadsheet and saved as a number or string.

Thanks.