AutoCAD 2013/2014/2015

AutoCAD 2013/2014/2015

Reply
Member
TS8483
Posts: 4
Registered: ‎09-22-2010
Message 1 of 10 (2,730 Views)
Accepted Solution

Problem with Printing pasted excel table with color fill

2730 Views, 9 Replies
01-17-2013 10:35 PM

 

Hi All,

Formally I'm able to print pasted excel table with default colors ( ie: cell with text and fill with color background in autocad. By using Autocad 2013, with I can see the default colors when preview, but once I printed out to hard copy or PDF format, its only printed text but without any color background, I have try to print the pdf file by using DWG To PDF.pc3, Adobe PDF & CutePDF Writer, HP Design Jet T1120 plotter, all have the same result, anyone can help?

Hi, I have try to change the option as you memtion, it dosn't work. Even I repaste the excel file into autocad, still have the same problem. Finally, I'm manage to slove the problem by refill all the color background in excel file and repaste it back to autocad, even if you dont  set your Plot Options to " "Automatic", it still able to print out all colors as show in the preview. Thanks for all the replies and suggestions.

 

*Expert Elite*
pendean
Posts: 23,617
Registered: ‎11-06-2003
Message 2 of 10 (2,711 Views)

Re: Problem with Printing pasted excel table with color fill

01-18-2013 05:54 AM in reply to: TS8483

Exact method you got Excel into AutoCAD?

Excel version?

Dean Saadallah Blog | Facebook | Google+ | Twitter | PINS
Member
TS8483
Posts: 4
Registered: ‎09-22-2010
Message 3 of 10 (2,687 Views)

Re: Problem with Printing pasted excel table with color fill

01-20-2013 05:37 PM in reply to: pendean

Hi, I'm using MS Excel 2010. I have try to print the same file by using Auocad 2010,  all the excel's cell with color fill background able to print out as shown in the preview. I also try to print from Acad 2012, having the same problem as in Acad 2013. So seems like the problem is from Autocad  version, noting to do with the MS Excel version.

*Expert Elite*
pendean
Posts: 23,617
Registered: ‎11-06-2003
Message 4 of 10 (2,670 Views)

Re: Problem with Printing pasted excel table with color fill

01-21-2013 05:54 AM in reply to: TS8483

I can definitely repeat the problem in R2011 through R2013. It's broke.

Dean Saadallah Blog | Facebook | Google+ | Twitter | PINS
Distinguished Contributor
MariuszPL
Posts: 109
Registered: ‎02-06-2007
Message 5 of 10 (2,660 Views)

Re: Problem with Printing pasted excel table with color fill

01-21-2013 10:37 AM in reply to: TS8483

Go to Options and check Plot and Publish tab. In General Plot Options section you can find OLE Plot Quality. It is possible that you have "Monochrome" option there, but even if it's "Automatic" try to change it to "Low graphics".

Member
TS8483
Posts: 4
Registered: ‎09-22-2010
Message 6 of 10 (2,639 Views)

Re: Problem with Printing pasted excel table with color fill

01-21-2013 06:35 PM in reply to: MariuszPL

Hi, I have try to change the option as you memtion, it dosn't work. Even I repaste the excel file into autocad, still have the same problem. Finally, I'm manage to slove the problem by refill all the color background in excel file and repaste it back to autocad, even if you dont  set your Plot Options to " "Automatic", it still able to print out all colors as show in the preview. Thanks for all the replies and suggestions.

 

Contributor
Adrian010
Posts: 20
Registered: ‎04-30-2009
Message 7 of 10 (2,195 Views)

Re: Problem with Printing pasted excel table with color fill

09-24-2013 03:27 PM in reply to: TS8483

Check out this link

I just ran into the same issue and was able to solve it with this method.

 

Cheers

    Adrian

 

http://twominutetbg.blogspot.ca/2010/02/how-to-import-excel-spreadsheets-into.html

Member
TS8483
Posts: 4
Registered: ‎09-22-2010
Message 8 of 10 (2,184 Views)

Re: Problem with Printing pasted excel table with color fill

09-24-2013 06:08 PM in reply to: TS8483

Hi Adrian,

Thanks for your reply. I hv learn something new from you! :smileyhappy:

New Member
hidalgog
Posts: 1
Registered: ‎12-03-2013
Message 9 of 10 (2,001 Views)

Re: Problem with Printing pasted excel table with color fill

12-03-2013 08:45 AM in reply to: TS8483

Great tip Adrian


TS8483 wrote:

 

Hi All,

Formally I'm able to print pasted excel table with default colors ( ie: cell with text and fill with color background in autocad. By using Autocad 2013, with I can see the default colors when preview, but once I printed out to hard copy or PDF format, its only printed text but without any color background, I have try to print the pdf file by using DWG To PDF.pc3, Adobe PDF & CutePDF Writer, HP Design Jet T1120 plotter, all have the same result, anyone can help?


 

New Member
kristinefair
Posts: 1
Registered: ‎02-18-2010
Message 10 of 10 (1,090 Views)

Re: Problem with Printing pasted excel table with color fill

06-15-2014 09:09 PM in reply to: TS8483

Hi I know this post is old already i just want to help. For those having problems plotting colored excel sheet in autocad and changing the OLE plot quality in Options doesn't work you can try this method:

Select the OLE (spreedsheet), then go to properties under Misc change the plot quality to either low or high graphics. :smileyhappy:

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.