CTAN
Comprehensive TeX Archive Network

Direc­tory support/excel2latex

README.md

Ex­cel2LaTeX

v3.4.2

Mak­ing ta­bles in LaTeX can be te­dious, es­pe­cially if some columns are cal­cu­lated. This con­verter al­lows you to write a ta­ble in Ex­cel in­stead, and ex­port the cur­rent se­lec­tion as LaTeX markup which can be pasted into an ex­ist­ing LaTeX doc­u­ment, or ex­ported to a file and in­cluded via the \input com­mand.

Known to be com­pat­i­ble with Win­dows Ex­cel 2000–2016 (32-bit and 64-bit) and Mac Ex­cel 2004, 2011, and 2016. May also be com­pat­i­ble with other ver­sions that sup­port .xla add-ins.Excel and Excel2LaTeX comparison

Fea­tures

Most Ex­cel for­mat­ting is sup­ported.

  • Bold and italic (if ap­plied to the whole cell)
  • Left, right, cen­ter, and gen­eral align­ment (per-cell or per-col­umn)
  • Ver­ti­cal and hor­i­zon­tal bor­ders (per-cell or per-col­umn, sin­gle or dou­ble)
  • Font color (us­ing the xcolor pack­age)
  • Fill color (us­ing the colortbl pack­age)
  • Ro­ta­tion (us­ing the rotating pack­age)
  • Merged cells (us­ing the multirow pack­age, if needed)
  • Can con­vert \, $, _, ^, %, &, and # to ap­pro­pri­ate macros, or leave them in-place
  • Sup­ports booktabs pack­age
  • Uses bigstrut pack­age when booktabs is not avail­able
  • Makes stan­dard LaTeX tabular en­vi­ron­ment
  • Can sur­round tabular en­vi­ron­ment with table en­vi­ron­ment tem­plate
  • Copy out­put to clip­board or ex­port to a .tex file for in­clu­sion us­ing \include
  • Save ta­ble spec­i­fi­ca­tions to your Ex­cel work­sheet, then ex­port all ta­bles at once

Us­ing

Just open the file Ex­cel2LaTeX.xla in Ex­cel. Then you will have two ad­di­tional menu items in your Tools menu and a new tool­bar with two but­tons on it. For Ex­cel 2007 and later, you will have two new but­tons in the Add-Ins rib­bon. If you plan to use the pro­gram fre­quently, you can save it in your addin di­rec­tory and add it with ToolsAdd-Ins. This way it will be loaded when­ever Ex­cel is opened.

Select the ta­ble to con­vert and hit the but­ton Con­vert Ta­ble to LaTeX. You will be given the op­tion to save the re­sult to a .tex file, or send it to the clip­board (so you can paste it into your LaTeX ed­i­tor). Hit the Store but­ton to store the cur­rent set­tings so you can Load them later or Ex­port All to files.Excel2LaTeX interface

Con­tribut­ing

The de­vel­op­ment repos­i­tory and the bug tracker for this pack­age are hosted on GitHub. To work with the project, you will re­quire chelh's VBA Sync Tool.

Li­cense

Copy­right © 1996–2016 Chelsea Hughes, Kir­ill Müller, An­drew Hawry­luk, Ger­mán Ri­año, and Joachim Marder.

This work is dis­tributed un­der the LaTeX Project Public Li­cense, ver­sion 1.3 or later, avail­able at http://www.la­tex-project.org/lppl.txt

Chelsea Hughes cur­rently main­tains this project (com­pris­ing Excel2LaTeX.xla and README.md) and will re­ceive er­ror re­ports at the project GitHub page (see Con­tribut­ing above).

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

Ex­cel2LaTeX – Con­vert Ex­cel spread­sheets to LaTeX ta­bles

Mak­ing ta­bles in LaTeX can be te­dious, es­pe­cially if some columns are cal­cu­lated. This con­verter al­lows you to write a ta­ble in Ex­cel in­stead, and ex­port the cur­rent se­lec­tion as LaTeX markup which can be pasted into an ex­ist­ing LaTeX doc­u­ment, or ex­ported to a file and in­cluded via the \in­put com­mand.

Pack­ageEx­cel2LaTeX
Home pagehttps://github.com/krlmlr/Ex­cel2LaTeX
Ver­sion3.4.2
Li­censeThe LaTeX Project Public Li­cense 1.3
Main­tainerChelsea Hughes
An­drew Hawry­luk (in­ac­tive)
Joachim Marder (in­ac­tive)
Ge­orge Pear­son
Kir­ill Müller
Topics im­port files in a non-TeX (or dif­fer­ent TeX) for­mat
...
Guest Book Sitemap Contact Contact Author