CTAN Comprehensive TeX Archive Network

Directory support/excel2latex

README.md

Excel2

Making tables in 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 markup which can be pasted into an existing 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

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 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 Excel2.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 ToolsAdd-Ins. This way it will be loaded whenever Excel is opened.

Select the table to convert and hit the button Convert Table to . 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 editor). Hit the Store button to store the current settings so you can Load them later or Export All to files.Excel2LaTeX interface

Contributing

The development repository and the bug tracker for this package are hosted on GitHub. To work with the project, you will require chelh's VBA Sync Tool.

License

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

This work is distributed under the 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).

Download the contents of this package in one zip archive (102.9k).

Excel2 – Convert Excel spreadsheets to tables

Making tables in 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 markup which can be pasted into an existing document, or exported to a file and included via the \input command.

PackageExcel2LaTeX
Bug trackerhttps://github.com/ivankokan/Excel2LaTeX/issues
Repositoryhttps://github.com/ivankokan/Excel2LaTeX
Version3.5.0
LicensesThe Project Public License 1.3
Copyright1996–2016 Chelsea Hughes, Kirill Müller, Andrew Hawryluk, Germán Riaño, and Joachim Marder
MaintainerIvan Kokan
Andrew Hawryluk (inactive)
Chelsea Hughes (inactive)
Joachim Marder (inactive)
Kirill Müller (inactive)
George Pearson (inactive)
TopicsForeign import
...
Guest Book Sitemap Contact Contact Author