Bug in Excel import tool ?

Question

question

Patrick Cloutier asked Jun 26, '18 Phil BoBo answered Jul 13, '18

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.

Software Version:

FlexSim 18.1.1

excel import

Answer 1 · 2018-06-27T19:17:01Z

Phil BoBo answered Jun 27, '18

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

Patrick Cloutier commented · Jul 13, 2018 at 01:39 PM

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 ·

question