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

[Alan T Litchfield]

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.

Cheers
Alan

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