[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
> 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
> from Excel. However, since I'm now stuck with Excel 2008 at work, I
> be checking out your script at some point.
> ----------- 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
More information about the MacOSX-TeX