[OS X TeX] Excel tables to LaTeX - new script

Alain Schremmer schremmer.alain at gmail.com
Wed Jul 15 11:46:42 EDT 2009


On Jul 15, 2009, at 11:07 AM, Ross Moore wrote:

> It is very easy to add extra columns for the & symbols,
> and "fill down"; similarly for the '\\' or '\cr' at the
> end of each row. Then a simple Copy-Paste into your
> text editor (TeXshop ?) gives most of what you'll need
> to get the table into a form acceptable to LaTeX.
>
> Of course if you have merged cells, then it gets a bit
> more complicated, but the principles are the same:
>  --- add more columns to put the extra markup, even
> if only a single '}'.
>
> It can also help to work with a 2nd copy of your table,
> in the Spreadsheet, obtained using 'Copy' then
> 'Paste Values' (into a new worksheet, say). This overcomes
> any difficulties that may result from formulas or rounding
> in floating-point data.
>
>
>>
>> But tables CAN be a pain in the whatever to do in LaTeX.
>>
>> As for the rest, how about TeXTable? I have it, I have used it but  
>> I am not too much into tables so I cannot really say. Also,  
>> doesn't Open Office translate in LaTeX too?
>
> I've never used a special tool to get from Excel
> to LaTeX. Some simple actions, as outlined above,
> have been sufficient for some quite complicated
> tables that I've worked with over many years.

As I said, I don't do much spreadsheet anymore these days and not  
many tables either but the above has gone in my special file "Look  
here when the roof is about to cave in."

As always, very grateful regards
--schremmer



More information about the MacOSX-TeX mailing list