Inventor General Discussion

Inventor General Discussion

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

Hide Cell Borders in Table driven by Excel

602 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,163
Registered: ‎12-01-2004
Message 2 of 4 (595 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 (590 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,163
Registered: ‎12-01-2004
Message 4 of 4 (575 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
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!