excelimporttable command Issue

Question

question

asb.p asked Jun 20, '19 Braydn T commented Jul 11, '19

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

Software Version:

FlexSim 18.0.10

excel import commands

capture.png (43.9 KiB)

capture.png (6.4 KiB)

testimport.fsm (16.6 KiB)

testimport.xlsx (8.6 KiB)

Answer 1 · 2019-06-20T21:40:55Z

zacharyh answered Jun 20, '19 Braydn T commented Jul 11, '19

@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

Braydn T commented · Jul 11, 2019 at 02:24 PM

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 ·

asb.p commented · Jul 02, 2019 at 12:05 PM

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 ·

question