question

Patrick Cloutier avatar image
0 Likes"
Patrick Cloutier asked Phil BoBo answered

Bug in Excel import tool ?

I'm importing an excel file into a Process Flow DateTimeSource table. However after removing lines from my Excel table and re-importing the table, the same lines I removed from the Excel table keep reappearing in my Flexsim table. It's as if Flexsim is not even looking at the Excel table and just puts the same data in the table that it probably had in a buffer somewhere. I've deleted the lines from the DateTimeSource table, restarted Excel and Flexsim, pressed Import Tables and redid all this 3 times and the same things always reappears in the table. I verified that the excel file name is the right one. I'm using Excel 365 on Office 10.

FlexSim 18.1.1
excel import
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

Phil BoBo avatar image
1 Like"
Phil BoBo answered

I can't replicate the issue. It seems to be working fine.

See the attached model and excel document. testdatetimesourceexcelimport.zip

If I open the Excel document, delete a row, save the document, close Excel, then import the Excel book into FlexSim, it removes that row from the DateTimeSource activity's table.

Here's a video showing it working fine: datetimesource-excelimport.zip

Please post an example model and excel file with step-by-step instructions on how to duplicate the issue you are having.


testdatetimesourceexcelimport.zip (24.3 KiB)
datetimesource-excelimport.zip (2.5 MiB)
· 1
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.

Patrick Cloutier avatar image Patrick Cloutier commented ·

Very sorry for the delay in coming back to you.

I'm not sure why I was having the problem but I don't anymore. I think it happened when I chose a Data Distinction method other than Automatic. Now it's on automatic and everything works fine.

Sorry for bothering you with this weird thing.

0 Likes 0 ·