Exceltex is a LaTeX package combined with a helper program written in Perl. It provides a easy to use yet powerfull and flexible way to get data from Spreadsheets into LaTeX.

In difference to other existing solutions, exceltex does not seek for making the creation of tables in LaTeX easier, but to get data from Spreadsheets into LaTeX as easy as possible.

The excel fileformat only acts as an interface between the spreadsheet application and exceltex beacause it is easily accessible via the Spreadsheet::ParseExcel Perl module and because most spreadsheet applications are able to read and write excel files.

# requirements

• The Spreadsheet::ParseExcel perl module is used to actually read the data.
• The LaTeX Packages ulem and color
• a Unix-like Operating System with LaTeX and Perl.

# usage

Exceltex is quite easy to use. Look at the following example:

% example.tex
\documentclass{article}
\usepackage{exceltex}

\begin{document}

\section{including cells}

Sheet1, B2:  \inccell{example.xls!Sheet1!B2}

you may omit the filename, if it has the same basename as the LaTeX
file ("example"): \inccell{Sheet1!B2}

\section{using with tabulars}

\begin{tabular}{ccc}
column 1 & column 2 & column 3 \\
\inctab{Sheet1!A2!C6}
\end{tabular}

\end{document}

now, run latex, exceltex and latex again:
latex example; exceltex example; latex example

# screenshots

 [180kB] [200kb]

# known problems and limitations

• not all Excel files are supported, see Spreadsheet::ParseExcel documentation for details.
• Characters and symbols which require macros in LaTeX (like greek letters etc.) are not supported
• Dont use any LaTeX control characters (\,^,_,#,{,},!) in filenames or Sheet names.
• # installation

Copy the exceltex script somewhere in your PATH (eg. /usr/local/bin, $HOME/bin) and exceltex.sty somehwere in your LaTeX package search path (eg. /usr/local/share/texmf/tex/latex/misc,$HOME/texmf/tex/latex/misc).

Debian/Ubuntu users may use the debian package provided below.

Current Version 0.5.1 (2006-04-30)
• bugfixes
deb http://www.physik.uni-freiburg.de/~doerr/debian/ ./