Path: news.mathworks.com!newsfeed-00.mathworks.com!kanaga.switch.ch!switch.ch!news.belwue.de!news.germany.com!dedekind.zen.co.uk!zen.net.uk!demorgan.zen.co.uk!peer1.news.newnet.co.uk!194.159.246.34.MISMATCH!peer-uk.news.demon.net!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail
From: Ken Starks <straton@lampsacos.demon.co.uk>
Newsgroups: comp.soft-sys.matlab,comp.text.tex,comp.text.pdf
Subject: Re: how to convert Excel tables/charts into EPS or PDF without losing
Date: Wed, 27 Aug 2008 17:22:07 +0100
Lines: 81
Message-ID: <g93uvg$sd5$1$8300dec7@news.demon.co.uk>
References: <6c992901-589d-4ff9-adf8-bcb55e97766a@v13g2000pro.googlegroups.com> 	<eae23df1-bff7-4bb1-84e3-711603d2c122@s20g2000prd.googlegroups.com> 	<f4b2f7a5-535f-426f-9c30-8708b078e98c@m3g2000hsc.googlegroups.com> 	<g934o2$1nb$1$8302bc10@news.demon.co.uk> <33e5bc81-53a0-4752-88cf-e15f74521676@f36g2000hsa.googlegroups.com> <g93tl0$qor$1$8300dec7@news.demon.co.uk>
NNTP-Posting-Host: lampsacos.demon.co.uk
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.demon.co.uk 1219854128 29093 62.49.22.91 (27 Aug 2008 16:22:08 GMT)
X-Complaints-To: abuse@demon.net
NNTP-Posting-Date: Wed, 27 Aug 2008 16:22:08 +0000 (UTC)
In-Reply-To: <g93tl0$qor$1$8300dec7@news.demon.co.uk>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
Xref: news.mathworks.com comp.soft-sys.matlab:487511 comp.text.tex:393771 comp.text.pdf:86754



Ken Starks wrote:
> LunaMoon wrote:
>> On Aug 27, 4:54 am, Ken Starks <stra...@lampsacos.demon.co.uk> wrote:
>>> Luna Moon wrote:
>>>> On Aug 26, 8:17 am, David Klassen <klas...@rowan.edu> wrote:
>>>>> On Aug 26, 8:09 am, Luna Moon <lunamoonm...@gmail.com> wrote:
>>>>>> how to convert Excel tables/charts into EPS or PDF?
>>>>>> Hi all,
>>>>>> I am creating tables and charts in Excel and then I want to convert
>>>>>> them into EPS or PDF (one chart/table per pdf file) so I could use
>>>>>> them in Latex. It is also a means of maintaining tables/charts 
>>>>>> without
>>>>>> losing quality. Any fast convenient way of doing so?
>>>>>> Any thoughts?
>>>>> "Print" them to a file using a postscript or PDF driver.  On a Mac
>>>>> this is as simple as choosing "Print" and then clicking on the
>>>>> "Save to PDF" button.  On a PC you'll need to... well, this page
>>>>> has all the 
>>>>> details---http://www.freeopenbook.com/pdf-hacks/pdfhks-CHP-4-SECT-9.html 
>>>>>
>>>>> I did this for my WinXP setup and it works wonderfully.
>>>> this is bad because when you print to pdf the one table is splitted to
>>>> several pages and cropped.
>>> I suddenly feel a need to clarify your question, Luna.
>>>
>>> 1. Are your Excel tables pretty much simple data in cells, one cell to
>>>     each row and columns?
>>>     Or do some cells span more than one row and column.
>>>
>>> 2. Do you have formatting you wish to preserve - bold, italics,
>>>     and so on.
>>>
>>> 3. Do you have row or Cell border-lines you wish to preserve ?
>>>
>>> The answers to these questions may not only alter the difficulty
>>> of the task, but also affect whether LaTeX is an appropriate
>>> solution at all.
>>>
>>> Cheers,
>>> Ken.
>>
>> Sure, my tables and charts in Excel have lots of decorations and
>> patterns and colors that we don't want to lose.
>>
>> Probably the easiest is to Save As pdf, but I hope it has a tight
>> bounding box. I just need to convert a selection of table/chart into
>> PDF, not the whole document or the whole sheet. Without a tight
>> bounding box, how can I use it in Latex?
>>
> 
> Yes, I would agree. There is a slight difference between 'save as PDF'
> and 'Print to PDF' which you might need to investigate.
> 
> It all comes down to the quality of the driver. I have the
> luxury of acrobat professional on my machine, and the results
> of 'Print to PDF' are excellent. You would first select your table and use:
> menubar -->file --> set Print Area -->
> 
> This gives a PDF the correct size, and restricted to the selected area.
> (You can use print preview before preesing the print button if
> you like)
> 
> As for your other problem, of a table being split over two pages, a
> good driver allows you to set an arbitrary pages size for the
> final PDF, so a bit of experimentation is all you need.
> 
> What you won't have, with this method, is matching font style and size 
> with the fonts in the remainder of your document.
> 
> 

I forgot to mention that you may wish to press the document
Properties button in your PDF Printer box, where you can set up
a custom pages size, or a few.

If you tables are a large variety of sizes, you would
possibly be better off cropping them one at
a time after converstion to PDF.