Menu
CTAN
Comprehensive TeX Archive Network
Cover Upload Browse Search

Direc­tory tex-archive/support/xl2latex

xl2latex: Excel table to LaTeX tabular converter

Works only with Excel97 (and hopefully above, you never know what Microsoft does)
For color, package "colortbl" is needed (put \usepackage{colortbl} in preamble)

Copyright (C) 2001 Ronny Buchmann <rbla@gmx.de>

Ideas taken from Excel-To-Latex by Joachim Marder


INSTALLATION
~~~~~~~~~~~~
Import xl2latex.bas in Visual Basic and save as xl2latex.xls (or any other filename).

To do so: open a new file or a file with all your macros
          Extras->Macro->Visual Basic-Editor
          then in Visual Basic: File->File import
          close Visual Basic
          save the file (File->Save As or File->Save, what you want)
          close the file
          now you should have a new button "LaTeX export" in your "LaTeX" toolbar


USAGE
~~~~~
Select the area you want to expert and press the "Export LaTeX" button, you will
be prompted for a file name.

For further notes look inside the macro.


LICENSE
~~~~~~~
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA
or visit http://www.gnu.org

One note to the license and distribution:
It is not forbidden to distribute xl2latex as an Excel file (.xls), but be 
aware that it is a danger to open foreign files with macros inside, they can
potentially contain viruses. And I will never distribute it in an other form
than plain basic (.bas).

Files

Name Size Date Notes
LICENSE.txt 15145 2001-08-15 09:07
README.txt 1972 2001-08-15 09:07
xl2latex.bas 11564 2001-08-15 09:08

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

xl2la­tex – Con­vert Ex­cel (97 and above) ta­bles to LaTeX tab­u­lars

This Ex­cel to LaTeX con­verter ex­ports the cur­rent se­lec­tion as a LaTeX file which can be in­cluded via \in­put in your ac­tual doc­u­ment. It sup­ports mul­ti­col­umn cells (only hor­i­zon­tal), bor­ders, font styles (bold, italic), col­ored cells and text, LaTeX maths in cells and cells with wrapped text.

Pack­age De­tailsxl2la­tex
Li­censeGNU Gen­eral Public Li­cense
Main­tainerRonny Buch­mann
Topics im­port­ing data into doc­u­ments
Guest Book Sitemap Contact