[Search tip detail and code files using keywords, tip number, author name, etc ]
Print an Excel Spreadsheet with a White Background
Tip# 4478 By Peggy Simpson On 01-Jun-2015
Rated By 0 users
Categories : Plot/Print
Software type : AutoCAD 2015
Rename File To : No Files to download.
Get an Excel spreadsheet to print a white background behind a table without linking it.

I was able to get an Excel spreadsheet to print a white background behind the table inserted in a drawing without linking it.
It has come to my attention that this may be a printer issue, but I can’t tell for certain.
When I selected the rows and columns of a spreadsheet to do a copy/paste and place it into my drawing, it looked fine until I tried to print it.
The background printed black where the Excel spreadsheet was placed, and the column & row lines and all of the text printed white.
That was the opposite of what I wanted to do. I selected the table and went into the Properties dialog settings of the OLE object, and under Misc I set the “plot quality” drop down from “Monochrome” to “High Graphics.” The printer produced the Excel spreadsheet with a white background and black text and table outline rows and columns.

Notes from Cadalyst tip review R.K. McSwain: We tested this using AutoCAD 2016 and could not recreate the black background issue that is the source of this tip. However printing relies on many variables such as print driver, print hardware, version of AutoCAD, etc. that it's quite possible the problem described here could affect many users out there. Let us know your results in the comments.


Average Rating:

User comments