question

jing.c avatar image
0 Likes"
jing.c asked Jordan Johnson commented

Command excelopen() error in 2017.1.2, but work well in 2016

Hi everyone.

My friend's computer meet a strange error when use command excelopen().

An error will show as below in flexsim2017.1.2, while it works well in 2016 with the same code.

Any suggestion will be appreciated!

FlexSim 17.1.2
error messageexcel import
· 3
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jeff Nordgren avatar image Jeff Nordgren commented ·

@jing.chen

Just a thought, have you tried it in 17.1.4? Maybe it was a bug fix that they noticed.

0 Likes 0 ·
jing.c avatar image jing.c Jeff Nordgren commented ·

Thank you Jeff! But I tried to use the latest version(2017.1.4), it also show the error message. >_<

Maybe some inappropriate settings in Excel? I'm not quite sure...

0 Likes 0 ·
Wang Yang avatar image Wang Yang commented ·

@Ben Wilson @phil.bobo

For this question would you pls reply our engineer ?Thank you very much.

0 Likes 0 ·

1 Answer

·
Phil BoBo avatar image
2 Likes"
Phil BoBo answered Jordan Johnson commented

Does it work with FlexSim 17.0.7?

What versions of FlexSim 2016 does it work in? 16.0.9? 16.2.2?

What versions of Excel are installed on your computer?

What version of Windows are you using?

Does the path to the Excel workbook include Chinese characters?

Does it work on other computers? If so, what is the difference between the computers where it is working vs the ones where it isn't?

Have you tried reinstalling Excel like the solution to this similar question: Failed to initialize Excel Application?

Without more information, such as the answers to the questions above, we cannot begin to guess what might be causing that error message.

Is your problem similar to any of the following questions and solutions from Answers?

· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

jing.c avatar image jing.c commented ·

Many Thanks~ @phil.bobo

Below is what I do after reading your advice.

1. It works well in FlexSim 17.0.7

2. FlexSim2016.0.7 works well

3. Excel2016

4. No Chinese characte in the path to the Excel workbook

5. It works well in my computer and there are no clear differences between those two computers(including system or other related settings)

Firstly I tried to reinstall the Office like many answers' advice, but it still not work.

Finally I tried to install 2017.0.7, and it works.

I still wonder why it can not work in 2017.1.4

More advices will be appreciated!

0 Likes 0 ·
Jordan Johnson avatar image Jordan Johnson ♦♦ jing.c commented ·

The error code is actually an unsigned value, usually represented in hex. The error code is:

0x8002801D

TYPE_E_LIBNOTREGISTERED

This looks like somehow, the Excel registry keys are not present.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.