Jump to content
eyeofnewt555

Clipping Boundary on an OLE?

Recommended Posts

eyeofnewt555

Hi!

 

Is there a way to use a clipping boundary on an OLE from excel?

 

I've tried blocking it and then using xclip, but oddly it clips everything _except_ the OLE.

 

Basically, I've got multiple tables I want to display throughout the drawing and I'd like them to be linked to a single excel, while still being embedded rather than linked to an external excel file.

 

I've been able to use an excel OLE within blocks before to accomplish this for the same table repeated throughout a drawing, but I'm hitting a dead end for doing this with multiple tables.

 

Thanks!

Share this post


Link to post
Share on other sites
halam

Put it in a block and clip that.

maybe..

Share this post


Link to post
Share on other sites
eyeofnewt555

I tried that. It doesn't clip the OLE part. At least not using XCLIP.

Share this post


Link to post
Share on other sites
halam

Too bad.

Why OLE? Image has this advantage and some more..

Share this post


Link to post
Share on other sites
eyeofnewt555

I'm doing this for excel tables that I'll be regularly updating, so a raster image wouldn't work.

Share this post


Link to post
Share on other sites
halam

But why not use the data link technique to link to excel sheet then..?

ole seems as the most unlogic way

Share this post


Link to post
Share on other sites
eyeofnewt555

Using a data link will still be OLE. It would just be convenient and reduce risk of divergent copies if everything were embedded within the drawing file rather than linked from an external excel file.

 

But I see where you're coming from. Linking from an external file would be a fix, but not an ideal fix for my situation.

Share this post


Link to post
Share on other sites
rkmcswain

I know this introduces ONE MORE STEP - but what we do is print the Excel to PDF, then reference the PDF into ACAD.

As long as the person who is updating the Excel file remembers to print to PDF, then your ACAD version will be up to date.

 

This also has the benefit (over Data Link in post #6), of the data being WYSIWYG.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×