[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.
> 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 ;)
>> 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:
>> 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
> ----------- 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