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

Timothy Van Zandt tvz1 at zandtwerk.org
Sun Sep 13 04:22:36 EDT 2009


This works perfectly and is a real time-saver. Thanks!!

It is a more general-purpose tool than you say. It converts any text in the
clipboard that is delimited by tab and cr.

I tried it with another spreadsheet program, Quantrix, and it didn't recognize
the new lines. I disovered that Quantrix copies stuff to the clipboard ending
lines in nl rather than cr. Perhaps you'd like to change the script so that it
it works with either nl or cl or nl-cr.

tim


Timothy Van Zandt
Professor of Economics
INSEAD
http://faculty.insead.edu/vanzandt


-------- Original Message --------
Subject: [OS X TeX] Excel tables to LaTeX - new script
From: Alan Munn <amunn at msu.edu>
To: macosx-tex at email.esm.psu.edu
Date: 15/7/09 02:55

> Hi everyone,
> 
> Tables are always a pain in the neck to write in LaTeX.  I used to use 
> an Excel macro xl2latex.xls which would convert an Excel table to LaTeX, 
> but now that I have the latest and greatest [sic] Excel 2008, which no 
> longer supports VB Macros I'm back to square 1.
> 
> A while ago when this discussion cropped up here, some one posted a nice 
> Ruby script by Tom Counsell which does the trick very nicely. I've now 
> taken Tom's script and modified it to make it support more table types, 
> and added an applescript which can be used as a TeXShop macro, so that 
> inserting an Excel table in TeXShop can now be as simple as copying from 
> Excel and pasting using the macro.
> 
> If you think you would find this useful, please try it out:
> 
> <https://www.msu.edu/~amunn/latex/xl2latex.zip>
> 
> Questions and comments (and bug reports?) are welcome.
> 
> I'd especially welcome additions to the documentation which would 
> explain how to use the script with editors other than TeXShop, since it 
> certainly can be.
> 
> Perhaps this would be a useful thing to add to TeXShop itself.
> 
> Alan
> 
> 
> ------------------------------------------------------------------------
> 
> ----------- 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
> 




More information about the MacOSX-TeX mailing list