question

asb.p avatar image
0 Likes"
asb.p asked Braydn T commented

excelimporttable command Issue

If excel range has value "TRUE" in one of the cells the excelimporttable command is throwing an error and import is skipped for that particular cell.

Please find the attached model and excel file for details

testimport.fsm

testimport.xlsx

FlexSim 18.0.10
excel importcommands
capture.png (43.9 KiB)
capture.png (6.4 KiB)
testimport.fsm (16.6 KiB)
testimport.xlsx (8.6 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

zacharyh avatar image
1 Like"
zacharyh answered Braydn T commented

@asb.praneeth

I am unsure as to why this is happening, but I have been able to recreate it by just typing TRUE into excel before uploading it into FlexSim. But I found a work around by changing the format of the cell to Text before typing True. FlexSim was then able to upload the cell. (In the picture below "TRUE" in column J was from initially just typing "TRUE". The "TRUE" in column K, imported successfully import when I changed the cell format to Text before typing "TRUE" in the cell.

I'll keep looking into why it skips that cell.


testimport.png (53.8 KiB)
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Braydn T avatar image Braydn T commented ·

FlexSim does not accept boolean imports from excel. I have sent an email to the dev team to see if this is something they can add.

0 Likes 0 ·
asb.p avatar image asb.p commented ·

Thanks...! But I am looking for a complete solution...! Please let me know if you can resolve it. Since most of times, the content in excel will be tagged as General instead of text. So it will be helpful if the comand is rectified.

-1 Like -1 ·