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
Solved! Go to Solution.
Has to work also in 2012. Check if you are doing something wrong.
Check if you have installed all the updates for Inv2012.
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
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.
A couple of related posts I found...
Font size in the Excel spreadsheet seems to be a common culprit.
Thank you. Changing font to a smaller font allows to bring entire sheet.