Excel into Solidworks

[RPCTony]

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?

 

[CorBlimeyLimey]

What are you copying from Excel?

​

Helpful SW websites faq559-520​

How to find answers ... faq559-1091​

SW2006-SP5 Basic ... No PDM​

 

[RPCTony]

Just some text and numbers.

 

[CorBlimeyLimey]

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

​

Helpful SW websites faq559-520​

How to find answers ... faq559-1091​

SW2006-SP5 Basic ... No PDM​

 

[RPCTony]

I'm copying and pasting what I select.

http://img68.imageshack.us/my.php?image=pageoh8.jpg

 

[ctopher]

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)

 

[CorBlimeyLimey]

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?

​

Helpful SW websites faq559-520​

How to find answers ... faq559-1091​

SW2006-SP5 Basic ... No PDM​

 

[CorBlimeyLimey]

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.

​

Helpful SW websites faq559-520​

How to find answers ... faq559-1091​

SW2006-SP5 Basic ... No PDM​

 

[RPCTony]

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.

 

[RPCTony]

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?

 

[CorBlimeyLimey]

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.

​

Helpful SW websites faq559-520​

How to find answers ... faq559-1091​

SW2006-SP5 Basic ... No PDM​

 

[RPCTony]

Thanks for all the input.

 

[RPCTony]

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.

 

[CorBlimeyLimey]

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

​

Helpful SW websites faq559-520​

How to find answers ... faq559-1091​

SW2006-SP5 Basic ... No PDM​

 

[TJMcD]

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.

 

[RPCTony]

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.