# tables from excel to tex [duplicate]

Possible Duplicate:
Comprehensive list of tools that simplify the generation of LaTeX tables

I have some tables in excel. I use `excel2latex` to generate the LaTeX code to insert them into by document. `excel2latex` seems to mess things up pretty badly: horizontal lines, vertical text, etc. What other options are there for generating tables that do not require typing out all the tex code by hand for the table and maintain nice formatting?

-

## marked as duplicate by Qrrbrbirlbel, Werner, Alan Munn, lockstep, cgniederOct 7 '12 at 8:48

1. If you like the formatting you do with Excel, you will probably not be able to get it in LaTeX anyway, or only with significant effort. Why not saving your original table as a .PNG file or so and get it into LaTeX via `\includegraphics{}`?
2. Depending upon the distribution you are using, you may have the `datatools` package ready for you already. Try putting `\usepackage{datatool-pgfmath}` in your preamble and `1=2: \dtlifnumeq{1}{2}{true}{false}.` in your document. If it compiles to 1=2: false you can go to the datatool ftp site, grab the manual and start reading on page 38. This gives you easy access to the data (simply save your table as .CSV file), but you would have to do the formatting by hand, arguably with less effort than using LaTeX commands (see page 56 for a colourful table).
3. Personally, I import Excel data into `R` from where there is an abundance of options for transforming data frames into LaTeX code - if you have some level of familiarity with `R`, you might want to explore this.
@alex .PNG I produce with a screenshot; larger tables you could get via printing to .PDF although this may be too large then to be included via `\includegraphics{}`. For pre-formatting using R see rseek –  vaettchen Oct 7 '12 at 4:45