×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel into Solidworks

Excel into Solidworks

Excel into Solidworks

(OP)
I'm copying from Excel into solidworks and everything works and looks fine until I try to publish to edrawings, everything I copied from Excel looks blurry as an edrawing. Has anyone had this problem?

RE: Excel into Solidworks

(OP)
Just some text and numbers.

RE: Excel into Solidworks

OK, to answer your original question, no I have not had this problem.

Are you doing a copy-n-paste into a note or inserting an OLE object or ???

Can you post a screenshot? FAQ559-1100

cheers
Helpful SW websites FAQ559-520
How to find answers ... FAQ559-1091

RE: Excel into Solidworks

Interesting. Excel spreadsheet in a SW dwg does not show up in eDrawings for me. It just shows an outline.

Chris
Systems Analyst, I.S.
SolidWorks 06 4.1/PDMWorks 06
AutoCAD 06
ctopher's home (updated 06-21-06)

RE: Excel into Solidworks

I can't tell from the image what is and isn't blurred ... it all looks blurred on my screen at that resolution.

Check to make sure that the font you are using in Excel matches the font used in SW. If the SW drawing looks OK, it shouldn't change in eDrawing, but it's worth a try.

Is everything on the white background being copied-n-pasted 'en masse' from an Excel spreadsheet?

cheers
Helpful SW websites FAQ559-520
How to find answers ... FAQ559-1091

RE: Excel into Solidworks

OK, I have just produced a similar setup as shown in your image, and I now see the problem you are having.

However if you zoom in on the SW drawing you will (may) see that the resolution is not as good as the native SW annotations. An OLE object is just an image of the original, so I assume image degradation is taking place and being exagerated when converting to eDrawing.

cheers
Helpful SW websites FAQ559-520
How to find answers ... FAQ559-1091

RE: Excel into Solidworks

(OP)
The font is the same and it looks fine in solidworks. It doesn't show up with a white background in solidworks. I am opening up the excel file, selecting what I want to copy, adding a new sheet to a file in solidworks and pasting.

RE: Excel into Solidworks

(OP)
If I zoom in close I see it's not as clear, is there a fix or should I say different way of inserting excel information?

RE: Excel into Solidworks

Not that I know of, but then I didn't know this problem existed till now.

You could try experimenting with Design Tables & General
Tables.

cheers
Helpful SW websites FAQ559-520
How to find answers ... FAQ559-1091

RE: Excel into Solidworks

(OP)
Thanks for all the input.

RE: Excel into Solidworks

(OP)
Well it doesn't look perfect but it's a lot better. I published a edrawing with edrawings instead of solidworks and it's legible.

RE: Excel into Solidworks

Glad you found a "workaround". Thanks for the feed back.
You should let your VAR & SW know of the problem & solution.

cheers
Helpful SW websites FAQ559-520
How to find answers ... FAQ559-1091

RE: Excel into Solidworks

RPCTony, if you right-click on the table created when you paste your Excel data into the drawing, you'll see an item PROPERTIES.  Selecting that brings up a dialog box with four items:  Width, Height, Scale, and a check box "Sharpen Zoomed State".

You might try that check box.  It sometimes improves print quality for us, but its true function doesn't seem well defined.

RE: Excel into Solidworks

(OP)
Thanks TJMcD, I had already tried that. It doesn't look to bad published with edrawings. I'll stick with that until I hear back from solidworks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources