Path: news.mathworks.com!newsfeed-00.mathworks.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!e39g2000hsf.googlegroups.com!not-for-mail
From: Luna Moon <lunamoonmoon@gmail.com>
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 11:26:26 -0700 (PDT)
Organization: http://groups.google.com
Lines: 76
Message-ID: <7d045ca1-954d-43f9-8229-cedf4f737622@e39g2000hsf.googlegroups.com>
References: <6c992901-589d-4ff9-adf8-bcb55e97766a@v13g2000pro.googlegroups.com> 
NNTP-Posting-Host: 159.53.110.140
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1219861586 23940 127.0.0.1 (27 Aug 2008 18:26:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 27 Aug 2008 18:26:26 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e39g2000hsf.googlegroups.com; posting-host=159.53.110.140; 
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) 
Xref: news.mathworks.com comp.soft-sys.matlab:487537 comp.text.tex:393776 comp.text.pdf:86758



On Aug 27, 11:59=A0am, Ken Starks <stra...@lampsacos.demon.co.uk> 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 with=
out
> >>>>> losing quality. Any fast convenient way of doing so?
> >>>>> Any thoughts?
> >>>> "Print" them to a file using a postscript or PDF driver. =A0On a Mac
> >>>> this is as simple as choosing "Print" and then clicking on the
> >>>> "Save to PDF" button. =A0On a PC you'll need to... well, this page
> >>>> has all the details---http://www.freeopenbook.com/pdf-hacks/pdfhks-C=
HP-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 t=
o
> >>> 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
> >> =A0 =A0 each row and columns?
> >> =A0 =A0 Or do some cells span more than one row and column.
>
> >> 2. Do you have formatting you wish to preserve - bold, italics,
> >> =A0 =A0 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 us=
e:
> 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.

Could you please clearly list the steps to make PDF with tight
bounding box and no splitting across pages and fit every table each
into one page, (I mean, my Excel tables/charts were designed to be
inserted into a typical report which is readable on Letter size paper.
The width and height are very reasonable. )

How to do that?