question

Steven Chen avatar image
0 Likes"
Steven Chen asked Jeff Nordgren answered

Invalid Reference on Excel Import

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

FlexSim 20.1.2
flexsim 20.1.2excel import
01.png (1.9 KiB)
excelimport.rar (64.8 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Jeff Nordgren avatar image
1 Like"
Jeff Nordgren answered

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.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.