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
Solved! Go to Solution.
Solved by mpatchus. Go to Solution.
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...
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.
Can't find what you're looking for? Ask the community or share your knowledge.