Re: Table trouble (multi-page, multi-colour)

On 7 jun, 00:43, Werner <wgrundli...@xxxxxxxxx> wrote:
Sorry, but there are a lot of confusing elements in your post.

I'm trying to import a table as-is from Excel. It's fairly simple: it
has alternating colours for each row, but it's also a bit long. Now
I've tried Excel2LaTeX and LaTable, but none of those programs do the
work. In both cases, the tables just run through the edge of the page
they were started on, and I can't seem to get the colouring right. How
should I go about? Shall I boldly insert an image of my table? But
that doesn't make it searchable, so I'm also opting out of that one.

I'm not familiar with Excel2LaTeX or LaTable, but I get sufficiently
'nice' tables...for a lack of a better adjective...with coloured rows
using a combination of the booktabs (for tabular layout) and colortbl
(for colour in the table) packages:
http://tug.ctan.org/cgi-bin/ctanPackageInformation.py?id=booktabs
http://tug.ctan.org/cgi-bin/ctanPackageInformation.py?id=colortbl
You could format the column separators (&) in Excel, together with row
delimiters (\\) and text copy-and-paste the table in your LaTeX source
code... Additionally, you could also type row colour codes (see the
colortbl package documentation for this) into Excel cells before you
copy-and-paste.

Also, inserting a searchable image of the table into the document
would still make it searchable. For example, export the table as a PDF
image/document, and import it using \includegraphics[...]{...} using
\usepackage{graphicx}

A third point of trouble is that the table could easily have twice the
amount of columns, thus wrapping at the bottom of the page and
continuing next to where it started. It would still take more than one
page for everything to fit, but that's beside the point. I can also do
this manually, but is there a way to do this automagically?

How could a table with 'more columns' now 'wrap at the bottom of the
page'? Anyways, a number of solutions would be to:
(1) change the page dimensions specifically for the page that contains
the BIG table. For this you could consider the geometry package;
http://tug.ctan.org/cgi-bin/ctanPackageInformation.py?id=geometry
(2) change/re-arrange your table layout so that it fits within the
page margins;
(3) use a package like longtable or supertabular that would
accommodate BIG tables;
http://tug.ctan.org/cgi-bin/ctanPackageInformation.py?id=longtable
http://tug.ctan.org/cgi-bin/ctanPackageInformation.py?id=supertabular

'automagically'...Mmmm, nifty neologism!

Werner

Thank you, I'll look into that, although it seems there's going to be
quite some work to put colour codes at the beginning of each row
manually. You seemed to suggest something about doing that in Excel
before I even paste it into LaTeX, but I can't figure out what you
mean. Also doing the & and // things already in Excel, doesn't ring a
bell here.

What I meant with wrapping a table was this (I'll try to visualise it)

| column1 | column2 |
| | |
| | |____
| | |
|________|________|

now see, at the ___ I want to split my table in twain (precious
mediaeval language) and continue next to the beginning of column 1 and
2, thus:

| column1 | column2 | column1 | column2 |
| | | | |
|________|________|________ |________|

I hope that made it clear somehow. And thanks a lot in advance for
your time and help!

kind regards

Sander

.

Relevant Pages

  • Re: Drop & Create Table - DTS Export to Excel
    ... Allan, ... That is to say that on the initial execution of the ... package, the data fell into place perfectly and as expected. ... if I open the Excel file and manualy delete all affected rows and ...
    (microsoft.public.sqlserver.dts)
  • Re: Distributed Access references
    ... understand from trying to package an app and working w/ ... Although it appears that the excel does get packaged by ... So my app relies on the user having their own ... As for the other references I am not sure what to do? ...
    (microsoft.public.access.devtoolkits)
  • Re: I cant make hammock tasks work
    ... scheduelling package that computes the dates for you. ... costs and the costs will also be calculated, ... In Excel you can just start typing in numbers and away ...
    (microsoft.public.project)
  • Re: Distributed Access references
    ... > understand from trying to package an app and working w/ ... > excel to be run from my app. ... ***If Excel is installed on the target machines, then there is no need to ... application's references in locations other than what my references have ...
    (microsoft.public.access.devtoolkits)
  • Re: Drop & Create Table - DTS Export to Excel
    ... Allan Mitchell MCSE,MCDBA, ... I can get the Excel tables to drop ... That is to say that on the initial execution of the ... > package, the data fell into place perfectly and as expected. ...
    (microsoft.public.sqlserver.dts)