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

Alan T Litchfield alan at alphabyte.co.nz
Wed Jul 15 17:04:12 EDT 2009

Well, this has been an interesting thread.

I guess that I am a bit of a luddite when it comes to tables and have  
always, when moving from excel to LaTeX worked from a csv file and  
grepped in the LaTeX code if it were large. These approaches are very  
interesting and I am looking forward to trying some of them out.

Unfortunately Office 2008 does not have proper support for VB and MSs  
work-around is pathetic (having Office 2004 installed just so I can  
preserve VB scripts, sheesh), so the great looking VB script is not an  
option and for the forseeable future I will not have time to convert  
it to AppleScript :(

But I just want to say thank you to all who have provided links to  
some very interesting tools. These enable good cross communication  
between users with varying skill sets.


On 16/07/2009, at 3:53 AM, Maxwell, Adam R wrote:

> On 07/15/09 08:42, "Alan Munn" <amunn at msu.edu> wrote:
>> At 11:07 AM -0400 7/15/09, Ross Moore wrote:
> [...]
>>> 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.
> Providing you have the flexibility to edit your Excel table, I think  
> your
> approach is good.  If it's shared with non-LaTeX users (as all of  
> mine were
> in grad school), you have to make temporary copies and redo your & \\
> columns each time the sheet changes.
>> I agree with this.  The script simply makes the formatting as simple
>> as cut and paste, which even for small tables makes the work faster.
>> (Of course, it doesn't deal with merged cells intelligently either.)
> IIRC Tabular.xla did a good job preserving merged cells and text  
> formatting
> from Excel.  However, since I'm now stuck with Excel 2008 at work, I  
> might
> be checking out your script at some point.
> thanks,
> Adam
> ----------- Please Consult the Following Before Posting -----------
> TeX FAQ: http://www.tex.ac.uk/faq
> List Reminders and Etiquette: http://email.esm.psu.edu/mac-tex/
> List Archive: http://tug.org/pipermail/macostex-archives/
> TeX on Mac OS X Website: http://mactex-wiki.tug.org/
> List Info: http://email.esm.psu.edu/mailman/listinfo/macosx-tex

Alan T Litchfield
School of Computing and Mathematical Sciences
Faculty of Design and Creative Technologies
Auckland University of Technology
New Zealand	

More information about the MacOSX-TeX mailing list