Insert an Excel into inventor drawing

[achmidt]

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

[CCarreiras]

Hi!

It's working well in 2014.

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

[achmidt]

Well.... We are using 2012....

[CCarreiras]

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    Accept as Solution or Kudos - Thank you!

[achmidt]

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

[mpatchus]

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.

[mpatchus · Accepted solution]

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.

[achmidt]

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