Inventor General Discussion

Reply
Distinguished Contributor
achmidt
Posts: 130
Registered: ‎07-21-2011
Message 1 of 8 (490 Views)
Accepted Solution

Insert an Excel into inventor drawing

490 Views, 7 Replies
11-20-2013 07:37 AM

Hi!

I`m trying to insert an excel spread sheet in to inventor drawing, for some reason inventor cuts off 2 last rows. Is there a limit of how many rows can be inserted ?

 

it cuts off these two: see attached.

13.2    45FT     R2440    Gasket Material Vinyl Foam Strip 2" wide x .125 thk., Black, Weather-Resistant
14    12 TUBES    C11272    CAULK, SILICONE - CLEAR

 

Thanks,

Alex

Inventor Virtual Parts Addin

http://apps.exchange.autodesk.com/INVNTOR/en/Detail/Index?id=appstore.exchange.autodesk.com%3Avirtualpartsadd-in_windows32and64%3Aen
Distinguished Mentor
ccarreiras
Posts: 708
Registered: ‎02-04-2010
Message 2 of 8 (487 Views)

Re: Insert an Excel into inventor drawing

11-20-2013 07:51 AM in reply to: achmidt

Hi!

 

It's working well in 2014.

 

Did you find this reply helpful ? If so, use the  Mark Solutions!  Accept as Solution or Give Kudos!Kudos - Thank you!

 

2.png

Regards.
CarlosC

Autodesk Inventor 2014 Certified Professional
Autodesk Factory Design Suite Ultimate 2015
Windows 7 64Bit
Distinguished Contributor
achmidt
Posts: 130
Registered: ‎07-21-2011
Message 3 of 8 (479 Views)

Re: Insert an Excel into inventor drawing

11-20-2013 08:09 AM in reply to: ccarreiras
Well.... We are using 2012....
Inventor Virtual Parts Addin

http://apps.exchange.autodesk.com/INVNTOR/en/Detail/Index?id=appstore.exchange.autodesk.com%3Avirtualpartsadd-in_windows32and64%3Aen
Distinguished Mentor
ccarreiras
Posts: 708
Registered: ‎02-04-2010
Message 4 of 8 (470 Views)

Re: Insert an Excel into inventor drawing

11-20-2013 08:47 AM in reply to: achmidt

Hi!

 

Has to work also in 2012. Check if you are doing something wrong.

 

Check if you have installed all the updates for Inv2012.

 

Did you find this reply helpful ? If so, use the  Mark Solutions!  Accept as Solution or Give Kudos!Kudos - Thank you!

Regards.
CarlosC

Autodesk Inventor 2014 Certified Professional
Autodesk Factory Design Suite Ultimate 2015
Windows 7 64Bit
Distinguished Contributor
achmidt
Posts: 130
Registered: ‎07-21-2011
Message 5 of 8 (467 Views)

Re: Insert an Excel into inventor drawing

11-20-2013 08:50 AM in reply to: ccarreiras

Thank you, i tried 2 different ways using:
- Tools --> Paste Special
- Manage --> Insert Object
Both are cutting 2 last rows. Tried it on 3 different machines - same thing.
We use Inventor Suite 2012 64bit

Inventor Virtual Parts Addin

http://apps.exchange.autodesk.com/INVNTOR/en/Detail/Index?id=appstore.exchange.autodesk.com%3Avirtualpartsadd-in_windows32and64%3Aen
Valued Mentor
mpatchus
Posts: 452
Registered: ‎10-22-2008
Message 6 of 8 (443 Views)

Re: Insert an Excel into inventor drawing

11-20-2013 10:39 AM in reply to: achmidt

I seem to recall that at one point there was a limitation to the number of rows that could be imported.

Can't remember if it was for 2012 or not though.

 

Also check the Excel table for blank row or column.

 

From the 2012 HELP FILE....

 

NOTE:  Data is copied from the first worksheet only, starting at the specified cell.  When the source is an .xls or .csv file, data import stops when a blank row or column is encountered.

Mike Patchus

Inventor 2012 SP3 ~ Vault Pro 2013
==================
Lenovo D20 Workstation Intel Xenon E5640@2.67GHz (2)
Win 7, 24gb RAM, NVIDIA Quadro FX 3800

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below. :smileyhappy:
Valued Mentor
mpatchus
Posts: 452
Registered: ‎10-22-2008
Message 7 of 8 (436 Views)

Re: Insert an Excel into inventor drawing

11-20-2013 11:16 AM in reply to: mpatchus

A couple of related posts I found...

 

http://forums.autodesk.com/t5/Inventor-General/Missing-rows-from-inserted-Excel-object/m-p/3499014/h...

 

http://forums.autodesk.com/t5/Inventor-General/Excel-BOM/td-p/3483948/highlight/true

 

Font size in the Excel spreadsheet seems to be a common culprit.

Mike Patchus

Inventor 2012 SP3 ~ Vault Pro 2013
==================
Lenovo D20 Workstation Intel Xenon E5640@2.67GHz (2)
Win 7, 24gb RAM, NVIDIA Quadro FX 3800

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below. :smileyhappy:
Distinguished Contributor
achmidt
Posts: 130
Registered: ‎07-21-2011
Message 8 of 8 (430 Views)

Re: Insert an Excel into inventor drawing

11-20-2013 11:47 AM in reply to: mpatchus

Thank you. Changing font to a smaller font allows to bring entire sheet.

 

Inventor Virtual Parts Addin

http://apps.exchange.autodesk.com/INVNTOR/en/Detail/Index?id=appstore.exchange.autodesk.com%3Avirtualpartsadd-in_windows32and64%3Aen

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube