topic Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout in Inventor Forum

Importing a Parts List (Excel Table) Into Inventor Drawing Layout

Anonymous — Fri, 28 Sep 2018 14:10:45 GMT

Good afternoon forum,

I'll keep it simple. I want to be able to import a basic excel spreadsheet into my Inventor drawing to show as a spare parts list that I can then update in Excel when it is necessary to do so.

I have read a couple of other posts on the forum which do not seem to have clear cut answers as to whether this is possible.

Can anyone clarify for me, in Inventor 2019, is it possible to do this?

Thanks,

Tim

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

mcgyvr — Fri, 28 Sep 2018 14:16:31 GMT

select all the data in excel and then copy..

Then use "paste special" in Inventor and check the "link" button so that changes to excel are updated on the drawing.

Note there are some limitations with anything but fairly small tables... Don't expect a massive excel table to come in properly.. But a simple spare parts list should be easy..

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

Anonymous — Fri, 28 Sep 2018 14:33:02 GMT

Thanks for your advice, I couldn't find how to do the paste special to take data in to the drawing.

However, I did find that I can just use the Annotate>Table>General function and select an excel spreadsheet from the source button and then it imports directly.

Thank you anyway!

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

Cadmanto — Fri, 28 Sep 2018 14:53:16 GMT

Tim,

What about the insert object command?

https://forums.autodesk.com/t5/inventor-forum/inserting-excel-spread-sheets-into-inventor-drawings/td-p/3417571

Windows 10 x64 -16GB Ram
Intel i7-6700 @ 3.41ghz
nVidia GTS 250 - 1 GB
Inventor Pro 2018

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

Anonymous — Thu, 04 Oct 2018 07:32:24 GMT

Hello All,

Thank you for your advice and suggestions. I found for my needs, the best solution was to use the Annotate>General under the table heading and select the source file to be my excel spreadsheet I wished to use as a parts list. This worked really well and meant that when I added new items into the table, I could simply click 'Update' in Inventor and the new lines would be added into the parts list on the drawing.

TRA

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

Cadmanto — Thu, 04 Oct 2018 11:46:54 GMT

Glad you fond something that worked for you. You can also in the styles format this table to better suite what you are looking for as well.

Windows 10 x64 -16GB Ram
Intel i7-6700 @ 3.41ghz
nVidia GTS 250 - 1 GB
Inventor Pro 2018

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

SF8906 — Mon, 15 Apr 2019 20:34:07 GMT

Yeah but using a general table removes a lot of the functionality you get in Parts Lists. Renumber is not available, for example.

This is yet another reason my company will be switching to another software next year.

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

branjithkumar — Thu, 20 Jul 2023 12:03:20 GMT

I want to delink the excel from the table and i need edit the table its possible?

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

johnsonshiue — Thu, 20 Jul 2023 21:12:34 GMT

Hi! It should just work. Please share the files in zip here. I would like to understand why it cannot be delinked. In the meantime, go to Tools -> Link -> break the link there,

Many thanks!

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

branjithkumar — Wed, 26 Jul 2023 07:16:48 GMT

Hi Johnson Shiue ,

Thank you for the reply. I have attached the file with table which is delinked from Excel. Kindly check. I believe you cannot edit it.

Thank you in advance for your help.

Looking forward to the solution

Re: Importing a Parts List (Excel Table) Into Inventor Drawing Layout

johnsonshiue — Wed, 26 Jul 2023 23:29:25 GMT

Hi! I see the issue now. You would like to keep the content of the general table intact but unassociate it with the Excel file since it is no longer available. Unfortunately, there isn't a workflow like that. You will need to delete the table and recreate it manually.

Many thanks!