Extract Component List

[GianlucaZerbo]

Hi.
I have a problem with a extraction component list in Excel format.
The codes of parts with"0" as a first number, do not extract the 0, for example: if code is 05788845, Inventor extract 5788845, this is a problem for import of list in my management program, becouse it do not recognize the code.

Excel have the selection with "display 0 in cells with value 0".

Before everything worked, with Inventor 2017 do not work anymore.

There is a solution to this problem?

Thanks more.

[mcgyvr]

Make sure you have applied all updates for Inventor 2017..I believe this was fixed in a service pack..

[GianlucaZerbo]

Tks for help... I have all version... but the problem still exists... 

[mcgyvr]

---

@GianlucaZerbo wrote:

Tks for help... I have all version... but the problem still exists... 

---

You are right

@Anonymous Johnson.. Can you look into this and provide an update on if this has been reported and if/when its going to be fixed..

Its a bug that hasn't been fixed yet I guess..

It does the same for me.. Inv 2017 R3

[inchul.lee · Accepted solution]

Hi @GianlucaZerbo and @mcgyvr,

This is a great catch. It appears that cell formatting is not working during export. We'll share an update of the investigation here.

In the meantime, you may consider a workaround of using an Excel template file.

The attached Excel file is just a blank file with its cell formatting set as 'Text'. Select it as a template.

Then, you should be able to get the correct result as below.

[GianlucaZerbo]

@inchul.lee thanks for the help.
where I find these options in Excel or Inventor?

[inchul.lee]

You can access it in Export Parts List window.

[GianlucaZerbo]

@inchul.lee don't have the options...

look...I have Inventor 2017

[inchul.lee · Accepted solution]

It's because you're accessing it in the assembly environment. You'll need to create a parts list table in the drawing environment and export it from there.

It's a workaround at the moment and the symptom is currently under investigation.

[GianlucaZerbo · Accepted solution]

@inchul.lee...I think I know.. tks more.

[GianlucaZerbo]

@inchul.lee...sorry... all works, but i have only another problem... 

in this list i look only principal parts, and extract only first level.

I need extract all parts, becouse I also need to import the sublevels.

[GianlucaZerbo]

@inchul.lee I think I found the solution yourself. Thank you