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.
## 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.
## 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).
|
