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

Question

question

jing.c asked Aug 08 2017 at 11:21 AM Jordan Johnson commented May 09 2018 at 6:19 PM

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!

Software Version:

FlexSim 17.1.2

error message excel import

excel-error-2017.png (9.2 KiB)

· 3

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2017-08-14T15:09:39Z

Phil BoBo answered Aug 14 2017 at 3:09 PM Jordan Johnson commented May 09 2018 at 6:19 PM

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

jing.c commented · Aug 15 2017 at 2:36 AM

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 ·

Jordan Johnson ♦♦ jing.c commented · May 09 2018 at 6:19 PM

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 ·

question