TheSwamp

CAD Forums => CAD General => Topic started by: Fabricio28 on October 24, 2018, 07:24:57 AM

Title: Print an Excel Spreadsheet with White Background
Post by: Fabricio28 on October 24, 2018, 07:24:57 AM
Hi guys

I'm trouble to plot excel table from auto cad.

In the model space it is plotting fine, background white and the text is black.👍

But when I'm plotting at the paper space, using viewport the background is black.

I don't know what to do to fix it.

Anybody could help me, please?

Thanks
Fabrício
Title: Re: Print an Excel Spreadsheet with White Background
Post by: sljohnson on October 24, 2018, 01:25:51 PM
Uncheck "Plot Transparency" in the Plot Options of the plot dialog window.
Title: Re: Print an Excel Spreadsheet with White Background
Post by: Fabricio28 on October 24, 2018, 01:40:14 PM
Thank for replay

But it isn't working.

I took a picture of the Excel Spreadsheet with Black Background.

I don't konw how but the excel spreadsheet bellow is white.

Thanks
Title: Re: Print an Excel Spreadsheet with White Background
Post by: ronjonp on October 24, 2018, 03:04:01 PM
Try to change the ole plot quality to 'Monochrome'.
Title: Re: Print an Excel Spreadsheet with White Background
Post by: Fabricio28 on October 24, 2018, 03:06:42 PM
Try to change the ole plot quality to 'Monochrome'.

Hi my old friend Ron,

The OLE plot quality is already monochrome.

Title: Re: Print an Excel Spreadsheet with White Background
Post by: Fabricio28 on October 24, 2018, 03:26:49 PM
The layout model seems to be ok!

I don't know what's wrong.

Thanks
Fabrício
Title: Re: Print an Excel Spreadsheet with White Background
Post by: Willie on October 25, 2018, 05:55:04 AM
Have you tried to plot a pdf?

Are there a white fill in the excel sheet?  Or are the cells set to "No Color" fill.

and, set the OLE object to High Quality.

Title: Re: Print an Excel Spreadsheet with White Background
Post by: Fabricio28 on October 25, 2018, 07:17:31 AM
Have you tried to plot a pdf?

Are there a white fill in the excel sheet?  Or are the cells set to "No Color" fill.

and, set the OLE object to High Quality.

Hi Willie
How are you?

I've already tried to plot to a pdf with the same ctb file, and worked Fine.

The excel sheet is set to " No Color" fill. And I've tried to change to plot quality to "High graphics".

I've inserted the excel sheet several times.

I don't know what to do.  :crazy2:
Title: Re: Print an Excel Spreadsheet with White Background
Post by: Fabricio28 on October 25, 2018, 09:36:38 AM
Guys

I had to inserted the excel sheet over to layout model, not using viewport.
And worked Fine!

If anyone has a better solution to plot using viewport, it will be very wellcome.
Because I don't like using excel sheet from layout model. I would rather to model space.  :-D

Thanks
Title: Re: Print an Excel Spreadsheet with White Background
Post by: mjfarrell on October 25, 2018, 11:42:30 AM
have you tried actually importing the table through a link, instead of as an OLE object?
Title: Re: Print an Excel Spreadsheet with White Background
Post by: Fabricio28 on October 25, 2018, 01:39:34 PM
have you tried actually importing the table through a link, instead of as an OLE object?

Hello mjfarrell

I don't like import as auto cad table, I would rather excel sheet.

I've always pasted especial with a link, it always worked fine for me.
I don't understand what it is worng now.

Thanks
Fabrício