[OS X TeX] Excel2Latex

Troy D Goodson Troy.D.Goodson at jpl.nasa.gov
Mon Jul 1 22:59:14 CEST 2002

FYI there's an old, but still useful, Excel macro called Excel2Latex.

It only does some pretty simple stuff, but many may find it useful to 
get a start on putting a table together.

As far as I can tell, it was written for Windows:
1) To open the file "Excel2LaTeX.xla" you have to use Excel's "File" 
menu and be sure to choose "List Files of Type:" "All Files"
2) You select your table and choose "Convert Table to Latex" from the 
"Tools" menu.
3) The GUI that pops up is obviously designed for Windows as the 
buttons are too short to fully display text
4) The "save to file" default path may have a "\" in it that you'll 
need to change to ":" for it put the file in right place.

Excel2LaTeX V2.0

It's difficult to create tables in LaTeX, especially if some columns 
are calculated. Excel2LaTeX allows you to transform the current 
selection from Excel to Latex. Most of the formatting will be kept 
(bold, italic, border lines, multicolumn cells, etc.). The LaTeX code 
can be copied to the clipboard or saved as a LaTeX file, which then 
can be included in an existing LaTeX document using the \input 
command . (Readme.txt)



Just open the file Excel2LaTeX.xla in Excel. Then you will have an additional
menu item in your 'Tools' menu and a new Toolbar with one button on it.
If you plan to use the program frequently you can save it in your addin
directory and add it with tools/add-in. This way it will be loaded whenever
excel is opened.

Threaded list archives can be found at:
To UNSUBSCRIBE, send email to <info at email.esm.psu.edu> with
"unsubscribe macosx-tex" (no quotes) in the body.
For additional HELP, send email to <info at email.esm.psu.edu> with
"help" (no quotes) in the body.

More information about the macostex-archives mailing list