Excel Interface raises error "Error closing the excel workbook" after importing data - version 16.1

Question

question

Imran asked Jul 27, '16 Phil BoBo answered Jul 28, '16

Excel Interface raises error "Error closing the excel workbook" after importing data - version 16.1

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.

Software Version:

FlexSim 16.1.0

error message excel import excel interface

excel-error.jpg (30.0 KiB)

· 6

Matt Long commented · Jul 27, 2016 at 08:42 PM

Can you attach your model and excel file?

0 ·

Imran Matt Long commented · Jul 28, 2016 at 02:05 AM

Hi Matt,

Attached is the model and excel file.. there are no objects, just one global table to be populated.

excel-error.zip

0 ·

excel-error.zip (18.6 KiB)

Matt Long Imran commented · Jul 28, 2016 at 03:16 PM

There are no issues with your model or the excel file. What version of Excel are you using? What version of Windows?

0 ·

Show more comments

Durga Ghosal commented · Jul 28, 2016 at 04:00 PM

I am also facing the same issue, any fixes.

0 ·

Ben Wilson ♦♦ commented · Jul 28, 2016 at 08:40 PM

@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?

0 ·

Answer 1 · 2016-07-28T22:15:25Z

Phil BoBo answered Jul 28, '16

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.

question