summaryrefslogtreecommitdiff
path: root/support/excel2latex/README.md
blob: d2bf8dffea20e4e99b152fc6d83104dc6e31cc75 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
# Excel2LaTeX
Making tables in LaTeX can be tedious, especially if some columns are calculated.
This converter allows you to write a table in Excel instead, and export the current selection as LaTeX markup
which can be pasted into an existing LaTeX document, or exported to a file and included via the `\input` command.

Known to be compatible with Windows Excel 2000–2016 (32-bit and 64-bit) and Mac Excel 2004, 2011, and 2016.
May also be compatible with other versions that support `.xla` add-ins.

![Excel and Excel2LaTeX comparison](https://i.imgur.com/UNKCihT.png)

## Features
Most Excel formatting is supported.
 * Bold and italic (if applied to the whole cell)
 * Left, right, center, and general alignment (per-cell or per-column)
 * Vertical and horizontal borders (per-cell or per-column, single or double)
 * Font color (using the `xcolor` package)
 * Fill color (using the `colortbl` package)
 * Rotation (using the `rotating` package)
 * Merged cells (using the `multirow` package, if needed)
 * Can convert `\`, `$`, `_`, `^`, `%`, `&`, and `#` to appropriate macros, or leave them in-place
 * Supports `booktabs` package
 * Uses `bigstrut` package when `booktabs` is not available
 * Makes standard LaTeX `tabular` environment
 * Can surround `tabular` environment with `table` environment template
 * Copy output to clipboard or export to a `.tex` file for inclusion using `\include`
 * Save table specifications to your Excel worksheet, then export all tables at once

## Using
Just open the file Excel2LaTeX.xla in Excel. Then you will have two additional 
menu items in your **Tools** menu and a new toolbar with two buttons on it. For 
Excel 2007 and later, you will have two new buttons in the **Add-Ins** ribbon. If 
you plan to use the program frequently, you can save it in your addin directory 
and add it with **Tools**→**Add-Ins**. This way it will be loaded whenever Excel is 
opened.

Select the table to convert and hit the button **Convert Table to LaTeX**. You 
will be given the option to save the result to a `.tex` file, or send it to the clipboard 
(so you can paste it into your LaTeX editor). Hit the **Store** button to store the 
current settings so you can **Load** them later or **Export All** to files.

![Excel2LaTeX interface](https://i.imgur.com/EK88upo.png)

## Contributing
The development repository and the bug tracker for this package are hosted on
[GitHub](https://github.com/krlmlr/Excel2LaTeX). To work with the project, you
will require chelh's [VBA Sync Tool](https://github.com/chelh/VBASync). 

## License
Copyright © 1996–2017 Chelsea Hughes, Kirill Müller, Andrew Hawryluk,
Germán Riaño, and Joachim Marder.

This work is distributed under the LaTeX Project Public License, version 1.3
or later, available at http://www.latex-project.org/lppl.txt

Chelsea Hughes currently maintains this project (comprising `Excel2LaTeX.xla`
and `README.md`) and will receive error reports at the project GitHub page
(see **Contributing** above).