Comprehensive TeX Archive Network

Direc­tory macros/latex/contrib/exceltex


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 in into LaTeX as easy as possible.

The excel fileformat 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.


Exceltex depends on the perl module Spreadsheet::ParseExcel and the
LaTeX Packages ulem and color.

Currently a Unix like operating system is required, cygwin on windows
should work also.


Exceltex provides two commands to include single cells and cell-ranges
for tabulars. Load the exceltex LaTeX package via

   	includes cell B9 from sheet results in file foo.xls

    	includes  the  14  rows between B2 and F15 from sheet results
	in file foo.xls in LaTeX' tabular format ('&' separated rows
        ended by \\)

For both commands you may omit specifying the file (foo.xls) if it has
the same basename (foo) as the LaTeX file (foo.tex).


Mark cells and tabulars for inclusion with the \incell and \inctab
commands. Then run latex, exceltex and latex again.

The following Example demonstrates the usage of exceltex:

--- snip ---


\title{a brief introduction to exceltex}

\section{including single cells}

You can include contents of cells with the \\inccell command. Example:
Cell A1 on sheet 'Sheet1' of file foo.xls is:

\section{including tabulars}

this is as easy as including single cells.

  column 1 & colum 2 & colum 3 \\

--- snap ---

now, run latex, then exceltex and latex again.

The \inctab command does nothing else than provide the requested cells
in LaTeX' tabular format - colums are separated with a '&', each line
is endet with a line break (\\). This gives you a maximum of
flexibility and the freedom to use whatever tabular package you want.

Currently one package option is supported.
\usepackage[cellrefs]{exceltex} will write cell data to files named by
filename, workbook and cell instead of sequentially numbered files.


* Exceltex cannot read Excel files created by Spreadsheet::WriteExcel
  (see Spreadsheet::ParseExcel documentatin for details).

* Workbook names must not include problematic characters (LaTeX
  control Characters) (^,_,$,%,&,!). Just use Letters, Numbers and a
  Minus as spearator.  

* when using the cellrefs package option, whitespaces are also
  forbidden in workbook names and filenames. These are LaTeX
  limitations, i think.


The first LaTeX run writes an entry for each \inctab, \inccell command
to a spearate index file (\jobname.exltx). This index is then read by
the exceltex helper script, which actually extracts the ordered data
and writes it to sequentially numbered files in the directory
\jobname-exltx.  The \inctab and \inccell are then simply including
these files via a \InputIfExists{} command on the following latex runs.


Support for other formats than excels would be appreciating. There is
maybe a chance to get OpenOffice Calc working. There is now a module
OpenOffice::Parse::SXC on cpan which could to the job for Openoffice,
but it seems quite new and is not includeded in Ubuntu yet.  On the
other hand, support for different fileformats would yield a naming
problem, at the time i started with exceltex (in 2004) there was only
Spreadsheet::ParseExcel, so the name exceltex ....

The newest version of Exceltex is available at the following url:


exceltex is Copyright 2004-2006 by Hans-Peter Doerr

This is free software; see the source for copying conditions.  There
is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A

exceltex is distributed under the terms of the Gnu General Public
License (GPL) Version 2.  See COPYING for details.

README for exceltex version 0.5.1, Apr 30, 2006

Down­load the con­tents of this pack­age in one zip archive (15.4k).

Ex­cel­tex – Get data from Ex­cel files into

Ex­cel­tex is a pack­age com­bined with a helper pro­gram writ­ten in Perl. It pro­vides an easy to use yet pow­er­full and flex­i­ble way to get data from Spread­sheets into .

In con­trast to other so­lu­tions, ex­cel­tex does not seek to make the cre­ation of ta­bles in eas­ier, but to get data from Spread­sheets into as eas­ily as pos­si­ble.

The Ex­cel (TM) file for­mat only acts as an in­ter­face be­tween the spread­sheet ap­pli­ca­tion and ex­cel­tex bea­cause it is eas­ily ac­ces­si­ble (via the Spread­sheet::ParseEx­cel Perl mod­ule) and be­cause most spread­sheet ap­pli­ca­tions are able to read and write Ex­cel files.

Li­cense GNU Gen­eral Public Li­cense
Main­tainerHans-Peter Do­err
Con­tained inTeX Live as ex­cel­tex
MiKTeX as ex­cel­tex
Topics im­port files in a non- (or dif­fer­ent ) for­mat
Guest Book Sitemap Contact Contact Author