2008-09-16

Excel and LaTeX?

If you want to use Excel table in LaTeX document you can:
  • retype it in LaTeX syntax --> not recommended, especially if a table can change
  • save as CSV and use csv2latex
  • use excel2latex addon for Excel --> this is a very handy solution
  • open Excel file in some other spreadsheet that has the ability to save as LaTeX file, e.g., Gnumeric
See also PC -> LaTeX Converter Quick Comparison List

3 komentarji:

Yihui Xie said...

You can also read the data into R and use the R package "xtable" to get the LaTeX code from a matrix/data.frame; that's what I usually do :-)

Anonymous said...

The simplest way, for small tables anyway. Is to just add a column of "&" between each entry and a column of "\\" at the end. Then just paste this in between your table and tabular commands.

Gregor Gorjanc said...

Finnaly, one could also use LyX where one can insert table and its content much more easily than directly in LaTeX. At the end one can then export to LaTeX.