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

Alan T Litchfield alan at alphabyte.co.nz
Thu Jul 16 00:02:56 EDT 2009

Had an initial run in TeXShop. No problems so far. This is going to be  
put into my "keep" directory.

The spreadsheet I was working with was too wide for the sheet size so  
I wrapped it with sidewaystable environment, which requires rotfloat.  
Might be a good idea to include that for wide tables(?)

I was wondering, a naive user might not know that they will need to  
include longtable if they use that function.


On 16/07/2009, at 1:03 PM, Alan T Litchfield wrote:

> Thanks Alan,
> This could get confusing ;)
> I tried the original ruby script and like what it produced very much.
> I will have a closer look at what your link includes when I have  
> half an hour to spare to play.
> Alan
> On 16/07/2009, at 12:31 PM, Alan Munn wrote:
>> At 11:39 AM +1200 7/16/09, Alan T Litchfield wrote:
>>> On 16/07/2009, at 9:27 AM, Alan Munn wrote:
>>>> Hi Alan, just to be clear, the script that I have posted is *not*  
>>>> a VB script. It's written in Ruby and operates directly on the  
>>>> clipboard contents and so is compatible with Office 2008 (which  
>>>> is what motivated me to use this method in the first place, since  
>>>> I also have Office 2008.)
>>> umm, ok. Treading carefully here...
>>> I just read from the description on CTAN this "Import xl2latex.bas  
>>> in Visual Basic and save as xl2latex.xls (or any other filename)."  
>>> and assumed it was a VB script ;)
>>> Alan
>> Yes, there is perhaps a naming problem, but all the good names are  
>> taken!  The xl2latex.bas is indeed a VB script. I haven't posted my  
>> script to CTAN yet; I was posting it here for comments and informal  
>> testing. You can get a copy here on my web page:
>> <http://www.msu.edu/~amunn/latex/xl2latex.zip>
>> As noted in another message, it's not as fancy as the VB script;  
>> but it still saves quite a bit of messing around either in Excel or  
>> in your favourite LaTeX editor, and is fully compatible with Office  
>> 2008.
>> 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