Inventor General Discussion

Inventor General Discussion

Reply
Valued Contributor
nickv02
Posts: 68
Registered: ‎03-23-2012
Message 1 of 4 (526 Views)

Hide Cell Borders in Table driven by Excel

526 Views, 3 Replies
05-18-2012 11:10 AM

I am using a link to an .xls worksheet to populate a General Table in my .idw (Inventor 2012).  See attached.  The blank space underneath the first lines of information will always be blank, no matter how many rows we get.  Is there a way to have the drawing hide the blank/empty cells, make the borders invisible, etc? 

 

I have tried using the Insert Object for an Excel file instead of using the Table feature, but it does not appear to be an updatable link.  As in, if I change data in my .xls file, it won't update the inserted object to the same info.

 

Thanks in advance!

*Expert Elite*
mcgyvr
Posts: 6,821
Registered: ‎12-01-2004
Message 2 of 4 (519 Views)

Re: Hide Cell Borders in Table driven by Excel

05-18-2012 11:49 AM in reply to: nickv02

I doubt it..

 

If you use paste special and check the "link" box it will work just fine without using Inventors crappy general table functionality.  And you can hide the gridlines in excel too.

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

Down with IDW/DWG files..... Long live 3D PMI... Hurry it up already..
-------------------------------------------------------------------------------------
2015 Product Design Suite Ultimate
Windows 7 64 bit
Core i7 4820k processor (OC'd to 4.4Ghz), Nvidia GTX 770, 16G RAM


Valued Contributor
nickv02
Posts: 68
Registered: ‎03-23-2012
Message 3 of 4 (514 Views)

Re: Hide Cell Borders in Table driven by Excel

05-18-2012 11:58 AM in reply to: mcgyvr

Why does the inserted object have such terrible quality in the .idw?

 

Even when I print to PDF it looks terrible.

*Expert Elite*
mcgyvr
Posts: 6,821
Registered: ‎12-01-2004
Message 4 of 4 (499 Views)

Re: Hide Cell Borders in Table driven by Excel

05-18-2012 12:48 PM in reply to: nickv02

nickv02 wrote:

Why does the inserted object have such terrible quality in the .idw?

 

Even when I print to PDF it looks terrible.


Its always looked crappy in the IDW.. But its always fine when I print to PDF or a paper printout

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

Down with IDW/DWG files..... Long live 3D PMI... Hurry it up already..
-------------------------------------------------------------------------------------
2015 Product Design Suite Ultimate
Windows 7 64 bit
Core i7 4820k processor (OC'd to 4.4Ghz), Nvidia GTX 770, 16G RAM


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 or visit the Installation and Licensing Forum to get help installing your software.