While using the Excel Interface, after all the worksheets are imported to global tables, the data import is successful but an error message pops up:
| Excel Read Error, Error closing the excel workbook. |
I only face this issue in version 16.1.0. No issues if the same workbook is imported using previous versions.
Excel is 2013 version.
Hi Matt,
Attached is the model and excel file.. there are no objects, just one global table to be populated.
There are no issues with your model or the excel file. What version of Excel are you using? What version of Windows?
@Imran, What about localizations? Are you using US EN copy of Windows and Office? If not, what localizations are you using?
Also architecture. Is Windows 32- or 64-bit? What about Office?
We were able to duplicate the issue on a Windows 7 VM with Excel 2013. Every other combination of Excel/Windows that we've tried have all worked fine.
We're working on fixing the error; it will probably be fixed for FlexSim 2016 Update 2.
For now, you can ignore the error message. Everything is working correctly, but it throws an exception as it is cleaning up a pointer at the very end of the excelclose() command.
7 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
