Inventor General Discussion

Inventor General Discussion

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

Hide Cell Borders in Table driven by Excel

572 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: 7,073
Registered: ‎12-01-2004
Message 2 of 4 (565 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.

-------------------------------------------------------------------------------------
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 (560 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: 7,073
Registered: ‎12-01-2004
Message 4 of 4 (545 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.

-------------------------------------------------------------------------------------
2015 Product Design Suite Ultimate
Windows 7 64 bit
Core i7 4820k processor (OC'd to 4.4Ghz), Nvidia GTX 770, 16G RAM


Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.